18 September 2007 at 7:58pm
Core Development Team,
Ah, are you using Windows?
There's a problem with MySQL on Windows - by default it doesn't care about the case-sensitivity of table names, but Linux does. This is because Windows itself is a case-insensitive file system, whereas Linux isn't.
If you want to fix that, there's an option you can add to your my.ini file for MySQL, take a look at [url=http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html]the MySQL docs here[/url] which explain it in more depth. If I ever build a Windows server, I use lower_case_table_names = 2, which preserves the original case - e.g. it will create the table 'Tip' instead of 'tip'. This means your code will port fine to Linux later, and you can just copy the database over without issues.