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;
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;RENAME TABLE atselectoptionsselected TO atSelectOptionsSelected;RENAME TABLE atselectsettings TO atSelectSettings;RENAME TABLE attextareasettings TO atTextareaSettings;RENAME TABLE attributekeycategories TO AttributeKeyCategories;RENAME TABLE attributekeys TO AttributeKeys;RENAME TABLE attributesetkeys TO AttributeSetKeys;RENAME TABLE attributesets TO AttributeSets;RENAME TABLE attributetypecategories TO AttributeTypeCategories;RENAME TABLE attributetypes TO AttributeTypes;RENAME TABLE attributevalues TO AttributeValues;RENAME TABLE basicworkflowpermissionassignments TO BasicWorkflowPermissionAssignments;RENAME TABLE basicworkflowprogressdata TO BasicWorkflowProgressData;RENAME TABLE blockpermissionassignments TO BlockPermissionAssignments;RENAME TABLE blockrelations TO BlockRelations;RENAME TABLE blocks TO Blocks;RENAME TABLE blocktypepermissionblocktypeaccesslist TO BlockTypePermissionBlockTypeAccessList;RENAME TABLE blocktypepermissionblocktypeaccesslistcustom TO BlockTypePermissionBlockTypeAccessListCustom;RENAME TABLE blocktypes TO BlockTypes;RENAME TABLE btasmillergallery TO btAsmillerGallery;RENAME TABLE btasmillergalleryimg TO btAsmillerGalleryImg;RENAME TABLE btclevyrplayer TO btClevyrPlayer;RENAME TABLE btcontentfile TO btContentFile;RENAME TABLE btcontentimage TO btContentImage;RENAME TABLE btcontentlocal TO btContentLocal;RENAME TABLE btcorescrapbookdisplay TO btCoreScrapbookDisplay;RENAME TABLE btcorestackdisplay TO btCoreStackDisplay;RENAME TABLE btdashboardnewsflowlatest TO btDashboardNewsflowLatest;RENAME TABLE btdatearchive TO btDateArchive;RENAME TABLE btdatenav TO btDateNav;RENAME TABLE bteventcalendar TO btEventCalendar;RENAME TABLE btexternalform TO btExternalForm;RENAME TABLE btflashcontent TO btFlashContent;RENAME TABLE btform TO btForm;RENAME TABLE btformanswers TO btFormAnswers;RENAME TABLE btformanswerset TO btFormAnswerSet;RENAME TABLE btformquestions TO btFormQuestions;RENAME TABLE btgooglemap TO btGoogleMap;RENAME TABLE btguestbook TO btGuestBook;RENAME TABLE btguestbookentries TO btGuestBookEntries;RENAME TABLE bthtml5audioplayerbasic TO btHtml5AudioPlayerBasic;RENAME TABLE btlistfilesfromset TO btListFilesFromSet;RENAME TABLE btnavigation TO btNavigation;RENAME TABLE btnextprevious TO btNextPrevious;RENAME TABLE btpagelist TO btPageList;RENAME TABLE btrssdisplay TO btRssDisplay;RENAME TABLE btsearch TO btSearch;RENAME TABLE btsimpleimagegallery TO btSimpleImageGallery;RENAME TABLE btslideshow TO btSlideshow;RENAME TABLE btslideshowimg TO btSlideshowImg;RENAME TABLE btsurvey TO btSurvey;RENAME TABLE btsurveyoptions TO btSurveyOptions;RENAME TABLE btsurveyresults TO btSurveyResults;RENAME TABLE btswpbreadcrumbs TO btSwpBreadcrumbs
RENAME TABLE bttags TO btTags;RENAME TABLE btvideo TO btVideo;RENAME TABLE btyoutube TO btYouTube;RENAME TABLE collectionattributevalues TO CollectionAttributeValues;RENAME TABLE collections TO Collections;RENAME TABLE collectionsearchindexattributes TO CollectionSearchIndexAttributes;RENAME TABLE collectionversionarealayouts TO CollectionVersionAreaLayouts;RENAME TABLE collectionversionareastyles TO CollectionVersionAreaStyles;RENAME TABLE collectionversionblocks TO CollectionVersionBlocks;RENAME TABLE collectionversionblocksoutputcache TO CollectionVersionBlocksOutputCache;RENAME TABLE collectionversionblockstyles TO CollectionVersionBlockStyles;RENAME TABLE collectionversionrelatededits TO CollectionVersionRelatedEdits;RENAME TABLE collectionversions TO CollectionVersions;RENAME TABLE composercontentlayout TO ComposerContentLayout;RENAME TABLE composerdrafts TO ComposerDrafts;RENAME TABLE composertypes TO ComposerTypes;RENAME TABLE config TO Config;RENAME TABLE customstylepresets TO CustomStylePresets;RENAME TABLE customstylerules TO CustomStyleRules;RENAME TABLE dashboardhomepage TO DashboardHomepage;RENAME TABLE downloadstatistics TO DownloadStatistics;RENAME TABLE dseventcalendar TO dsEventCalendar;RENAME TABLE dseventcalendarevents TO dsEventCalendarEvents;RENAME TABLE fileattributevalues TO FileAttributeValues;RENAME TABLE filepermissionassignments TO FilePermissionAssignments;RENAME TABLE filepermissionfiletypes TO FilePermissionFileTypes;RENAME TABLE filepermissions TO FilePermissions;RENAME TABLE files TO Files;RENAME TABLE filesearchindexattributes TO FileSearchIndexAttributes;RENAME TABLE filesetfiles TO FileSetFiles;RENAME TABLE filesetpermissionassignments TO FileSetPermissionAssignments;RENAME TABLE filesetpermissionfiletypeaccesslist TO FileSetPermissionFileTypeAccessList;RENAME TABLE filesetpermissionfiletypeaccesslistcustom TO FileSetPermissionFileTypeAccessListCustom;RENAME TABLE filesets TO FileSets;RENAME TABLE filesetsavedsearches TO FileSetSavedSearches;RENAME TABLE filestoragelocations TO FileStorageLocations;RENAME TABLE fileversionlog TO FileVersionLog;RENAME TABLE fileversions TO FileVersions;RENAME TABLE groups TO Groups;RENAME TABLE groupsetgroups TO GroupSetGroups;RENAME TABLE groupsets TO GroupSets;RENAME TABLE jobs TO Jobs;RENAME TABLE jobsetjobs To jobsetjobs;RENAME TABLE jobset TO jobset;RENAME TABLE jobslog TO JobsLog;RENAME TABLE layoutpresets TO LayoutPresets;RENAME TABLE layouts TO Layouts;RENAME TABLE logs TO Logs;RENAME TABLE mailimporters TO MailImporters;RENAME TABLE mailvalidationhashes TO MailValidationHashes;RENAME TABLE packages TO Packages;RENAME TABLE pagepaths TO PagePaths;RENAME TABLE pagepermissionassignments TO PagePermissionAssignments;RENAME TABLE pagepermissionpagetypeaccesslist TO PagePermissionPageTypeAccessList;RENAME TABLE pagepermissionpagetypeaccesslistcustom TO PagePermissionPageTypeAccessListCustom;RENAME TABLE pagepermissionpropertyaccesslist TO PagePermissionPropertyAccessList;RENAME TABLE pagepermissionpropertyattributeaccesslistcustom TO PagePermissionPropertyAttributeAccessListCustom;RENAME TABLE pagepermissionthemeaccesslist TO PagePermissionThemeAccessList;RENAME TABLE pagepermissionthemeaccesslistcustom TO PagePermissionThemeAccessListCustom;RENAME TABLE pages TO Pages;RENAME TABLE pagesearchindex TO PageSearchIndex;RENAME TABLE pagestatistics TO PageStatistics;RENAME TABLE pagethemes TO PageThemes;RENAME TABLE pagethemestyles TO PageThemeStyles;RENAME TABLE pagetypeattributes TO PageTypeAttributes;RENAME TABLE pagetypes TO PageTypes;RENAME TABLE pageworkflowprogress TO PageWorkflowProgress;RENAME TABLE permissionaccess TO PermissionAccess;RENAME TABLE permissionaccessentities TO PermissionAccessEntities;RENAME TABLE permissionaccessentitygroups TO PermissionAccessEntityGroups;RENAME TABLE permissionaccessentitygroupsets TO PermissionAccessEntityGroupSets;RENAME TABLE permissionaccessentitytypecategories TO PermissionAccessEntityTypeCategories;RENAME TABLE permissionaccessentitytypes TO PermissionAccessEntityTypes;RENAME TABLE permissionaccessentityusers TO PermissionAccessEntityUsers;RENAME TABLE permissionaccesslist TO PermissionAccessList;RENAME TABLE permissionaccessworkflows TO PermissionAccessWorkflows;RENAME TABLE permissionassignments TO PermissionAssignments;RENAME TABLE permissiondurationobjects TO PermissionDurationObjects;RENAME TABLE permissionkeycategories TO PermissionKeyCategories;RENAME TABLE permissionkeys TO PermissionKeys;RENAME TABLE pilecontents TO PileContents;RENAME TABLE piles TO Piles;RENAME TABLE portfoliooptions TO PortfolioOptions;RENAME TABLE queuemessages To QueueMessages;RENAME TABLE queuepageduplicationrelations TO QueuePageDuplicationRelations;RENAME TABLE queues TO Queues;RENAME TABLE signuprequests TO SignupRequests;RENAME TABLE stacks TO Stacks;RENAME TABLE systemantispamlibraries TO SystemAntispamLibraries;RENAME TABLE systemcaptchalibraries TO SystemCaptchaLibraries;RENAME TABLE systemnotifications TO SystemNotifications;RENAME TABLE userattributekeys TO UserAttributeKeys;RENAME TABLE userattributevalues TO UserAttributeValues;RENAME TABLE userbannedips TO UserBannedIPs;RENAME TABLE usergroups TO UserGroups;RENAME TABLE useropenids TO UserOpenIDs;RENAME TABLE userpermissionassigngroupaccesslist TO UserPermissionAssignGroupAccessList;RENAME TABLE userpermissionassigngroupaccesslistcustom TO UserPermissionAssignGroupAccessListCustom;RENAME TABLE userpermissioneditpropertyaccesslist TO UserPermissionEditPropertyAccessList;RENAME TABLE userpermissioneditpropertyattributeaccesslistcustom TO UserPermissionEditPropertyAttributeAccessListCustom;RENAME TABLE userpermissionusersearchaccesslist TO UserPermissionUserSearchAccessList;RENAME TABLE userpermissionusersearchaccesslistcustom TO UserPermissionUserSearchAccessListCustom;RENAME TABLE userpermissionviewattributeaccesslist TO UserPermissionViewAttributeAccessList;RENAME TABLE userpermissionviewattributeaccesslistcustom TO UserPermissionViewAttributeAccessListCustom;RENAME TABLE userpointhistory TO UserPointHistory;RENAME TABLE userprivatemessages TO UserPrivateMessages;RENAME TABLE userprivatemessagesto TO UserPrivateMessagesTo;RENAME TABLE users TO Users;RENAME TABLE usersearchindexattributes TO UserSearchIndexAttributes;RENAME TABLE usersfriends TO UsersFriends;RENAME TABLE uservalidationhashes TO UserValidationHashes;RENAME TABLE workflowprogress TO WorkflowProgress;RENAME TABLE workflowprogresscategories TO WorkflowProgressCategories;RENAME TABLE workflowprogresshistory TO WorkflowProgressHistory;RENAME TABLE workflowrequestobjects TO WorkflowRequestObjects;RENAME TABLE workflows TO Workflows;RENAME TABLE workflowtypes TO WorkflowTypes;
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...
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.