XF 2.2 How to import SQL backup on new host

[Rock75]

Hi, i am moving my forum to new host and domain, i already have SQL backup and server files backup, All i want to know how can i done this database (SQL) backup on new host through cPanel/phpMyAdmin?

 

[Paul B]

If it's a small DB then phpMyAdmin will be fine.

There is an Import button at the top of the PMA page - click that and browse to the .sql file.

 

[Rock75]

If it's a small DB then phpMyAdmin will be fine.

There is an Import button at the top of the PMA page - click that and browse to the .sql file.

its about 4mb, i want to know to transfer my forum to new host,i just need to
1.install xenforo on new host
2.import mysql database via phpmyadmin
3.upload my server files through ftp
Do I need to create new database and new database user or not?

 

[Paul B]

You will need to create the new db and user.

If you use different credentials you will need to update the src/config.php file.