What is the case insensitivity on MySQL set to? Paul On Sep 5, 2010, at 9:21 AM, Mark Woollard wrote:
> I am trying to take a backup of a mysql database used by WO app from a live > server and restoring onto my laptop so I can test the migration code in the > new version with a live data set. I've created a sql script from the live > database using backup feature of mysqlworkbench. However when I try to import > this into mysql running on the laptop I get the following error: > > Error Code: 1050 > Table 'eo_pk_table' already exists > > but the table doesn't exist as far as I can tell, the sql for creating the > table is: > > DROP TABLE IF EXISTS `EO_PK_TABLE`; > /*!40101 SET @saved_cs_client = @@character_set_client */; > /*!40101 SET character_set_client = utf8 */; > CREATE TABLE `EO_PK_TABLE` ( > `NAME` char(40) default NULL, > `PK` int(11) default NULL > ) ENGINE=MyISAM DEFAULT CHARSET=utf8; > /*!40101 SET character_set_client = @saved_cs_client */; > > And this happens even if I drop the database before trying the import. > > Any ideas as I can't see why this is happening... > > Thanks > Mark > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/pyu%40mac.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
