How to change hosts successfully

[SilentThief]

There doesn't seem to be an option to browse in the SQL tab.

[User 95342]

Thank you. Still works.

(1.8.5)

A bit of trouble because the SQL files were binary and not utf8. But opening notepad and saving as utf8, did the trick.

Thanks again.

[R3V1L3X]

thanks

[Amakvitaa]

after uploading the database, nothing refleted on my forum, please help, blognigeria.com

[cettaheng]

NO.
I have a website and i created the database and username i imported the database and still not works.
if someone can help me please send me a PM.
Thanks

[avixansa]

NO.
I have a website and i created the database and username i imported the database and still not works.
if someone can help me please send me a PM.
Thanks

pmed you

[Hacker007]

How to change hosts successfully

Description:
This tutorial will help you move your mybb community forum to another server/hosting account. If you have any errors or problems please reply or post in the support board.

Step 1

First go into your MyBB administrator control panel and disable all plugins then go down to Database Tools on the left frame and select Backup Database. Once you are brought to a new page on the right you will see a box with all of your database tables, on the left of that you will see "Select All", click that. Now make sure the following fields are checked:

GZIP Compressed
Download
Structure and Data
Analyse and Optimise Selected Tables: YES
Perform a sequential backup? YES


Now it will ask you to download the database file. Save it to your desktop or where ever you want.

Step 2

Download all of your forum files, download the WHOLE forum folder to your computer in your FTP Client.
Go into your new hosting control panel and create a mysql database and user.
Now open /inc/config.php and change it to your new host mysql database information you just created.

Note: only change the following lines:

$config['hostname'] = ' ';
$config['username'] = ' ';
$config['password'] = ' ';
$config['database'] = ' ';
$config['table_prefix'] = 'mybb_';

Now edit /inc/settings.php and edit the settings.


Once you have edited the files, save them and upload your forum folder to your new host using a FTP client.


Step 3

Go into your new hosting control panel and find out how to get into phpmyadmin. Once
you are in phpmyadmin click on your database name on the left. Once you click on the database
you will have access to all of the database tables. Now look at the top on the right for the tab that
says "SQL". Now look down to where it has a browse button and says "Or  Location of the text file:".
Click on the browse file to find the Database Backup you downloaded on your old forums.
Then click the "GO" button, once its done it will have inserted all of the database a

Step 4

Go to your new forum URL and it should let you in it, then login with your username and password
from your old forum and then your all set, your forum should work the same as if it was on your
old host.

If you need help with anything just reply

FAQS:

Question:
When I click any forum link it takes me to the old host???
Answer:

If you type in your new domain address followed by /admin then you will be directed to the new Admin CP.
Then change (in your settings) the board URL to the new URL, and the other options of a similar nature, obviously.

Before doing so, ensure all files are correctly CHMOD'ed.

what is the way of cloud VMs like in Azure or AWS or Google Cloud which instalations are certified by bitnami???....is there any way if I somehow setup any FTP server in it?

   

[Darth Apple]

@Hacker007:

Host: sftp://your_ip_address
Username: root (or Ubuntu, or whatever your username is
Password: [your password]
Port: 22

This will work out of the box on almost any VPS. The sftp:// part is required before the IP address on the host, and the port must be 22. It will otherwise work perfectly within filezilla.

[Hacker007]

@Hacker007:

Host: sftp://your_ip_address
Username: root (or Ubuntu, or whatever your username is
Password: [your password]
Port: 22

This will work out of the box on almost any VPS. The sftp:// part is required before the IP address on the host, and the port must be 22. It will otherwise work perfectly within filezilla.

I don't have to setup any FTP server??...then who should accept my connection on port 22?

[Crazycat]

Most of the linux distributions have sshd enable by default, and sshd integrates a sftp (ftp over ssh) server.
If not, just connect via ssh and install ftp server using the usual commands (like sudo apt-get)