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?

paulvwells
View Replies: View Best Answer
jbx replied on at Permalink Reply
jbx
You mean like this step by step guide?
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
paulvwells replied on at Permalink Reply
paulvwells
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?
jbx replied on at Permalink Reply
jbx
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
paulvwells replied on at Permalink Reply
paulvwells
so how do I migrate the database? dreamhost's databases are not "local host"
jbx replied on at Permalink Best Answer Reply
jbx
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
paulvwells replied on at Permalink Reply 1 Attachment
paulvwells
thanks for that, I cant see the "export data and export structure boxs, please see the screenshot
jbx replied on at Permalink Reply
jbx
They're already ticked - it's just the 'Data' and 'Structure' tick boxes ( my bad for working from memory! :) )

Jon
paulvwells replied on at Permalink Reply
paulvwells
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?
jbx replied on at Permalink Reply
jbx
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
paulvwells replied on at Permalink Reply
paulvwells
sorry, you have really lost me now!!
Brainakazariua replied on at Permalink Reply
Brainakazariua
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
paulvwells replied on at Permalink Reply
paulvwells
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!!