Moving MySQL Database

I am considering changing hosting providers and I have a vBulletin forum database I will need to move. I don't want to lose anything so can someone exaplin how this is done? Thanks in advance.

 

You need to dump the database
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Then use the source command on new server
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html

 

if its a MySQL database that is

 

Thanks...if I have the database backed up on my computer...can I use the source command on the new server to upload it from there....and if so, will it be just like it is now?

 

You need to open your existing database in phpMyAdmin. Export it and save it on your PC

And then import it on new server with Import function in phpMyAdmin.

Thanks.

 

I think there is an upload limit when using phpmyadmin
Its about 5mb i think.
So if your database is larger than 5mb then you need to upload the .sql file to the new server and use the source command otherwise you can use phpmyadmin to upload it.

 

If you are on cPanel server then you can easily generate the full backup of your site and you can provide it to your new host to restore it. Also you can restore the database from PHPMyAdmin but if your database size is larger create backup copy for few tables instead of entire database in one file.

 

Export using phpmyadmin shouldnt be a problem... I exported an 80mb database .gzip format. The .gzip was only 5mb. When importing you will need to ungzip...