how to move website to another hosting server when db name changes?

Question

I need to move my q&a website to another hosting.

in the new hosting the database name get a new prefix so the database name changes.

how do i make the transfer after transfering the files and the database?

shoul i change something else except the database detailes in the qa-config file?

Answer 1

1. Copy all source file including themes and plguin to new host
2. Export existing database and import to the new host
3. in qa-config.php modify the new database information
4. If domain or site url is not the same than modify site_url content to your new site url in qa_options table

Just make sure you do not delte your existing site untlill you tested new one. Just in case anything goes wrong you will always have the original site.