Installation Help

Exporting from localhost to LIVE site

Permalink 2 users found helpful May 23, 2011 at 7:40 AM

Hi everyone,

I attempted to move my site from development (localhost) to LIVE site at my domain.
However this turned out to be more troublesome than I expected.
After some searches on the web, I learned that my problem came from exporting my SQL file from Windows (localhost) to my LIVE site, which runs at a Linux server.
So the issue had to do with the fact that all table names from Windows are written in lowercase, but at a Linux server it requires a mixed table name consisting of both lowercase and uppercase letters.

So I spent the most of my morning rewriting all the table names to be a mix of Lower- and uppercase letters in consistence with the table names.

So I thought to my self, why publish all these table rewrites here so you could benefit from it as well.

Simply, use the posted mySql commandos and go to the PhpMyAdmin at your LIVE site, and in the SQL window simply post these "alter tables"

Please note, perform this at your own risk.
The "alter statements" below is for Concrete5 version 5.4.1.1

ALTER TABLE `areagroupblocktypes` RENAME TO `AreaGroupBlockTypes`;
ALTER TABLE `areagroups` RENAME TO `AreaGroups`;
ALTER TABLE `areas` RENAME TO `Areas`;
ALTER TABLE `ataddress` RENAME TO `atAddress`;
ALTER TABLE `ataddresscustomcountries` RENAME TO `atAddressCustomCountries`;
ALTER TABLE `ataddresssettings` RENAME TO `atAddressSettings`;
ALTER TABLE `atboolean` RENAME TO `atBoolean`;
ALTER TABLE `atbooleansettings` RENAME TO `atBooleanSettings`;
ALTER TABLE `atdatetime` RENAME TO `atDateTime`;
ALTER TABLE `atdatetimesettings` RENAME TO `atDateTimeSettings`;
ALTER TABLE `atdefault` RENAME TO `atDefault`;
ALTER TABLE `atfile` RENAME TO `atFile`;
ALTER TABLE `atnumber` RENAME TO `atNumber`;
ALTER TABLE `atselectoptions` RENAME TO `atSelectOptions`;
ALTER TABLE `atselectoptionsselected` RENAME TO `atSelectOptionsSelected`;

Viewing 15 lines of 118 lines. View entire code block.

 
 
