List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:December 17 2003 10:33pm
Subject:Re: MySQL 4.0.17 has been released
View as plain text  
Hi!

I would like to remind people that if you want to move an InnoDB database
between Unix and Windows, you have to consider the following:

http://www.innodb.com/ibman.php#Moving

"
On Windows InnoDB stores the database names and table names internally
always in lower case. 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 lower case. A convenient way to accomplish this is to add on Unix the
line

set-variable=lower_case_table_names=1

to the [mysqld] section of your my.cnf before you start creating your
tables. On Windows the setting 1 is the default.
"

That is, the best solution for portability is to have the database and table
names always in lower case. Setting globally
set-variable=lower_case_table_names=1 is a convenient way to accomplish
this.

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM
tables


Order MySQL technical support from https://order.mysql.com/


----- Original Message ----- 
From: ""Reverend Deuce"" <mysqlml@stripped>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 17, 2003 11:42 PM
Subject: Re: MySQL 4.0.17 has been released


> I agree, 100%. We live in a mixed environment of UNIX and Windows and as
> such, we've assumed case insensitivity in our apps. I know that this is
bad
> practice, but forcing this flag on us is and even worse practice. This
> should always, always be an option.
>
> I wont be able to upgrade until this is fixed. :(
>
> -- R
>
> ----- Original Message ----- 
> From: "Yves Goergen" <nospam.list@stripped>
> To: "Lenz Grimmer" <lenz@stripped>; <mysql@stripped>
> Sent: Wednesday, December 17, 2003 1:12 PM
> Subject: Re: MySQL 4.0.17 has been released
>
>
> > On Wednesday, December 17, 2003 1:58 PM CET, Lenz Grimmer wrote:
> > > Functionality added or changed:
> > >
> > >    * `lower_case_table_names' is now forced to 1 if the database
> > >      directory is located on a case-insensitive file system. (Bug
> > > #1812)
> >
> > Uh, _very_ bad. I know that my Windows filesystem is case-insensitive
and
> > that I cannot create tables only differing by case of the name, but I
need
> > to have this setting off to be able to dump my tables on Windows with
the
> > correct (and not lower-cased!!) table names to import them on my
> webhoster's
> > Linux server. If the setting was enabled, I'd get all wrong table names
> and
> > my application couldn't find its tables anymore (as 'bb1_GroupMembers'
> gets
> > to 'bb1_groupmembers' and that's something else!).
> >
> > So please change this back again, I believe it's up to the server
> > administrator to set this in a correct and reasonable way, don't you?
> >
> > -- 
> > Yves Goergen
> > nospam.list@stripped
> > Please don't CC me (causes double mails)
> >
> >
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >
> >
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>

Thread
mysqltopThomas Wana13 Mar
  • Re: mysqltopJim Faucette13 Mar
  • Re: MySQL 4.0.17 has been releasedYves Goergen17 Dec
  • Re: MySQL 4.0.17 has been releasedReverend Deuce17 Dec
    • Re: MySQL 4.0.17 has been releasedSergei Golubchik18 Dec
  • Re: MySQL 4.0.17 has been releasedMatt W17 Dec
  • Re: MySQL 4.0.17 has been releasedYves Goergen18 Dec
Re: MySQL 4.0.17 has been releasedHeikki Tuuri17 Dec