Re: Create Table Warning
> 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) I would say the warning is caused by TYPE=MyISAM. TYPE= is deprecated in 5.x, and is being replaced by ENGINE=. If you execute SHOW WARNINGS right after a statement that generates warnings, you will see the warning text. Cheers Baron %% mysql> show warnings; +-+--+--+ | Level | Code | Message | +-+--+--+ | Warning | 1287 | 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead | +-+--+--+ 1 row in set (0.00 sec) %% Yup, that's it. Thanks, Baron and Rhys. Kind Regards, David
RE: Create Table Warning
Do a "SHOW WARNINGS" at the command line. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 June 2007 16:11 To: mysql@lists.mysql.com Subject: Create Table Warning 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) This email is confidential and may also be privileged. If you are not the intended recipient please notify us immediately by telephoning +44 (0)20 7452 5300 or email [EMAIL PROTECTED] You should not copy it or use it for any purpose nor disclose its contents to any other person. Touch Local cannot accept liability for statements made which are clearly the sender's own and are not made on behalf of the firm. Touch Local Limited Registered Number: 2885607 VAT Number: GB896112114 Cardinal Tower, 12 Farringdon Road, London EC1M 3NN +44 (0)20 7452 5300 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Create Table Warning
Hi , [EMAIL PROTECTED] wrote: 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) I would say the warning is caused by TYPE=MyISAM. TYPE= is deprecated in 5.x, and is being replaced by ENGINE=. If you execute SHOW WARNINGS right after a statement that generates warnings, you will see the warning text. Cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]