Imran, Thanks for your reply. I tried what you asked, and it did the same. I then went onto a couple of other boxes with EXACTLY the same MySQL install and they worked (added the auto_increment).
The box that fails is running Redhat 7.3 (for customer backward compatibilty). I dont have any other 7.3 boxes to try - everything else is newer. The my.cnf configuration files are pretty much the same on all installs. The version we are using is (tarball install)... mysql-standard-4.1.16-pc-linux-gnu-i686 The box where it doesnt work is the one on which it is most needed! Many Regards, Ian. On 4/13/06, Imran Chaudhry <[EMAIL PROTECTED]> wrote: > > Strange, I created the same table using your definition in my test > database: > > MySQL [EMAIL PROTECTED] test> show create table tbl; > > +-------+--------------------------------------------------------------------------------------------------+ > | Table | Create Table | > > +-------+--------------------------------------------------------------------------------------------------+ > | tbl | CREATE TABLE `tbl` ( > `id` int(11) NOT NULL auto_increment, > PRIMARY KEY (`id`) > ) TYPE=MyISAM | > > +-------+--------------------------------------------------------------------------------------------------+ > 1 row in set (0.00 sec) > > And then with mysqldump: > > [EMAIL PROTECTED]:/var/www/partner.smoothwall.net/db$ mysqldump test > tbl --add-drop-table -Q > > -- MySQL dump 9.11 > -- > -- Host: localhost Database: test > -- ------------------------------------------------------ > -- Server version 4.0.24_Debian-10ubuntu2-log > > -- > -- Table structure for table `tbl` > -- > > DROP TABLE IF EXISTS `tbl`; > CREATE TABLE `tbl` ( > `id` int(11) NOT NULL auto_increment, > PRIMARY KEY (`id`) > ) TYPE=MyISAM; > > Can you try again in one step? Create the table and then immediately > exit the client and mysqldump it. > > -- > http://www.ImranChaudhry.info > MySQL Database Management & Design Services >