Thursday 22 August 2013

Backing up your database using SSH


Not all hosting accounts have this, you'll have to ask your host if you have SSH access.

1. Log into your SSH account.

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

USERNAME  this is the username you use to access MySQL. You can find it out by looking in inc/config.php

DATABASENAME  the name of the database that MyBB is installed on.

/PATH/TO/DUMP.SQL  this is the path to the file that will be stored. If you don't know where to put it, use mybb_backup.sql or something like that.

No comments:

Post a Comment