Moving a Site

You must install Adobe Flash to view this content.

1. Backup your databse, this is just incase something goes wrong but nothing should

(An easy way to backup your database while not suggested is to use DavidMIRV's Addon) (in version 5.4 it is included by default)

2. Backup your file structure (the place you installed c5) this is also just incase something goes wrong.

Ok now for the moving part.

3. Disable AND clear the cache.

4. Disable Pretty url's (you can re-enable later)

5. Move your c5 directory to where you want it to go, (the place where the index.php is)

6. Open the /config/site.php NOT the /concrete/config folder.

7. You will see something that looks like this:

define('DB_SERVER', 'mysql.yoursite.com');
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'pass');
define('DB_DATABASE', 'dbname');
define('BASE_URL', 'http://site.com');
define('DIR_REL', '');
define('PASSWORD_SALT', 'JKSD84KSFU94WJHFS984JS0F03JF0SJ3');

there are 2 main lines we need to look at:

define('BASE_URL', 'http://site.com');
define('DIR_REL', '');

8. in the line:

define('BASE_URL', 'http://site.com');

Where it says your site name e.g. concrete5.org. Change that you your new url so it would be like"

define('BASE_URL', 'http://url.concrete5.org');

make sure there are NO slashes in it!

if you are installing it in the root directory of a domain (like concrete5.org and NOT concrete5.org/url) then you are done Yipee!!!!

9. If not you got 1 more step,

If you lets say are moving from the c5 site from this url:

concrete5.org/url

to this url:

concrete5.org

, this is what the line would look like:

define('DIR_REL', '/url');

to move it to the root directory just change it to:

define('DIR_REL', '');

if you are moving from

concrete5.org/url

concrete5.org/url2

you would just change the

/url

/url2

10. This step is only if you are moving your mysql database. You should have already backed up your database in Step 1. Open your site.php from the above steps:

define('DB_SERVER', 'mysql.yoursite.com');
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'pass');
define('DB_DATABASE', 'dbname');
define('BASE_URL', 'http://site.com');
define('DIR_REL', '');
define('PASSWORD_SALT', 'JKSD84KSFU94WJHFS984JS0F03JF0SJ3');

we are going to look at

define('DB_SERVER', 'mysql.yoursite.com');
define('DB_USERNAME', 'username');
define('DB_PASSWORD', 'pass');
define('DB_DATABASE', 'dbname');

from here its pretty obvious, insert the info for your database, but first! import the sql file you exported in Step 1.

If you have an error of missing tables execute the query below in phpadmin.

Thats it!

If you need any help PM me

Mike/Mnkras

Last updated 3/5/10

This was created for version 5.3.1.1 it may work on other versions.

RENAME TABLE areagroupblocktypes To AreaGroupBlockTypes;
RENAME TABLE areagroups To AreaGroups;
RENAME TABLE areas To Areas;
RENAME TABLE ataddress To atAddress;
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 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 blockrelations To BlockRelations;
RENAME TABLE blocks To Blocks;
RENAME TABLE blocktypes To BlockTypes;
RENAME TABLE btcontentfile To btContentFile;
RENAME TABLE btcontentimage To btContentImage;
RENAME TABLE btcontentlocal To btContentLocal;
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 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 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 collectionversionblockpermissions To CollectionVersionBlockPermissions;
RENAME TABLE collectionversionblocks To CollectionVersionBlocks;
RENAME TABLE collectionversionblockstyles To CollectionVersionBlockStyles;
RENAME TABLE collectionversions To CollectionVersions;
RENAME TABLE config To Config;
RENAME TABLE dashboardhomepage To DashboardHomepage;
RENAME TABLE downloadstatistics To DownloadStatistics;
RENAME TABLE fileattributevalues To FileAttributeValues;
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 filesetpermissions To FileSetPermissions;
RENAME TABLE filesets To FileSets;
RENAME TABLE filestoragelocations To FileStorageLocations;
RENAME TABLE fileversionlog To FileVersionLog;
RENAME TABLE fileversions To FileVersions;
RENAME TABLE groups To Groups;
RENAME TABLE jobs To Jobs;
RENAME TABLE jobslog To JobsLog;
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 pagepermissionpagetypes To PagePermissionPageTypes;
RENAME TABLE pagepermissions To PagePermissions;
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 pilecontents To PileContents;
RENAME TABLE piles To Piles;
RENAME TABLE signuprequests To SignUpRequests;
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 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;

Comments:

Posted by bryanlewis on Dec 29th, 2009

DavidMIRV's Addon is great but it would be sweet if there were a DavidMIRV's Addon on steroids. If it could back up the database and files and zip them up and allow for us to download the files onto our desktops. Anyone?! If I were advanced enough I'd give it a try... I hate to do this but here is a example of what I'm talking about...

http://extensions.joomla.org/extensions/access-a-security/backup/1606

Posted by Mnkras on Dec 30th, 2009

there was a site that had both of those things written out in php, if i find them ill post the link

Posted by fullflavour on Jan 04th, 2010

This guide works perfectly, thank you very much :)

Posted by fullflavour on Jan 04th, 2010

I recommend people have a look at this if dealing with mysql databases... http://support.tigertech.net/mysql-duplicate

Posted by trillium01 on Feb 26th, 2010

Almost accurate on the SQL stuff, except UserBannedIps needs to be UserBannedIPs.

Posted by ericwright17 on Feb 26th, 2010

This works great! Thank you! I do have to caution anyone who tries this, if you use 000webhost, you will have file ownership problems. They were unwilling to help me, but I did a reinstall, and imported the database as described above.

Posted by riotaj on Mar 03rd, 2010

Note for #3: "Disable AND clear the cache."

This is actually in the Dashboard after you have logged into your site. Go to:

Dashboard > Sitewide Settings > Debug

From here, you can disable and clear the cache. Good to know if you haven't explored the dashboard much.

Posted by Mnkras on Mar 05th, 2010

as a note to the above comment you can also delete the contents of the /files/cache_objects folder

Posted by medhatmsm on Mar 08th, 2010

to avoid "DataTimeZone" errors, you can un-check "Enable user defined time zones" from "Users & groups > logins & registrations" section in the dashboard.
After migration, I was unable to login/register or even access the dashboard. I fixed it by setting the timezone for admin to NULL in the db.
BTW, I was migrating from linux to windows.

You must be logged in to leave a reply.

Moving a Site

Comments:

Hot Spots...

Search site

Sign In?

You must have a user account and be signed in to post