Re: MySQL dump/recovery probable bug

2002-06-24 Thread Georg Richter
On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Hi, I found the following problem, which I consider a bug, but maybe I'm missing something to make it work correctly. This is not a bug. Why do you use a reserved word (LOAD) for an index name?! Rename it and everything should be ok.

Re: MySQL dump/recovery probable bug

2002-06-24 Thread Michael Widenius
Hi! Georg == Georg Richter [EMAIL PROTECTED] writes: Georg On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Georg Hi, I found the following problem, which I consider a bug, but maybe I'm missing something to make it work correctly. Georg This is not a bug. Why do you use a

Re: MySQL dump/recovery probable bug

2002-06-21 Thread Victoria Reznichenko
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

Re: MySQL dump/recovery probable bug

2002-06-21 Thread Tod Harter
On Friday 21 June 2002 09:54, Keith C. Ivey wrote: On 21 Jun 2002, at 15:43, Stefano Incontri wrote: ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID) ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12 LOAD is a reserved word in MySQL, so you need backticks