Pack keys is the only flag that we had trouble with when we were upgrading. As an emergency fix you could use the following to restore:
sed -e "s/PACK_KEYS=1//g" < filename.sql | mysql --user=root -p backupdatabasename Jon Gardiner. > -----Original Message----- > From: Steve Osborne [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 06, 2001 4:01 PM > To: MySQL (E-mail) > Subject: removing PACK_KEYS > > > HELP PLEASE !! > > I have run into a problem where my ISP upgraded their mysql > version, and now > the dump files (.sql) from the mysqldump command cannot be > restored on my > local server. Unfortunately, I have to wait for our server > to be updated, > so the simplest solution is not an option. The error that I have been > receiving is as follows: > > ERROR 1064 at line 12: You have an error in your SQL syntax near > 'PACK_KEYS=1' at line 11 > > Dump file excerpt: > DROP TABLE IF EXISTS Advertisers; > CREATE TABLE Advertisers ( > AdvertisersKey smallint(5) unsigned NOT NULL auto_increment, > AdvertiserID int(11) NOT NULL default '0', > Advertiser char(50) NOT NULL default '', > AdvertiserFr char(50) default NULL, > AdvertDescr char(250) default NULL, > PRIMARY KEY (AdvertisersKey), > UNIQUE KEY AdvertiserID (AdvertiserID), > KEY IdxAdvert (Advertiser(10)), > UNIQUE KEY Advertiser (Advertiser) > ) TYPE=ISAM PACK_KEYS=1; > > 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 > > It has been suggested that I use: ALTER TABLE Advertisers > PACK_KEYS=0; > I have done this, however I receive the same error, at the same line > location, so the PACK_KEYS value is not an issue. > > The ISP's version of mysql is 3.23.43. > My version is 3.22.32. > I know this is a very old version, but as I've said, I cannot > upgrade it at > this time. > > This problem is taking a lot of time to fix, and work is > getting put off > trying to solve it. Is there anyone who has a solution? > > Steve Osborne > Database Programmer > Chinook Multimedia Inc. > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > 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
