Divine Forces Posted November 25, 2009 Share Posted November 25, 2009 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? >_< Link to comment Share on other sites More sharing options...
Bono Posted November 25, 2009 Share Posted November 25, 2009 [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. Link to comment Share on other sites More sharing options...
3DKiwi Posted November 26, 2009 Share Posted November 26, 2009 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 Link to comment Share on other sites More sharing options...
Divine Forces Posted November 26, 2009 Author Share Posted November 26, 2009 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? Link to comment Share on other sites More sharing options...
Bono Posted November 26, 2009 Share Posted November 26, 2009 [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. Link to comment Share on other sites More sharing options...
Divine Forces Posted November 27, 2009 Author Share Posted November 27, 2009 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? Link to comment Share on other sites More sharing options...
Luke Posted November 27, 2009 Share Posted November 27, 2009 How are you importing the database? Sounds like a timeout. Link to comment Share on other sites More sharing options...
MindTooth Posted November 27, 2009 Share Posted November 27, 2009 Read here about using mysqldump: http://viralpatel.net/blogs/2009/01/mysql-database-backup-mysql-mysqldump-backup-command.html Birger :) Link to comment Share on other sites More sharing options...
3DKiwi Posted November 27, 2009 Share Posted November 27, 2009 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.