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

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-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 b

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 Keith C. Ivey
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 around it. Have you tried using the --quote-name