I've got a similar problem once. Didn't try to solve it. I dropped
the database, create a new one and do the restore into it.
Just my 2 cts.
David B.
Le 5 sept. 10 à 13:31, Paul D Yu a écrit :
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/bon_d%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]