ALTER TABLE `areagroupblocktypes` RENAME TO `AreaGroupBlockTypes`;
ALTER TABLE `areagroups` RENAME TO `AreaGroups`;
ALTER TABLE `areas` RENAME TO `Areas`;
ALTER TABLE `ataddress` RENAME TO `atAddress`;
ALTER TABLE `ataddresscustomcountries` RENAME TO `atAddressCustomCountries`;
ALTER TABLE `ataddresssettings` RENAME TO `atAddressSettings`;
ALTER TABLE `atboolean` RENAME TO `atBoolean`;
ALTER TABLE `atbooleansettings` RENAME TO `atBooleanSettings`;
ALTER TABLE `atdatetime` RENAME TO `atDateTime`;
ALTER TABLE `atdatetimesettings` RENAME TO `atDateTimeSettings`;
ALTER TABLE `atdefault` RENAME TO `atDefault`;
ALTER TABLE `atfile` RENAME TO `atFile`;
ALTER TABLE `atnumber` RENAME TO `atNumber`;
ALTER TABLE `atselectoptions` RENAME TO `atSelectOptions`;
ALTER TABLE `atselectoptionsselected` RENAME TO `atSelectOptionsSelected`;
ALTER TABLE `atselectsettings` RENAME TO `atSelectSettings`;
ALTER TABLE `attextareasettings` RENAME TO `atTextareaSettings`;
ALTER TABLE `attributekeycategories` RENAME TO `AttributeKeyCategories`;
ALTER TABLE `attributekeys` RENAME TO `AttributeKeys`;
ALTER TABLE `attributesetkeys` RENAME TO `AttributeSetKeys`;
ALTER TABLE `attributesets` RENAME TO `AttributeSets`;
ALTER TABLE `attributetypecategories` RENAME TO `AttributeTypeCategories`;
ALTER TABLE `attributetypes` RENAME TO `AttributeTypes`;
ALTER TABLE `attributevalues` RENAME TO `AttributeValues`;
ALTER TABLE `blockrelations` RENAME TO `BlockRelations`;
ALTER TABLE `blocks` RENAME TO `Blocks`;
ALTER TABLE `blocktypes` RENAME TO `BlockTypes`;
ALTER TABLE `btcontentfile` RENAME TO `btContentFile`;
ALTER TABLE `btcontentimage` RENAME TO `btContentImage`;
ALTER TABLE `btcontentlocal` RENAME TO `btContentLocal`;
ALTER TABLE `btdatenav` RENAME TO `btDateNav`;
ALTER TABLE `bteasynewslist` RENAME TO `btEasyNewsList`;
ALTER TABLE `btexternalform` RENAME TO `btExternalForm`;
ALTER TABLE `btfile` RENAME TO `btFile`;
ALTER TABLE `btflashcontent` RENAME TO `btFlashContent`;
ALTER TABLE `btform` RENAME TO `btForm`;
ALTER TABLE `btformanswers` RENAME TO `btFormAnswers`;
ALTER TABLE `btformanswerset` RENAME TO `btFormAnswerSet`;
ALTER TABLE `btformquestions` RENAME TO `btFormQuestions`;
ALTER TABLE `btgooglemap` RENAME TO `btGoogleMap`;
ALTER TABLE `btguestbook` RENAME TO `btGuestBook`;
ALTER TABLE `btguestbookentries` RENAME TO `btGuestBookEntries`;
ALTER TABLE `btnavigation` RENAME TO `btNavigation`;
ALTER TABLE `btnextprevious` RENAME TO `btNextPrevious`;
ALTER TABLE `btremoexpand` RENAME TO `btRemoExpand`;
ALTER TABLE `btpagelist` RENAME TO `btPageList`;
ALTER TABLE `btrssdisplay` RENAME TO `btRssDisplay`;
ALTER TABLE `btsearch` RENAME TO `btSearch`;
ALTER TABLE `btslideshow` RENAME TO `btSlideshow`;
ALTER TABLE `btslideshowimg` RENAME TO `btSlideshowImg`;
ALTER TABLE `btsurvey` RENAME TO `btSurvey`;
ALTER TABLE `btsurveyoptions` RENAME TO `btSurveyOptions`;
ALTER TABLE `btsurveyresults` RENAME TO `btSurveyResults`;
ALTER TABLE `bttags` RENAME TO `btTags`;
ALTER TABLE `btvideo` RENAME TO `btVideo`;
ALTER TABLE `btyoutube` RENAME TO `btYouTube`;
ALTER TABLE `collectionattributevalues` RENAME TO `CollectionAttributeValues`;
ALTER TABLE `collections` RENAME TO `Collections`;
ALTER TABLE `collectionsearchindexattributes` RENAME TO `CollectionSearchIndexAttributes`;
ALTER TABLE `collectionversionarealayouts` RENAME TO `CollectionVersionAreaLayouts`;
ALTER TABLE `collectionversionareastyles` RENAME TO `CollectionVersionAreaStyles`;
ALTER TABLE `collectionversionblockpermissions` RENAME TO `CollectionVersionBlockPermissions`;
ALTER TABLE `collectionversionblocks` RENAME TO `CollectionVersionBlocks`;
ALTER TABLE `collectionversionblockstyles` RENAME TO `CollectionVersionBlockStyles`;
ALTER TABLE `collectionversions` RENAME TO `CollectionVersions`;
ALTER TABLE `config` RENAME TO `Config`;
ALTER TABLE `customstylepresets` RENAME TO `CustomStylePresets`;
ALTER TABLE `customstylerules` RENAME TO `CustomStyleRules`;
ALTER TABLE `dashboardhomepage` RENAME TO `DashboardHomepage`;
ALTER TABLE `downloadstatistics` RENAME TO `DownloadStatistics`;
ALTER TABLE `fileattributevalues` RENAME TO `FileAttributeValues`;
ALTER TABLE `filepermissionfiletypes` RENAME TO `FilePermissionFileTypes`;
ALTER TABLE `filepermissions` RENAME TO `FilePermissions`;
ALTER TABLE `files` RENAME TO `Files`;
ALTER TABLE `filesearchindexattributes` RENAME TO `FileSearchIndexAttributes`;
ALTER TABLE `filesetfiles` RENAME TO `FileSetFiles`;
ALTER TABLE `filesetpermissions` RENAME TO `FileSetPermissions`;
ALTER TABLE `filesets` RENAME TO `FileSets`;
ALTER TABLE `filesetsavedsearches` RENAME TO `FileSetSavedSearches`;
ALTER TABLE `filestoragelocations` RENAME TO `FileStorageLocations`;
ALTER TABLE `fileversionlog` RENAME TO `FileVersionLog`;
ALTER TABLE `fileversions` RENAME TO `FileVersions`;
ALTER TABLE `groups` RENAME TO `Groups`;
ALTER TABLE `jobs` RENAME TO `Jobs`;
ALTER TABLE `jobslog` RENAME TO `JobsLog`;
ALTER TABLE `layoutpresets` RENAME TO `LayoutPresets`;
ALTER TABLE `layouts` RENAME TO `Layouts`;
ALTER TABLE `logs` RENAME TO `Logs`;
ALTER TABLE `mailimporters` RENAME TO `MailImporters`;
ALTER TABLE `mailvalidationhashes` RENAME TO `MailValidationHashes`;
ALTER TABLE `packages` RENAME TO `Packages`;
ALTER TABLE `pagepaths` RENAME TO `PagePaths`;
ALTER TABLE `pagepermissionpagetypes` RENAME TO `PagePermissionPageTypes`;
ALTER TABLE `pagepermissions` RENAME TO `PagePermissions`;
ALTER TABLE `pages` RENAME TO `Pages`;
ALTER TABLE `pagesearchindex` RENAME TO `PageSearchIndex`;
ALTER TABLE `pagestatistics` RENAME TO `PageStatistics`;
ALTER TABLE `pagethemes` RENAME TO `PageThemes`;
ALTER TABLE `pagethemestyles` RENAME TO `PageThemeStyles`;
ALTER TABLE `pagetypeattributes` RENAME TO `PageTypeAttributes`;
ALTER TABLE `pagetypes` RENAME TO `PageTypes`;
ALTER TABLE `pilecontents` RENAME TO `PileContents`;
ALTER TABLE `piles` RENAME TO `Piles`;
ALTER TABLE `signuprequests` RENAME TO `SignupRequests`;
ALTER TABLE `systemnotifications` RENAME TO `SystemNotifications`;
ALTER TABLE `taskpermissions` RENAME TO `TaskPermissions`;
ALTER TABLE `taskpermissionusergroups` RENAME TO `TaskPermissionUserGroups`;
ALTER TABLE `userattributekeys` RENAME TO `UserAttributeKeys`;
ALTER TABLE `userattributevalues` RENAME TO `UserAttributeValues`;
ALTER TABLE `userbannedips` RENAME TO `UserBannedIPs`;
ALTER TABLE `usergroups` RENAME TO `UserGroups`;
ALTER TABLE `useropenids` RENAME TO `UserOpenIDs`;
ALTER TABLE `userprivatemessages` RENAME TO `UserPrivateMessages`;
ALTER TABLE `userprivatemessagesto` RENAME TO `UserPrivateMessagesTo`;
ALTER TABLE `users` RENAME TO `Users`;
ALTER TABLE `usersearchindexattributes` RENAME TO `UserSearchIndexAttributes`;
ALTER TABLE `usersfriends` RENAME TO `UsersFriends`;
ALTER TABLE `uservalidationhashes` RENAME TO `UserValidationHashes`;

