[thelist] [mySQL] - lower_case_table_names=0 causes crash?

[Mark M]

I was looking on the web last night, and it seems that there is a bug in 4.0.17 and 4.0.18 that 
causes the system to crash on Windows if you set lower_case_table_name=0

So it's back to 3.23 :o)

Mark
------------------------------------------------------------------
mark at safefrombees.com
ICQ: 3094740
Safe From Bees
[ www.safefrombees.com ]


Quoting Mark Groen <mark at markgroen.com>:

> ----- Original Message ----- 
> From: "Mark M" <mark at safefrombees.com>
> To: <thelist at lists.evolt.org>
> Sent: March 22, 2004 4:44 PM
> Subject: [thelist] [mySQL] - lower_case_table_names=0 causes crash?
> 
> 
> > Trying to turn off the lower case table names for mySQL so I can
> ensure portability to a Unix
> > box.
> > Running mySQL 4.0.17 (on Windows)
> > Within the my.ini I added the line:
> > set-variable=lower_case_table_names=0
> > and now the db server crashes on startup :oP
> > (tried using the word 'OFF' instead of '0', same deal)
> 
> This is correct: set-variable=lower_case_table_names=0
> However, if you put  lower_case_table_names=OFF it fails in prior
> versions to 4.0.6 Of course you could just use a consistent naming
> convention for your tables. Sounds like you probably want to upgrade
> though:
> http://www.mysql.com/downloads/mysql-4.1.html
> 
> cheers,
> 
>                Mark
> 
> MG Web Services
> Web Site Hosting and Development
> www.markgroen.com
> 604-780-6917
> Bowen Island, B.C., Canada
> 
> -- 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 
> 
>