常用命令

mysqldump -u dbuser -p dbname > dbname.sql

mysqldump -u root -p root > dbname.sql

mysql -h localhost -u root -p phpcms< D:\mysql\phpcms.sql\

mysqldump -u root -p zhbcms30 < G:\CPS\MS3.0\zhbcms30.sql

 

mysql -u root -p
root
show databases
use zhbcms30
source D:/mysql/phpcms.sql;

 

mysqldump -h 10.100.19.85 -u cpdev -p cpdb_dev > cpdb_dev_20171225.sql
mysqldump -h 10.100.19.85 -u cpdev -p cpdb_dev > cpdb_dev_20180611.sql
mysqldump -u root -p zhbcms30 < G:\CPS\MS3.0\zhbcms30.sql

mysqldump -uroot -pdbpasswd dbname test1 test2 test3>db.sql;

mysqldump -u root -p ns_crm < D:\project\BI\localSvn\ns_crm.sql

mysql -u root -p
root
show databases
use zhbcms30
source D:/mysql/phpcms.sql;

show database
use zhht
source