1 Attachment

shadowcomputers replied on May 24, 2011 at 10:10 pm Permalink Reply

Useful instructions to moving a site can be found at:http://www.concrete5.org/documentation/installation/moving_a_site...

One of the links on that page goes to an add-on that should help you move your database from SQL to MySQL.
The link is:http://www.concrete5.org/marketplace/addons/mysql-case-insensitive-...

I hope this helps.

siteadvice replied on Jun 17, 2012 at 1:56 pm Permalink Reply

Add to this list...

ALTER TABLE `composercontentlayout` RENAME TO `ComposerContentLayout`;
ALTER TABLE `composerdrafts` RENAME TO `ComposerDrafts`;
ALTER TABLE `composertypes` RENAME TO `ComposerTypes`;

siteadvice replied on Aug 11, 2014 at 10:06 am Permalink Reply

I just did a clean install of v 5.6.3.1 and there are now 171 tables in the Concrete5 database.

Does anyone have an update of these table rename instructions with the latest set of tables included?

Mainio replied on Aug 11, 2014 at 11:14 am Permalink Reply

http://www.concrete5.org/documentation/how-tos/developers/mysql-database-case-insensitivity/

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

siteadvice replied on Sep 4, 2014 at 11:54 am Permalink Reply

These ones seem to be missing...

