Thank you very much for your quick and accurate responses. I tried to dump with the -Q (--quote-names) and it perfectly works.
I'm not completely sure I understood what Tod Harter meant in his mail, because I set up an 'automated' backup process, and if I would ever need to recovery our main DB, I would not like to manually edit the SQL script generated by mysqldump, so I can't remove indexes creation before uploading data. My only doubt remains if there could ever be any concern about quoting names while dumping; I mean, if not, why don't setting it as the default? Anyway thank you very much again, the problem is solved. Regards, Stefano > -----Original Message----- > From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] > Sent: 21 June 2002 16:31 > To: [EMAIL PROTECTED] > Subject: Re: MySQL dump/recovery probable bug > > > Stefano, > Friday, June 21, 2002, 4:43:29 PM, you wrote: > > SI> I found the following problem, which I consider a bug, > but maybe I'm missing something to make it work correctly. > > SI> I'm using 'mysqldump' to backup our MySQL DB, and when I > try to recover it on a blank DB it gives syntax errors while > creating some table. > SI> This is the Table structure which cause the error : > > [skip] > > SI> When I try to run this command on the mysql console, I > receive the following error : > SI> mysql> CREATE TABLE Test ( > SI> -> ID int(10) unsigned NOT NULL auto_increment, > SI> -> IL varchar(12) NOT NULL default '', > SI> -> Item_ID int(10) unsigned NOT NULL default '0', > SI> -> BLDate datetime NOT NULL default '0000-00-00 00:00:00', > SI> -> RelToTest datetime default NULL, > SI> -> RelToRegr datetime default NULL, > SI> -> RelToNPI datetime default NULL, > SI> -> RelToCCO datetime default NULL, > SI> -> SanityResult enum('None','Green','Red') NOT NULL > default 'None', > SI> -> PRIMARY KEY (ID), > SI> -> UNIQUE KEY Load (IL,Item_ID) > SI> -> ) TYPE=MyISAM COMMENT='SCM Internal Loads table'; > SI> ERROR 1064: You have an error in your SQL syntax near > 'Load (IL,Item_ID) > SI> ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12 > > [skip] > > SI> Is really urgent for us to solve this problem, because > our DB is growing fast and we would like to have a consistent Backup. > SI> If I'm doing something wrong, please tell me. > > LOAD is a reserved word: > http://www.mysql.com/doc/R/e/Reserved_words.html > > It's not recommended to use reserved words in table/column/key etc > names... > You can fix you problem just quoting LOAD with a ``' characters. Use > -Q or --quote-names option of mysqldump. > > SI> Best Regards, > SI> Stefano > > > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored > by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
