Weird mysql problem
Weird mysql problem
- Subject: Weird mysql problem
- From: Mark Woollard <email@hidden>
- Date: Sun, 5 Sep 2010 09:21:46 -0400
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden