This is a create table statement output from mysqldump from a 4.0.24 installation.
Restoring on 5.0.22 gives a warning. Can anyone enlighten me? I guess I'm a little behind on my reading... David mysql> CREATE TABLE `container` ( -> `carrier` varchar(128) NOT NULL default '', -> `lock1` varchar(7) NOT NULL default '', -> `lock2` varchar(7) NOT NULL default '', -> `lock3` varchar(7) NOT NULL default '', -> `lock4` varchar(7) NOT NULL default '', -> `lock5` varchar(7) NOT NULL default '', -> `lock6` varchar(7) NOT NULL default '', -> `lock7` varchar(7) NOT NULL default '', -> `lock8` varchar(7) NOT NULL default '', -> `lock9` varchar(7) NOT NULL default '', -> `lock10` varchar(7) NOT NULL default '', -> `lock11` varchar(7) NOT NULL default '', -> `lock12` varchar(7) NOT NULL default '', -> `lock13` varchar(7) NOT NULL default '', -> `lock14` varchar(7) NOT NULL default '', -> `lock15` varchar(7) NOT NULL default '', -> `lock16` varchar(7) NOT NULL default '', -> `lock17` varchar(7) NOT NULL default '', -> `lock18` varchar(7) NOT NULL default '', -> `lock19` varchar(7) NOT NULL default '', -> `lock20` varchar(7) NOT NULL default '', -> `lock21` varchar(7) NOT NULL default '', -> `lock22` varchar(7) NOT NULL default '', -> `lock23` varchar(7) NOT NULL default '', -> `lock24` varchar(7) NOT NULL default '', -> PRIMARY KEY (`carrier`) -> ) TYPE=MyISAM; Query OK, 0 rows affected, 1 warning (0.00 sec)