This is the setting I use in my.cnf (read the comments, especially last line before trying this)
<snip> # If set to 0, table names are stored as specified and comparisons are case # sensitive. If set to 1, table names are stored in lowercase on disk and # comparisons are not case sensitive. If set to 2, table names are stored as given # but compared in lowercase. This option also applies to database names and table # aliases. For additional information, see Section 8.2.2, “Identifier Case # Sensitivity”. # You should not set this variable to 0 if you are running MySQL on a system that # has case-insensitive file names (such as Windows or Mac OS X). If you set this # variable to 0 on such a system and access MyISAM tablenames using different # lettercases, index corruption may result. On Windows the default value is 1. On # Mac OS X, the default value is 2. # If you are using InnoDB tables, you should set this variable to 1 on all # platforms to force names to be converted to lowercase. Prior to MySQL Cluster # NDB 6.3.35, MySQL Cluster NDB 7.0.15, and MySQL Cluster NDB 7.1.4, this is also # true for tables using the NDB storage engine. # KK: We want setting of 1 for innodb and linux compatability # KK: Do not change this to 1 without first changing the actual table names to lower case first lower_case_table_names = 1 </snip> Also here is a simple *quick hack* script for converting a database's tables all to lowercase names. Understand it and take necessary precautions before using:
ConvertMySQLTableNamesLowerCase.sh
Description: Binary data
HTH, Kieran On Jul 16, 2012, at 9:48 AM, Jean Pierre Malrieu wrote: > Thank you both. It works. > Now discovering that on UNIX, mysql table name are case sensitive... Grrrr! > > Le 16 juil. 2012 à 15:00, Pascal Robert a écrit : > >> >> Le 2012-07-16 à 08:58, Jean Pierre Malrieu a écrit : >> >>> Meaning you add it directly in the "Libraries" folder and ant build picks >>> it up? >> >> Yes. >> >>> Le 16 juil. 2012 à 14:26, Paul Yu a écrit : >>> >>>> I embed the jdbc library in my app bundle, >>>> >>>> Sent from my iPad >>>> >>>> On Jul 16, 2012, at 8:07 AM, Jean Pierre Malrieu <[email protected]> >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> I am trying my first deployment on LINUX, and thanks to the instructions >>>>> in the wiki, things seem to work more or less (application deployed and >>>>> launched). >>>>> But I have got an exception (cannot obtain database channel) when trying >>>>> to talk to mysql. >>>>> I have installed the jdbc driver, but how do I tell the app where to find >>>>> it? >>>>> >>>>> TIA >>>>> >>>>> JPM >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list ([email protected]) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> https://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: >>> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >>> >>> 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: > https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.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: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
