How to backup your Mysql database with phpMyAdmin?

Backing Up Your MySQL Database:

Step 1. To manage your MySQL database, you'll first need to login to the phpmyadmin.

Step 2. Click Export in the Menu to get to where you can backup you MySql database

Step 3. Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value. Check "Enclose table and field name with backquotes". Check "DATA", check use "hexadecimal for binary field". Export type set to "INSERT".

Step 4. Check "Save as file", do not change the file name, use compression if you want. Then click "GO" to download the backup file.

 


MySQL Import: How to restore your MySQL database from a backup:

To restore (import) a database via phpMyAdmin, first choose the database you'll be importing data into. This can be done from the corresponding menu on the left.

You have the option of importing an .sql file. Choose the file from your local computer. Note that you are given the option to pick the character set of the file from the drop down-menu just below the upload box. If you are not certain about the character set your database is using just leave the default one.

In order to start the restore click on the Go button at the bottom-right. A notification will be displayed upon a successful database import.

  • 0 Users Found This Useful
這篇文章有幫助嗎?

相關文章

Domain Can not view accounts in cPanel/WHM

There are many reason for an active account to  disappear from WHM List Accounts. Assuming the...

Explain Awstats Stats

The Awstats tool provides very useful information about the visits on your website. In this...

Generate CSR From Cpanel

To Generate a Certificate Signing Request (CSR) perform the following steps:1. Login to cPanel.2....

How can I access my website statistics

Your website's statistics are available under the Logs section in your cPanel. There you will see...

How can I check my quota and bandwidth limits/usage?

The statistics for your account's disk space and bandwidth usage are available in your cPanel,...