I have switched hosts many times, and its is very frustrating if something goes wrong, so today we have this tutorial to try and avoid that!
First, you need to go to your forums ACP and disable all the plugins then go to tools and maintenance and select "Backup Database" from there, you need to select all the tables and download in the following format:
Quote:File Type: GZIP Compressed
Save Method: Download
Backup Contents: Structure and Data
Analyse and Optimise Selected Tables: Yes
Select the "Perform Backup" button and download that backup to your desktop.
Second, Download all your forum files, use an FTP client (For Example: FileZilla) and download your forum files that you uploaded when you first installed MyBB. Now, in your new hosting control panel, create a new MySQL database and user and open the newly downloaded forum file
Quote:/inc/config.php
and change the following details to fit your new MySQL Database and user.
Quote:$config['hostname'] = ' ';
$config['username'] = ' ';
$config['password'] = ' ';
$config['database'] = ' ';
$config['table_prefix'] = 'mybb_';
Make sure you change the table prefix to whatever you used when you first created your MyBB installation. Now, save and upload all the newly downloaded forum files to your new site
Third, In your new hosting control panel, log into PHPMyAdmin and select your newly created database from the left. On the top tabs, you will see a tab saying "Import" select that and browse for the backup file you just downloaded. Select the encoding on this database (Usually utf8) then click "Go"
Forth, go to your forum URL and make sure everything is working well, you should be able to login, and do everything you could before.
If you need some help, please just ask here
--Conor