3237 Posts in 943 Topics by 684 members
|Go to End|
6 October 2010 at 4:56am
I've seen a few posts in the archive detailing various fixes to the migrating from a Windows to a Linux server. A lot of these posts are quite old, and a lot of the time the code snippets posted are already in the MySQLDatabase.php file, suggesting they'd have run already. But my database does still have only lowercase tables and it doesn't seem to work on the Linux box. So I'm a bit confused.
How do I fix this? I've naturally run dev/build plenty of times on the Windows box and I can't run dev/build on the linux box.
Is this even still an issue? Is it likely to be something else entirely?
6 October 2010 at 6:41am
Did you switch:
lower_case_table_names = 2
in your mysql.ini?
You can refer to for more infO:
6 October 2010 at 7:23am
You need to run dev/build on the Linux box. There should be no reason why you can't.
6 October 2010 at 9:37am Last edited: 6 October 2010 9:41am
Thank you for your replies!
I did switch
lower_case_table_names = 2 (on the windows box, then tried a dev/build) and it gave the same 'cannot respond' error - (I had assumed because it wasn't finding the tables it wanted).
But of course if the vanilla dev/build should work on the linux box without any problems, and rename the tables ... then I guess the server can't be configured correctly... at least I know where to look. Just needed confirmation that it wasn't the issue. Thank you.
edit: What would be the harm in setting lower_case_table_names = 1 on the linux box?... just wondering... haven't tried it yet.
|Go to Top|