#导出大表:
mysqldump –add-drop-table –single-transaction –triggers -R -quick –disable-keys -utest -ptest -P5616 test > test.sql
#仅导出表结构
mysqldump –add-drop-table –no-data –single-transaction –triggers -R -quick –disable-keys -utest -ptest -P5616 test > test.sql
#仅导出数据
mysqldump –no-create-info –single-transaction -quick –disable-keys -utest -ptest -P5616 test > datatest.sql
#还原备份:
mysql -uroot -p -P3100 test < yndzm.sql
mysql -utest -p -P3100 test < crttest.sql
mysql -utest -p -P3100 test < datatest.sql
转载于:https://www.cnblogs.com/wxb-km/p/3754396.html