Move CMS and all data from webhost to another

14 posts by 3 authors in: Forums > CMS Builder
Last Post: May 22, 2009   (RSS)

Re: [ross] Move CMS and all data from webhost to another

By _kate_ - April 30, 2009

Hi,
My new webhost has been trying to sort this out for me. Here's what they said >

I have tested the database that was has uploaded and even tried to import the sql dump on a separate test database and use this test
database instead (this test database has now been deleted). Unfortunately it looks like further application settings (apart from updating the database details) might need to be changed in order to have the database data displayed in the application. In most cases, importing the database tables into a database hosted with us and simply updating the database details is sufficient to have the website working as expected.

We have imported the database and updated the database settings accordingly onto the application, however the data still does not load as expected. I have tried to look on the application help webpage and I believe I found your thread there (this one).

If so, are you able to ask Ross, if there is anything else that needs to be
done apart from importing the database dump into the existing database and updating the database details?

By ross - April 30, 2009

Hi Kate

Did you already go through your new installation and setup the same sections as the old installation? There won't be any data in them right away of course, but the tables will be created and the fields setup already in your new database.

To make this step easier, just copy everything in the old /data/schema/ folder and move it to the new /data/schemaPresets/ folder. Then when you are creating new sections in the new installation, your old sections will be listed as options.

Once that's done, the data import should go smoother.

Does that make sense? There were a lot of "news" and "olds" in my explanation :).
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Re: [ross] Move CMS and all data from webhost to another

By _kate_ - May 22, 2009

Hi Ross. Yes I did as you described as above but was stuck at uploading the data.

WOW. Can't believe how many different things I had to try to figure out what it wasn't working!! Have finally managed to copy my first site over. For anyone else reading experiencing problems I kept getting an error in phpadmin saying table already exists for each section.

I exported the data again but made sure "IF NOT EXISTS" was NOT checked, and as soon as I did that the data uploaded and is now working fine!