Several methods of MySQL database backup

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.