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/archive%40mail-archive.com This email sent to [email protected]
