Changing to another host . . .

[pts123]

I'm moving my vBulletin 4.0.8 from one host to another. They both use the standard Control Panel, the DB is MySQL and they both have PHPAdmin available.

I have copied the directory holding the site over, but not sure which is the best way to do the DB?

Do I want to just do a normal backup wizard type backup of the database, it creates a sql.gz file. Then go create the database at the new host and restore into it . . . or . . . use PHPAdmin and do an export locally. And I was told I can then on the new host do a PHPAdmin import?

Which way is best and since I cannot create the same DB name either way, where do I find the config file in the vBulletin directory to let it know the new database name, Help and Thanks

[borbole]

Originally Posted by pts123

I'm moving my vBulletin 4.0.8 from one host to another. They both use the standard Control Panel, the DB is MySQL and they both have PHPAdmin available.

I have copied the directory holding the site over, but not sure which is the best way to do the DB?

Do I want to just do a normal backup wizard type backup of the database, it creates a sql.gz file. Then go create the database at the new host and restore into it . . . or . . . use PHPAdmin and do an export locally. And I was told I can then on the new host do a PHPAdmin import?

Which way is best and since I cannot create the same DB name either way, where do I find the config file in the vBulletin directory to let it know the new database name, Help and Thanks

If your db is not big, then export it through phpmyadmin at the old host and import it with phpmuadmin again at your new host. If you have a large db then it would be better if you used a third party tool such as MySQL Dumper or use SSH or Telnet if your host allows it.

To update the db info, you must do it at the config.php file which can be found in the includes directory.