I have a database called abc-100 which seems to cause problems with replication and importing sql files created with mysqldump.
First, if on the master we create a temporary table (because we don't have subselects yet) it causes the slave to die with the following. Relay log says: DROP /*!40005 TEMPORARY */ TABLE abc-100.temp_summary And the error log says: ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-100.temp_summary Second, on doing a mysql < dump.sql for a database restore, I have to manually edit the dump file first and use `` around the abc-100. So, apparently the - or the -100 is an invalid database name? If so, why would mysql allow me to create it in the first place? Is there any way to make this work without changing the database name? Changing the name is not a trivial matter because I am dealing with many databases with the same issue, 100, 101, 102 etc. I am more concerned with replication than the dump.sql as I can always edit the database names to be contained in ``. Thanks for any help you can offer. Jon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
