On Sep 5, 2010, at 6:31 AM, Paul D Yu wrote: > 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: >> [...]
I had a similar problem. I also could not drop certain tables so maybe this helps: I now have this in my /etc/my.cnf: lower_case_table_names = 1 MySQL says this: "1: Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases." (http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html) I also changed all my table names to lowercase in the EOModel to make sure. kib "Success is not final, failure is not fatal: it is the courage to continue that counts." Winston Churchill Klaus Berkling Web Application Dev. & Systems Administrator DynEd International, Inc. www.dyned.com | www.eskimo.com/~kiberkli
_______________________________________________ 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]
