Bonjour,
J'épluche les forum et les bases de connaissances MySQL depuis quelques mois déjà, et je ne parviens pas à solutionner un message d'avertissement.
En fait, il est apparu à la suite (je suppose) d'une MAJ MySQL.
Le voici :
Code :
- 100822 20:06:40 [Warning] Invalid (old?) table or database name '#sql-1e0_2af7'
- 100822 20:06:40 [Warning] Invalid (old?) table or database name '#sql-1e0_2af7'
- 100822 20:55:38 [Warning] Invalid (old?) table or database name '#sql-1e0_3013'
- 100822 20:55:38 [Warning] Invalid (old?) table or database name '#sql-1e0_3013'
- 100823 6:41:30 [Warning] Invalid (old?) table or database name '#sql-1e0_4a9c'
- 100823 6:41:30 [Warning] Invalid (old?) table or database name '#sql-1e0_4a9c'
- 100823 11:48:54 [Warning] Invalid (old?) table or database name '#sql-1e0_53b8'
- 100823 11:48:54 [Warning] Invalid (old?) table or database name '#sql-1e0_53b8'
|
Problème, j'ai dû tester quasiment toutes les solutions trouvées sur le net.
Mon fichier my.ini est le suivant (et n'a pas changé entre le moment ou le message n'existait pas et maintenant (d'ailleurs, si vous avez des conseils afin de régler cela un poil mieux, je suis preneur) :
Code :
- # MySQL Server Instance Configuration File
- [client]
- port = 3306
- socket = mysql.sock
- [wampmysqld]
- # The TCP/IP Port the MySQL Server will listen on
- port = 3306
- bind-address = 127.0.0.1
- #Path to installation directory. All paths are usually resolved relative to this.
- basedir = d:/wamp/bin/mysql/mysql5.1.50
- #log file
- log-error = d:/wamp/logs/mysql.log
- #Path to the database root
- datadir = d:/wamp/databases
- # The default storage engine that will be used when create new tables when
- default-storage-engine = innodb
- key_buffer_size = 128M
- query_cache_size = 128M
- #max_allowed_packet = 1M
- max_heap_table_size = 256M
- #myisam_max_sort_file_size = 400k
- myisam_sort_buffer_size = 128M
- #read_buffer_size = 2M
- #read_rnd_buffer_size = 8M
- #sort_buffer_size = 768k
- #table_cache = 943
- #table_cache = 891
- #table_open_cache = 1024
- #thread_cache_size = 24
- tmp_table_size = 128M
- # Try number of CPU's*2 for thread_concurrency
- thread_concurrency = 4
- #*** INNODB Specific options ***
- innodb_additional_mem_pool_size = 4M
- innodb_log_buffer_size = 1M
- innodb_buffer_pool_size = 15M
- innodb_log_file_size = 10M
- innodb_thread_concurrency = 4
- innodb_flush_log_at_trx_commit = 0
- #Name of the socket file (Unix) or named pipe (Windows) to use.
- socket = mysql.sock
- #Path to the temporary directory.
- tmpdir = D:/wamp/tmp
- #Don't allow new user creation by the user who has no write privileges to the mysql.user table.
- safe-user-create
- #Allow big result sets by saving all temporary sets on file (Solves most 'table full' errors).
- big-tables
- #Le support des liens symboliques, permet de faciliter le stockage de tables sur plusieurs disques durs.
- #skip-symbolic-links
- #Don't resolve hostnames. All hostnames are IP's or 'localhost'.
- skip-name-resolve
- #empêche les verrous externes
- #skip-external-locking
- skip-federated
- #Lock mysqld in memory.(=Don't swap.)
- memlock
- [mysqld]
- # The TCP/IP Port the MySQL Server will listen on
- port = 3306
- bind-address = 127.0.0.1
|
