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
[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
