Moving CMS Files to New Server

[slloyd]

Are there instructions somewhere on the site that explains, step-by-step, how to move your cms to a new server? I've moved three of my sites so far. Two were successful, one was not. I think the upgrade since the cms was created caused the error message I got. But, I couldn't fix it and ended up starting from the beginning and copying and pasting everything over. Not so bad considering it was a small site, but the next site I need to move is very large. I'm hesitant to do it because I'm afraid I'm going to run into the same problems again and I don't want an extended downtime. Can anyone help with SPECIFIC instructions?

[jubydoo]

I've had to do this a few times (I had one website that I had to move from one computer, to another, to another, to the production server under a subdomain, and then finally to production - that was fun), but it's really very easy if you haven't made any changes to the CMSMS code itself.  Go into phpMyAdmin (assuming you have it) and generate a dump of your database.  If you look along the top edge of the screen there's an Export option, it's under that.  phpMyAdmin will place the dump in a text box, copy it and save it to a file.

Now, go onto your new server and create a new database to store your CMSMS data.  Use the dump (through the Import options) to upload your database.  Since all of your content, templates, stylesheets, etc. are stored in the database, now all you have to do is install CMSMS on your new server, taking care to de-select the options for creating the tables and filling them with example data - this will wipe out your old CMSMS data.  Bingo, you're done!

[slloyd]

de-select the options for creating the tables and filling them with example data - this will wipe out your old CMSMS data.  Bingo, you're done!

I'm not sure how to do that. Can you explain? I know I didn't do that with the other sites I transferred, yet it somehow worked.

[Dr.CSS]

http://forum.cmsmadesimple.org/index.ph ... 699.0.html

[slloyd]

Thanks, Mark. I wish I would've had that before I screwed it up. In the forum thread 'fatal error message' you can see that I ran into issues.

Now I have the cms installed on the new server, but the database didn't transfer over. When I try to import into My SQL, I get this message:


SQL query:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 15, 2006 at 07:54 PM
-- Server version: 4.0.16
-- PHP Version: 5.1.4
--
-- Database: `lazyhous_cms`
--
-- --------------------------------------------------------
--
-- Table structure for table `cms_additional_htmlblob_users`
--
CREATE TABLE `cms_additional_htmlblob_users` (

`additional_htmlblob_users_id` int( 11 ) NOT NULL default '0',
`user_id` int( 11 ) default NULL ,
`htmlblob_id` int( 11 ) default NULL ,
PRIMARY KEY ( `additional_htmlblob_users_id` )
) TYPE = MYISAM


That's the same error message I got when trying to transfer my last website to the new server. Please help!

[cyberman]

Have you tried MassMover module?

A module which allows you to (eventually, that is) move and entire site from one place to another, including whole database-structure with content, user-uploaded files, non-core modules, and optionally the whole shabang including the core.

[slloyd]

No, I haven't. But from what I've read, it's way over my head. Besides, now that I've re-installed the cms on the new server under the same domain name, aren't those files gone? All I have is the .sql file.

This is so frustrating!

[cyberman]

Are there instructions somewhere on the site that explains, step-by-step, how to move your cms to a new server?

Have you worked like this and yubidoo said?

http://wiki.cmsmadesimple.org/index.php ... New_Server

That's the same error message I got when trying to transfer my last website to the new server.

Hmm, you can't create a table which exists ... what have you done before if you get the error message?

If you are not sure to transfer the website, try it before on a local server like Xampp.

Can you post a link?

[slloyd]

That's the error message I get when I try to import the .sql file to the new My SQL database.