备份数据库:
mysqldump -h hostname -P port -u username -p dbname table1 table2 … > C:\test.sql
https://www.cnblogs.com/shynshyn/p/7875246.html
使用备份的文件来还原数据库:
mysql -hlocalhost -P3306 -uroot -p dbname < C:\test.sql
备份数据库:
mysqldump -h hostname -P port -u username -p dbname table1 table2 … > C:\test.sql
https://www.cnblogs.com/shynshyn/p/7875246.html
使用备份的文件来还原数据库:
mysql -hlocalhost -P3306 -uroot -p dbname < C:\test.sql