Re: Problem when upgrading to MySql 5

Ok, here ya go.  This is just 1 of the databases I'm fighting with.... :)

SET @@sql_mode = 'ANSI_QUOTES';
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, 
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;


CREATE DATABASE /*!32312 IF NOT EXISTS*/ `serenity`;
USE `serenity`;
CREATE TABLE "test" (
  "OrderID" smallint(5) unsigned NOT NULL default '0',
  "ModelID" smallint(5) unsigned NOT NULL default '0',
  "test" enum('Y','N') NOT NULL default 'Y',
  "ModelDesc" varchar(40) default NULL,
  PRIMARY KEY  ("OrderID"),
  KEY "ModelID" ("ModelID")
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE "mailings" (
  "Cust_ID" int(6) NOT NULL auto_increment,
  "Cust_Name" varchar(50) NOT NULL default '',
  "Cust_Address" varchar(50) NOT NULL default '',
  "Cust_City" varchar(15) NOT NULL default '',
  "Cust_State" char(2) NOT NULL default '',
  "Cust_Email" varchar(35) default NULL,
  "Cust_EmailNews" varchar(7) NOT NULL default '',
  "Cust_EmailSpecials" varchar(7) NOT NULL default '',
  "Cust_Email_Type" tinyint(1) NOT NULL default '0',
  "Cust_DateAdded" date NOT NULL default '0000-00-00',
  "Cust_DateModified" date default '0000-00-00',
  "Cust_UUID" varchar(50) NOT NULL default '',
  "Cust_Verified" varchar(5) NOT NULL default 'No',
  "Cust_Zip" varchar(10) NOT NULL default '',
  "ResendCount" int(1) unsigned zerofill NOT NULL default '0',
  "Cust_UserName" varchar(11) NOT NULL default '',
  "Cust_Pass" blob NOT NULL,
  PRIMARY KEY  ("Cust_ID")
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

after all the inserts, we have:

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Steve

"Todd Farmer" <[email protected]> wrote in message 
news:[email protected]...
> Steve Grosz wrote:
>> I get the same result, just with the error being on line 14 instead of 13 
>> since I added the line at the top
>
> Can you post the CREATE TABLE command that starts at line 13/14 of the 
> backup (no data, just the CREATE TABLE command in its entirety)?  Even 
> better, everything up through the end of the CREATE TABLE command (you can 
> leave INSERT statements out, but I doubt there are any, as it appears to 
> fail at the first DDL operation).
>
>
> -- 
> Todd Farmer, Support Engineer, Americas
> MySQL Inc., www.mysql.com
>
> Discover new MySQL Monitoring & Advisory features at:
> http://www.mysql.com/products/enterprise/whats_new.html
> 


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]