[CLUG-tech] A table called #
meistrch at intekom.co.za
Tue Dec 4 16:30:51 SAST 2007
Ben Bartrum wrote:
> I have a MySQL 4.0.20 database, and I created a dump file of it. When I tried to import it on another server (different platform), I get this error:
> ERROR 1064 at line 11: 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 'varchar(255) default NULL,
> id varchar(255) default NULL,
> 'Show tables' on the original server shows there is a table called # (really just #)
> When I look at the sqldumpfile, line 11 shows:
> CREATE TABLE # (
> If I change this to
> CREATE TABLE `#` (
> (using backticks) it works. But how can I prevent this from happening every time?
> FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!
> Check it out at http://www.inbox.com/marineaquarium
I cannot check now, but does mysqldump not have the option to enclose table names with backticks?
More information about the clug-tech