"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
