I’m trying to migrate my HelpSpot installation from a Windows server to a Linux server. What I did was:
- setup Helpspot on Linux
- tested Helpspot install, everything looked good
- full backup of windows server database using MySQL admin to get a big SQL script
- imported new database to Linux MySQL instance
- restart server and test on Linux
What I found is that my real data wasn’t showing up on the Linux server…just the same old test data. After a bit of poking around I found that the db backup I made from Windows has all the table names in lower case. The table names setup in Linux use mixed case. Since the table names didn’t match up, the import just created new tables and left the old data alone.
Does anyone know an easier way to migrate this data to Linux than manually tweaking all the database table names in the backup file?
As a follow up, anyone know if this is a side effect of some MySQL setting that turns off case sensitivity? Or does the Linux and Windows install script actually do something different?