Several methods of MySQL database backup

Source: Internet
Author: User

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Data backup is a Web site can operate the security, data backup including the site source backup and database backup, if you are using Access database, then directly use FTP to download the database files can be, but if you use the Php+mysql website construction, Database backups are not that easy. Here are some ways to backup MySQL databases.

Method One: If you are using a virtual host, you can use phpMyAdmin to back up the database.

1) Landing phpMyAdmin. After landing, the list of databases appears on the left, click the database you want to back up, as shown.

  

2 in the pop-up page, the upper right click the "Export" button, generally keep the default options, the bottom "Save as File", select "Zip Compression", and finally click the Execution button, as shown

  

3 after the Save file pops up, save the file, as shown.

  

Method Two: If your database can use external links. You can use Sqlyogent to back up.

1 open sqlyogent, and login MySQL server, the previous article has been said, if you do not understand can see here, "MySQL management tool sqlyogent First (PHP database)."

2 in the left Database menu, select the library you want to back up and right-click it. In the menu that pops up, select backup Database as SQL dump, as shown in figure.

  

3 in the pop-up dialog box, "Export to file" immediately back up the database file to save the location, other leave the default options, click the "Export" button, start the backup. As pictured.

  

If the database is stored in a server with the program, and the database address for localhost, the backup MySQL database generally use the first method, if your MySQL database can be external login, you can use the second way. If you are a stand-alone server, you can directly copy the database source files, this is not explained in detail.

Reprint please keep the address www.yzmstzsb.com, thank you.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.