mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL

n this line, you should change the following: USERNAME – this is the username you use to access MySQL. It is specified in your config.php file. DATABASENAME – the name of the database which your vBulletin is installed into. It is specified in your config.php file. /PATH/TO/DUMP.SQL – this is the path to the file that will be outputted. If you are unsure what to put here, simply use dbname_bak.sql or something similar.

When you press enter, you will be prompted for the password you use to access MySQL. This is also specified in your config.php file. The system will dump the database once you have entered the correct password. Verify that DUMP.SQL exists in the directory you specified. If you did not specify a full directory, the file will be in the directory you are currently in.

Repeat this procedure for each database you wish to backup.

Bookmark this article