Quick help appreciated: Renaming the SQL TABLE names (CaseSensitivity)

Permalink
Hi,

I have driven myself mad reading about SQL NameSensitivity when moving a site from a Windows based setup to a Linux Server.

I have tried and failed to do this and come to a point where I really want to walk away but know I can't as my client requires the site up and running ASAP.

I have written the RENAME TABLE Query but when I try and run it in phpMyAdmin I get a RENAME TABLE ERROR on the very first line saying that the Table already exists - which I know as I am trying to rename it not create it.

I will copy the code below - I have checked every line but simply do not know what to do next. All the files are copied to the new LIVE server and I just need this sorted.

Please any help and advice is appreciated however I need this done ASAP UK time.

Fanflame

RENAME TABLE areapermissionassignments TO AreaPermissionAssignments; 
RENAME TABLE areapermissionblocktypeaccesslist TO AreaPermissionBlockTypeAccessList;
RENAME TABLE areapermissionblocktypeaccesslistcustom TO AreaPermissionBlockTypeAccessListCustom; 
RENAME TABLE areas TO Areas;
RENAME TABLE ataddress TO atAddress;
RENAME TABLE ataddresscustomcountries TO atAddressCustomCountries; 
RENAME TABLE ataddresssettings TO atAddressSettings;
RENAME TABLE atboolean TO atBoolean; 
RENAME TABLE atbooleansettings TO atBooleanSettings; 
RENAME TABLE atdatetime TO atDateTime;
RENAME TABLE atdatetimesettings TO atDateTimeSettings; 
RENAME TABLE atdefault TO atDefault; 
RENAME TABLE atfile TO atFile; 
RENAME TABLE atnumber TO atNumber; 
RENAME TABLE atselectoptions TO atSelectOptions;

Fanflame
 
Mainio replied on at Permalink Reply
Mainio
Try this:
http://www.concrete5.org/marketplace/addons/database-case-sensitivi...

It will rename the old tables to a different name before renaming them back to the CameCase format so that your problem would not occur.
JohntheFish replied on at Permalink Best Answer Reply
JohntheFish
If you use Backup Voodoo to copy the database and files, it will integrate with @mainio's addon to case correct the database as it makes the backup.
Jupiter replied on at Permalink Reply
Jupiter
plz download this(db_case_sensitivity) addon from concrete5 addon section and install it
then you will get a script by which you will be able to rename the table as you want...
But do not run the same script twice...
please see the url

http://www.concrete5.org/marketplace/addons/database-case-sensitivi...