When I restored from a backup, all the databases and table names are lower case. How do I maintain the casing on those names?
This is on a Windows system, so I realize things will still work, but if I move it to Linux it won’t. But I want to preserve the case no matter what system I run it on.
Hi Jeff,
Thanks for your question.
SQLBackupAndFTP is a Windows-only application and does not have a Linux version.
If you are planning to run backups or restores on Linux systems, we recommend using our other product, SqlBak, which has versions for both Windows and Linux and is designed for cross-platform environments.
I looked at the sql code inside the zip file SQLBackupAndFTP created and the case on everything is correct. I think my settings on mysql server aren’t correct. I have to turn on case sensitivity. Sorry to bother you!
Hi Jeff,
No bother at all — glad you tracked it down!
Just for clarity, SQLBackupAndFTP creates MySQL backups using the native mysqldump utility. We do not modify or alter the contents of the dump file in any way. The restore process simply executes the generated SQL script.
You can see more details and an example command here:
Because we rely on mysqldump, we cannot directly influence object name casing — except through MySQL configuration or specific mysqldump parameters (which can be adjusted in Advanced Options).