I created the file with ver 3.23.43, tried to recreate database on 3.22.32. I administer 2 other databases the same commands and they work fine. I looked at the difference in the sql files, and those ones don't contain the PACK_KEYS statement...just TYPE=myISAM. The command used to create the sql files hasn't changed, and the databases are hosted by the same ISP. It's a confusing situation. I don't want to have to go back and manually change each .sql file each day to complete the backup process. I wouldn't get any other work done.
Any other suggestions? Steve [EMAIL PROTECTED] ----- Original Message ----- From: "Steve Werby" <[EMAIL PROTECTED]> To: "Steve Osborne" <[EMAIL PROTECTED]>; "MySQL (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, November 30, 2001 2:58 PM Subject: Re: SQL syntax error > "Steve Osborne" <[EMAIL PROTECTED]> wrote: > > I am receiving the following error when I try to restore a database backup > > from an .sql file: > > ERROR 1064 at line 12: You have an error in your SQL syntax near > > 'PACK_KEYS=1' at line 11 > <snip> > > ) TYPE=ISAM PACK_KEYS=1; > </snip> > > > > Cmd used to create sql: > > mysqldump --user=username --add-drop-table -pblahblah > > dbdatabasename>filename.sql > > > > Cmd used to restore from sql: > > mysql --user=root -p backupdatabasename<filename.sql > > You didn't mention your version of MySQL, but I suspect it's old. Remove > the "PACK_KEYS=1" text and it should work fine. I also suggest upgrading to > a more recent MySQL if in fact you're running an older version. > > -- > Steve Werby > President, Befriend Internet Services LLC > http://www.befriend.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
