导出某个库的cj_dy_withdraw_detail表的数据及结构(database名称及表名请更换成自己的):
mysqldump database -h 127.0.0.1 -u username -p –table cj_dy_withdraw_detail >./cj_dy_withdraw_detail.sql
导出指定表的结构:
mysqldump -d database -h 127.0.0.1 -u username -p –table cj_dy_withdraw_detail >./cj_dy_withdraw_detail.sql
导出指定库的全部数据和结构:
mysqldump database -h 127.0.0.1 -u username -p >./cj_dy_withdraw_detail.sql
