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]
