Migrate C5 site to another host
Permalink
I need step by step instructions on how to do this.
I have this site at the momenthttp://www.lesleylaslett.com/site/...
and the host claims c5 is to resource heavy, but I know its not, as it works fine on dreamhost.
so my question is how do I migrate? and can I create an account for the domain on my new host, migrate, then update the dns, or do I have update the dns and then migrate?
I have this site at the momenthttp://www.lesleylaslett.com/site/...
and the host claims c5 is to resource heavy, but I know its not, as it works fine on dreamhost.
so my question is how do I migrate? and can I create an account for the domain on my new host, migrate, then update the dns, or do I have update the dns and then migrate?
sorry, that guide is not very clear
where it says "5. Move your c5 directory to where you want it to go, (the place where the index.php is"
wont this mess up the install of c5 on the new server? or don't I need to install it?
where it says "5. Move your c5 directory to where you want it to go, (the place where the index.php is"
wont this mess up the install of c5 on the new server? or don't I need to install it?
No, you don't need to install it. If you move your whole database to the new host and your entire directory structure, then as long as you update your config/site.php file with any change in domain name, then it should just work.
I always manually delete anything in the files/cache folder too, just to be sure. And don't forget to set your file permissions once you've moved...
Jon
I always manually delete anything in the files/cache folder too, just to be sure. And don't forget to set your file permissions once you've moved...
Jon
so how do I migrate the database? dreamhost's databases are not "local host"
Do you have access to phpMyAdmin at your current host and dreamhost? If so, you can use the export feature with your current host to get a complete dump of the database (be sure to tick the 'export data' AND 'export structure' tick boxes, and also the 'save as file' tick box) and then import it using phpMyAdmin at dreamhost. Then, in your site.php, just enter the ip address of the new database at dreamhost instead of 'localhost'.
Jon
Jon
thanks for that, I cant see the "export data and export structure boxs, please see the screenshot
They're already ticked - it's just the 'Data' and 'Structure' tick boxes ( my bad for working from memory! :) )
Jon
Jon
it sounds really easy but when importing I get this error!!
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.8.2.4
--http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Dec 21, 2010 at 02:22 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.3
--
-- Database: `circledance_data`
--
CREATE DATABASE `circledance_data` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation
#1044 - Access denied for user 'laslett'@'173.236.128.0/255.255.128.0' to database 'circledance_data'
any ideas?
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.8.2.4
--http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Dec 21, 2010 at 02:22 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.3
--
-- Database: `circledance_data`
--
CREATE DATABASE `circledance_data` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation
#1044 - Access denied for user 'laslett'@'173.236.128.0/255.255.128.0' to database 'circledance_data'
any ideas?
Ummm, yes:
Access denied for user 'laslett'@'173.236.128.0/255.255.128.0' to database 'circledance_data'
You either need to use a username that has access to create a database, or delete the "CREATE DATABASE" line and just add the structure and data to an existing database.
Jon
Access denied for user 'laslett'@'173.236.128.0/255.255.128.0' to database 'circledance_data'
You either need to use a username that has access to create a database, or delete the "CREATE DATABASE" line and just add the structure and data to an existing database.
Jon
sorry, you have really lost me now!!
Your user has no rights on the database using the IP you filled in.
if the database already exists, remove the part about "CREATE DATABSE..." since that won't work.
also make sure that the user "laslett" has full access permissions on the database circledance_data.
It looks to me however like you are not that advanced with databases and rights around it (no offence, your posts in this topic just make it seem like this) so I suggest you ask your hosting provider for support on this, they can help you by placing it for you or by giving you all the correct database info needed to place it yourself
if the database already exists, remove the part about "CREATE DATABSE..." since that won't work.
also make sure that the user "laslett" has full access permissions on the database circledance_data.
It looks to me however like you are not that advanced with databases and rights around it (no offence, your posts in this topic just make it seem like this) so I suggest you ask your hosting provider for support on this, they can help you by placing it for you or by giving you all the correct database info needed to place it yourself
it worked!!
http://www.laslett.dreamhosters.com/site/...
Dreamhost had a nice guide!!
http://wiki.dreamhost.com/Migrate_MySQL...
thanks ever so much for your help everyone!!
http://www.laslett.dreamhosters.com/site/...
Dreamhost had a nice guide!!
http://wiki.dreamhost.com/Migrate_MySQL...
thanks ever so much for your help everyone!!
http://www.concrete5.org/documentation/installation/moving_a_site...
:)
Regarding DNS - I always change that last. Move the site, get it working, then update.
Jon