Errors in CreateMySQLDB.sql on Linux

Topics: 4. Bugs
Sep 1, 2014 at 11:48 PM
Edited Sep 1, 2014 at 11:50 PM
MySQL on Linux seems to be case sensitive, so the CreateMySQLDB.sql scripts has a number of errors. I have shown the errors shown on the command line when running the script and the changes that need to be made.

ERROR 1146 (42S02) at line 63: Table 'SBFspot.SpotData' doesn't exist
Line 43 change from:
CREATE Table Spotdata (
to:
CREATE Table SpotData (


ERROR 1054 (42S22) at line 120: Unknown column 'dat.TimeStamp' in 'field list'
Line 121, change from:
    select cast(from_unixtime(dat.TimeStamp) as date) AS TimeStamp,
to:
    select cast(from_unixtime(Dat.TimeStamp) as date) AS TimeStamp,
ERROR 1146 (42S02) at line 179: Table 'SBFspot.vwspotdata' doesn't exist
Line 198, change from:
        FROM vwspotdata
to:
        FROM vwSpotData
Coordinator
Sep 2, 2014 at 8:19 AM
Edited Sep 2, 2014 at 9:12 PM
Thanks, that's a scenario I didn't test....
Files are updated
Coordinator
Sep 2, 2014 at 9:16 PM
Only table names are case sensitive; to make case insensitive:
Open terminal and edit /etc/mysql/my.cnf
sudo nano /etc/mysql/my.cnf
Underneath the [mysqld] section.add:
lower_case_table_names=1
Restart mysql
sudo /etc/init.d/mysql restart
Then check it here:
mysqladmin -u root -p variables
Source: http://dba.stackexchange.com/questions/59407/how-make-mysql-table-name-case-insensitive-in-ubuntu
Marked as answer by SBF on 9/2/2014 at 1:17 PM