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

derived mysqldump -h localhost -u root -p -P -d dbname > db.sql

Command line usage is as follows: mysqldump -h remote-u user name-p password-P port-d database name table name sql statement;

* 1. Export the table structure of database dbname (where user name is root, password is dbpasswd, sql statement generated db.sql) mysqldump -uroot -pdbpasswd -d dbname > b.sql;* 2. export database dbname a table (test) structure mysqldump -uroot -pdbpasswd -d dbname test > db.sql;* 3. Export database dbname All table structures and table data (without-d) mysqldump -uroot -pdbpasswd dbname > db.sql;* 4. Export database dbname a table (test) structure and table data (without-d) mysqldump -uroot -pdbpasswd dbname test > db.sql; import mysql -h 127.0.0.1-P 3306 -uroot -pdbpasswd dbname < db.sql

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.