Home → Admin Manual → Troubleshooting Guides → MySQL - Convert Lowercase Windows Table Names to Mixed Case for Linux/Unix

12.7. MySQL - Convert Lowercase Windows Table Names to Mixed Case for Linux/Unix

When converting a MySQL database from Windows to Linux/Unix the Windows server will often export the database table names in all lowercase. HelpSpot on Linux/Unix requires mixed case table names.

This script will convert the lowercase names into proper mixed case names.

There are separate scripts for V2 and V3

Usage:

 

1. Place this file in the same directory as config.php
2. Visit the script in your browser
3. Delete the script

Knowledge Tags

MySQL  /  Troubleshooting  / 

Downloads

• php
  table_name_convert_v3.php
• php
  table_name_convert_v4.php
• php
  table_name_convert.php