Re: Weird mysql problem
Re: Weird mysql problem
- Subject: Re: Weird mysql problem
- From: Klaus Berkling <email@hidden>
- Date: Sun, 5 Sep 2010 17:32:02 -0700
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 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."
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. |
_______________________________________________
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