Wednesday, 18 May 2011

moving MySQL db from windows to linux

The problem: All my tables have names in capital...MySQL in windows ignores capital Linux this is not the case!!

Therefore all my queries in linux throw:

org.hibernate.exception.SQLGrammarException: could not execute query
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'mydb.MY_TABLE' doesn't exist

Solution: edit /etc/mysql/my.cnf and set

restart mysql:
$ sudo service mysql restart


No comments:

Post a Comment