LB Hosting

Problem:

How We can take MYSQL Backup?

Solution:

There are three type of option for taking MYSQL databases:

A) In the control panel, Use the backup utility.

B) You can take backup manually from phpMyAdmin. As below follow these steps:

Step A: Login to your cPanel and click phpMyAdmin icon in Databases section.
Step B: Select the database you wish to export the backup from the drop-down list.
Step C: Click on the Export Tab.
Step D: Click the Select ALL link shown in blue. Make sure the radio button for SQL is selected
Step E: Check the "Save as file", give it a file name and click GO button.
Step F: You will be asked to save the .sql file to the hard drive and click OK button.

C) Apply the command line in SSH.

  >mysqldump -u username -p database_name > file.sql
  >password 

Enter your password and this will put a copy of the database into file.sql

Keywords: MySQL backup database back-up