Move CMS and all data from webhost to another

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

By ross - April 13, 2009

Hi Kate

That all sounds about right to me. We don't usually do a whole lot with phpMyAdmin though. Did you want to give MySQL Query Browser a try? I am not exactly an expert with that one either so I don't know how much I can do to help but it's definitely something you might want to give a shot.

Of course, you could also get in touch with your new webhost, show them the database dump you have and ask them to explain how to get that into your new database.

Keep me up to date with how you are making out :).
-----------------------------------------------------------
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_ - 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?

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!