Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278 M: (713) 252-4688
-----Original Message----- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Sunday, November 14, 2004 11:32 AM To: Boyd E. Hemphill Cc: [EMAIL PROTECTED] Subject: Re: Moving innodb from Linux to Windows Boyd, please send this correspondence to [EMAIL PROTECTED] Right, lower_case_table_names=2 does not work with InnoDB. I guess the way for you is then to use lower_case_table_names=1 on both Unix and Windows. The drawback is that table dumps will have the name in lower case. Note that, according to SQL standards, a database server should convert all table names to UPPER CASE by default. My RENAME TABLE advice was for the case where you already have some tables, and want to make them to conform to lower_case_table_names=1. Regards, Heikki ----- Alkuperäinen viesti ----- Lähettäjä: "Boyd E. Hemphill" <[EMAIL PROTECTED]> Vastaanottaja: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Friday, November 12, 2004 3:51 PM Aihe: RE: Moving innodb from Linux to Windows Heikki & Gleb: Thank you for the quick responses. I had read the documentation that Dr. Tuuri quotes and took it to mean that I had to account for this with parameter settings, etc. The DB I am working with is a 40G production tablespace. It has over 100k lines of Java code against it. We capitalize the first letter in each word of table and column names. Changing this would require a very serious undertaking. I understood this document http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html to mean that this problem could be dealt with by setting lower_case_table_names=2 I think the issue is that the doc was written for the MyISAM engine and not the InnoDB engine. Could one of you clarify? I appreciate your time in the matter. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2278 M: (713) 252-4688 -----Original Message----- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Friday, November 12, 2004 3:08 AM To: [EMAIL PROTECTED] Subject: Re: Moving innodb from Linux to Windows Boyd, > ------=_NextPart_000_0038_01C4C7F5.22045240 > Content-Type: text/plain; > charset="us-ascii" > Content-Transfer-Encoding: 7bit > > All: > > > > I am attempting to move a set of db's from Linux (Mysql 4.0.20) to Windows > (4.1.6). I have everything running, and I can query tables that are all > lower case. > > > > However I cannot issue a query on a table that contains uppercase letters. > This is the my.ini file: on Windows, InnoDB puts all database names and table names to lower case, because on Windows MySQL is case-insensitive. You should use, e.g., RENAME TABLE UppercaseDBName.UpperCaseTable TO uppercasedbname.uppercasetable; in your Unix database to make it suitable for porting to Windows. And set lowercase_table_names=1 in the my.cnf of your Unix database, so that your applications can find the tables after renaming them. http://dev.mysql.com/doc/mysql/en/Moving.html " On Windows, InnoDB internally always stores database and table names in lowercase. To move databases in a binary format from Unix to Windows or from Windows to Unix, you should have all table and database names in lowercase. A convenient way to accomplish this on Unix is to add the following line to the [mysqld] section of your `my.cnf' before you start creating your databases and tables: [mysqld] set-variable = lower_case_table_names=1 On Windows, lower_case_table_names is set to 1 by default. " We may fix this in the future, so that on Windows InnoDB will also find tables with uppercase letters in their name. For that, we need a MySQL function that looks from the .frm file name and directory what is the 'canonical' case of the letters in the database name and the table name. > Best Regards, > > Boyd E. Hemphill Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]