From: Dan Nelson
Date: November 30 2001 11:36pm
Subject: Re: SQL syntax error
List-Archive: http://lists.mysql.com/mysql/92800
Message-Id: <20011130233652.GA98990@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Nov 30), Steve Osborne said:
> 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?

* Upgrade the 2nd server to mysql 3.23 (preferable).  It's really old.

* Remove the PACK_KEYS flag from the 1st server's tables.

  mysql> ALTER TABLE mytable PACK_KEYS=0;

* Parse the mysqldump output to remove the PACK_KEYS flag before loading:

  mysqldump -h oldhost db | sed -e 's/ PACK_KEYS=1//' | mysql -h newhost db

-- 
	Dan Nelson
	dnelson@stripped