Errors in CreateMySQLDB.sql on Linux

Topics: 4. Bugs
Sep 1, 2014 at 10:48 PM
Edited Sep 1, 2014 at 10: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 (
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,
    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
        FROM vwSpotData
Sep 2, 2014 at 7:19 AM
Edited Sep 2, 2014 at 8:12 PM
Thanks, that's a scenario I didn't test....
Files are updated
Sep 2, 2014 at 8: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:
Restart mysql
sudo /etc/init.d/mysql restart
Then check it here:
mysqladmin -u root -p variables
Marked as answer by SBF on 9/2/2014 at 1:17 PM