I am attempting to migrate a MySQL driven web application that, in my opinion, was designed by a stupid monkey. The php web frontend dynamically creates tables to store chunks of data rather than just adding rows to existing tables. Don't ask me why! However, when attempting to migrate the entire database to another system via mysqldump, mysql gives an error which I assume is associated with the tables being named by number rather than by name. The error is as follows:
./mysqldump: Can't get CREATE TABLE for table '100007' (You have an error in your SQL syntax near '100007' at line 1) Also, the only way to select data from one of the tables is to use ticks in the from statement: mysql> use MYSTUPIDDATABASE; mysql> show tables; ... ... ... 2777 rows in set... <-- in other words, there are 2777 dynamically created tables, all named by numbers mysql> select * from 999994; <-- without ticks ERROR 1064: You have an error in your SQL syntax near '999994' at line 1 mysql> select * from `999994`; <-- with ticks .... that works. however, how do I make it so mysqldump can build the create statement correctly for these tables? Augey Mikus --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
