Shulou(Shulou.com)06/01 Report--

First, let's introduce some common operation examples of MySQL backup command mysqldump:

1. Mysqldump backup

Export only table structure

D:/PHP/xampp/mysql/bin/mysqldump-h227.0.0.1-P3306-uroot-p123456 snsgou_sns_test-- no-data-- default_character-set=utf8 > d:/Python/data/snsgou_sns_test_table.sql

Mysqldump only exports data

D:/PHP/xampp/mysql/bin/mysqldump-h227.0.0.1-P3306-uroot-p123456 snsgou_sns_test-- no-create-info-- default_character-set=utf8 > d:/Python/data/snsgou_sns_test_data.sql

Mysqldump all export (including table structure and data)

D:/PHP/xampp/mysql/bin/mysqldump-h227.0.0.1-P3306-uroot-p123456 snsgou_sns_test-- default_character-set=utf8 > d:/Python/data/snsgou_sns_test.sql

2. Mysqldump restore (Note:-- force parameter, indicating that it will continue when an error is encountered)

D:/PHP/xampp/mysql/bin/mysql-h227.0.0.1-P3306-uroot-p123456 snsgou_sns_test-- force < d:/Python/data/snsgou_sns_table.sql d:/PHP/xampp/mysql/bin/mysql-h227.0.0.1-P3306-uroot-p123456 snsgou_sns_test-- force < d:/Python/data/snsgou_sns_data.sql/usr/local/mysql/bin/mysql-h227.0.0.1-P3306-uroot -pairsgears 123456 'snsgou_sns_test-- force < / root/2/snsgou_sns_test.sql

Note: mysqldump can only back up the export, but to restore it, you need to use the mysql command.

According to the above knowledge points, a script for regular backup of PHP to MySQL database is sorted out:

Configuration file: db.inc.jb51.net.php

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.