ALTER TABLE `areapermissionassignments` RENAME TO `AreaPermissionAssignments`;
ALTER TABLE `areapermissionblocktypeaccesslist` RENAME TO `AreaPermissionBlockTypeAccessList`;
ALTER TABLE `areapermissionblocktypeaccesslistcustom` RENAME TO `AreaPermissionBlockTypeAccessListCustom`;
ALTER TABLE `basicworkflowpermissionassignments` RENAME TO `BasicWorkflowPermissionAssignments`;
ALTER TABLE `basicworkflowprogressdata` RENAME TO `BasicWorkflowProgressData`;
ALTER TABLE `blockpermissionassignments` RENAME TO `BlockPermissionAssignments`;
ALTER TABLE `blocktypepermissionblocktypeaccesslist` RENAME TO `BlockTypePermissionBlockTypeAccessList`;
ALTER TABLE `blocktypepermissionblocktypeaccesslistcustom` RENAME TO `BlockTypePermissionBlockTypeAccessListCustom`;
ALTER TABLE `filepermissionassignments` RENAME TO `FilePermissionAssignments`;
ALTER TABLE `filesetpermissionassignments` RENAME TO `FileSetPermissionAssignments`;
ALTER TABLE `filesetpermissionfiletypeaccesslist` RENAME TO `FileSetPermissionFileTypeAccessList`;
ALTER TABLE `filesetpermissionfiletypeaccesslistcustom` RENAME TO `FileSetPermissionFileTypeAccessListCustom`;
ALTER TABLE `groupsetgroups` RENAME TO `GroupSetGroups`;
ALTER TABLE `groupsets` RENAME TO `GroupSets`;
ALTER TABLE `pagepermissionassignments` RENAME TO `PagePermissionAssignments`;
ALTER TABLE `pagepermissionpagetypeaccesslist` RENAME TO `PagePermissionPageTypeAccessList`;
ALTER TABLE `pagepermissionpagetypeaccesslistcustom` RENAME TO `PagePermissionPageTypeAccessListCustom`;
ALTER TABLE `pagepermissionpropertyaccesslist` RENAME TO `PagePermissionPropertyAccessList`;
ALTER TABLE `pagepermissionpropertyattributeaccesslistcustom` RENAME TO `PagePermissionPropertyAttributeAccessListCustom`;
ALTER TABLE `pagepermissionthemeaccesslist` RENAME TO `PagePermissionThemeAccessList`;
ALTER TABLE `pagepermissionthemeaccesslistcustom` RENAME TO `PagePermissionThemeAccessListCustom`;
ALTER TABLE `pageworkflowprogress` RENAME TO `PageWorkflowProgress`;
ALTER TABLE `permissionaccess` RENAME TO `PermissionAccess`;
ALTER TABLE `permissionaccessentities` RENAME TO `PermissionAccessEntities`;
ALTER TABLE `permissionaccessentitygroups` RENAME TO `PermissionAccessEntityGroups`;
ALTER TABLE `permissionaccessentitygroupsets` RENAME TO `PermissionAccessEntityGroupSets`;
ALTER TABLE `permissionaccessentitytypecategories` RENAME TO `PermissionAccessEntityTypeCategories`;
ALTER TABLE `permissionaccessentitytypes` RENAME TO `PermissionAccessEntityTypes`;
ALTER TABLE `permissionaccessentityusers` RENAME TO `PermissionAccessEntityUsers`;
ALTER TABLE `permissionaccesslist` RENAME TO `PermissionAccessList`;
ALTER TABLE `permissionaccessworkflows` RENAME TO `PermissionAccessWorkflows`;
ALTER TABLE `permissionassignments` RENAME TO `PermissionAssignments`;
ALTER TABLE `permissiondurationobjects` RENAME TO `PermissionDurationObjects`;
ALTER TABLE `permissionkeycategories` RENAME TO `PermissionKeyCategories`;
ALTER TABLE `permissionkeys` RENAME TO `PermissionKeys`;
ALTER TABLE `userpermissionassigngroupaccesslist` RENAME TO `UserPermissionAssignGroupAccessList`;
ALTER TABLE `userpermissionassigngroupaccesslistcustom` RENAME TO `UserPermissionAssignGroupAccessListCustom`;
ALTER TABLE `userpermissioneditpropertyaccesslist` RENAME TO `UserPermissionEditPropertyAccessList`;
ALTER TABLE `userpermissioneditpropertyattributeaccesslistcustom` RENAME TO `UserPermissionEditPropertyAttributeAccessListCustom`;
ALTER TABLE `userpermissionusersearchaccesslist` RENAME TO `UserPermissionUserSearchAccessList`;
ALTER TABLE `userpermissionusersearchaccesslistcustom` RENAME TO `UserPermissionUserSearchAccessListCustom`;
ALTER TABLE `userpermissionviewattributeaccesslist` RENAME TO `UserPermissionViewAttributeAccessList`;
ALTER TABLE `userpermissionviewattributeaccesslistcustom` RENAME TO `UserPermissionViewAttributeAccessListCustom`;
ALTER TABLE `workflowprogress` RENAME TO `WorkflowProgress`;
ALTER TABLE `workflowprogresscategories` RENAME TO `WorkflowProgressCategories`;
ALTER TABLE `workflowprogresshistory` RENAME TO `WorkflowProgressHistory`;
ALTER TABLE `workflowrequestobjects` RENAME TO `WorkflowRequestObjects`;
ALTER TABLE `workflows` RENAME TO `Workflows`;
ALTER TABLE `workflowtypes` RENAME TO `WorkflowTypes`;
ALTER TABLE `queuemessages` RENAME TO `QueueMessages`;
ALTER TABLE `queuepageduplicationrelations` RENAME TO `QueuePageDuplicationRelations`;
ALTER TABLE `queues` RENAME TO `Queues`;
ALTER TABLE `stacks` RENAME TO `Stacks`;
ALTER TABLE `systemantispamlibraries` RENAME TO `SystemAntiSpamLibraries`;
ALTER TABLE `systemcaptchalibraries` RENAME TO `SystemCaptchaLibraries`;
ALTER TABLE `btcorescrapbookdisplay` RENAME TO `btCoreScrapbookDisplay`;
ALTER TABLE `btcorestackdisplay` RENAME TO `btCoreStackDisplay`;
ALTER TABLE `btdashboardnewsflowlatest` RENAME TO `btDashboardNewsflowLatest`;
ALTER TABLE `jobsetjobs` RENAME TO `JobSetJobs`;
ALTER TABLE `jobsets` RENAME TO `JobSets`;
ALTER TABLE `collectionversionblocksoutputcache` RENAME TO `CollectionVersionBlocksOutputCache`;
ALTER TABLE `collectionversionrelatededits` RENAME TO `CollectionVersionRelatedEdits`;

Thanks to websanity (http://www.concrete5.org/profile/-/view/12856/) for providing this list, which saved some time:http://www.concrete5.org/community/forums/documentation_efforts/con...

Forums

Installation Help

Exporting from localhost to LIVE site

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?