– From MySQL CLI
– From phpMyAdmin
In order to back up your database from MySQL CLI you will require 2 things:
• SSH or Telnet access to your site. You will need to check with your hosting company to see if this is available.
• An SSH/Telnet Client, such as PuTTy.
Open your SSH/Telnet client and log into your website. The command line prompt you will see will vary by OS. For most hosting companies, this will bring you into the FTP root folder.
Type in the following:
You will be prompted for the database password. Enter it and the database will backup. If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the host name to the command line. The host name will be the same as entered in your config.php.
The command line will be:
You can then, if you wish, download the backup to your home computer. We strongly recommend that you use this method to back up your database.
You can also generate a back up of your database using a third party software like phpMyAdmin. We are assuming phpMyAdmin is already installed on your server. Go to phpMyAdmin in your web browser and select the database you wish to back up by clicking on the name. If you have multiple databases, you will need to select the name from the drop menu.
In the right-hand frame, you will see a row of links. Click on Export.
Now in the right-hand frame you will see three sections. In the first section called Export you select the table(s) you wish to back up by selecting them from the list. To select multiple tables, hold the Ctrl key and lick the table names. To select all table, click the Select All link.
In the second section called SQL Options, make sure you have the following boxes checked:
Add ‘drop table’
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
In the third section check Save as file and type a name for the backup in the text box adjacent to File name template. If your system supports it, you may also choose a compression type. None is selected by default.
Click on Go and you will be prompted to save the backup on your local computer. Save the back up file on your computer.