Backing up and Restoring Databases
#1
I've noticed a lot of questions on how to backup and restore databases. This thread should help everyone.

There are two ways to backup your database, phpMyAdmin or SSH.

Backing up your database using phpMyAdmin

1. Login to phpMyAdmin and select the database you wish to dump

2. Click on the �Export� tab at the top of the page

3. Click �Select All� below the list of tables

4. Make the format is SQL

5. Click �Save as File� to download the result, or leave this box unticked to view it on-screen

6. Ensure that both �Structure� and �Data� are ticked

7. Choose a compression type, if any, from the bottom of the form

8. Click �Go�

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.
Reply


Messages In This Thread
Backing up and Restoring Databases - by marcgo15 - 2005-05-19, 09:26 PM
RE: Backing up and Restoring Databases - by imei - 2005-12-11, 06:36 PM
RE: Backing up and Restoring Databases - by - 2006-05-06, 07:13 AM
RE: Backing up and Restoring Databases - by - 2006-06-28, 05:42 PM
RE: Backing up and Restoring Databases - by imei - 2006-08-12, 05:30 AM
RE: Backing up and Restoring Databases - by judel - 2006-09-09, 06:45 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)