Hi all,

I just transferred my local BitNami Concrete5 install onto my windows hosting with cPanel/phpMyAdmin but I had the problem with the table names being lowercase.

The easiest fix without paying for an addon is by doing a bulk rename within phpMyAdmin.

Within phpMyAdmin, click on your concrete5 database on the left hand column Navigate to the SQL tab Copy and paste the following: (If you're having troubles copying the below text, here's a spreadsheet {you want to copy column D}: https://docs.google.com/spreadsheet/ccc?key=0AlJCVtzg02judFZsRnpfNHNucHdOSFVPdzNHb0xHZ3c)

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 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 btdatenav TO btDateNav; 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 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 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 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 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 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 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 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 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;

Hopefully this saves someone a headache and a fair bit of time.