Changing Servers -> Moving Database

[Divine Forces]

Hello, I am looking to change hosts from the one I am currently on however I would like to move my database to the other host and before I do it I would just like to make sure I have a few things correct. So I've exported my Database onto my computer (everything seems to be there) so would I just import that using myPHPadmin on a blank database then install the forums to using that database and keep all my things from old forums? >_<

[Bono]

[quote name='Adam C' date='25 November 2009 - 06:52 PM' timestamp='1259171573' post='1882392']
Hello, I am looking to change hosts from the one I am currently on however I would like to move my database to the other host and before I do it I would just like to make sure I have a few things correct. So I've exported my Database onto my computer (everything seems to be there) so would I just import that using myPHPadmin on a blank database then install the forums to using that database and keep all my things from old forums? >_<

This will work if you have small database, with databases bigger than 200MB you should import your database from shell.

[3DKiwi]

Ditto using a shell.

What you should be doing is setting up a test forum on thye new server then test restoring the database.

3DKiwi

[Divine Forces]

I see, also if my old Forums were on a Windows host is it possible to move the database to a Linux host or will I have to remain with Windows?

[Bono]

[quote name='Adam C' date='26 November 2009 - 01:10 PM' timestamp='1259237431' post='1882586']
I see, also if my old Forums were on a Windows host is it possible to move the database to a Linux host or will I have to remain with Windows?



You can move database to linux, on all platforms mysql is same.

[Divine Forces]

I go to Import my Database and it loads for a while then suddenly this error comes up;

Error

SQL query:

/*!40000 ALTER TABLE `core_sys_lang_words` DISABLE KEYS */;

MySQL said:
#2006 - MySQL server has gone away

and it stops importing my Database and leaves me with half a database <_< I am importing the Database BEFORE installing the Forums is that the correct way to do so?

[Luke]

How are you importing the database? Sounds like a timeout.

[MindTooth]

Read here about using mysqldump: http://viralpatel.net/blogs/2009/01/mysql-database-backup-mysql-mysqldump-backup-command.html

Birger :)

[3DKiwi]

This article here in the IPS knowledge base is how I do it. Exporting and restoring large databases is a doddle using this method. Just make sure that when you are restoring a database that you have first created a new blank database.

3DKiwi