I'm trying to dump and import a database that has only numeric table names. There isn't much I can do about the naming convention and I know it should not be numeric but that's how it is!
The problem I have is that dumping is ok but when I try to import it I get the following error:
Unknown table '0'
this occurs at the following line:
DROP TABLE IF EXISTS `0`;
So the question is, is there a way to dump the database and include the database name in front of the table name (workbench does this automatically) or can I change my import so it appends the database name during the import to get this working?
CREATE TABLE `dbname`.`0` ( ... )
Or is there any other way of resolving this ?