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
