总结
1. 导出指定库(ph_game_fight即库名)
mysqldump -h127.0.0.1 -uroot -p123456 ph_game_fight > ph_game_fight.sql
2. 导出指定库,指定表(ph_game_fight即库名,fight_0即表名)
mysqldump -h127.0.0.1 -uroot -p123456 ph_game_fight fight_0 > fight0.sql
3. 导出指定库,指定表,指定where条件
mysqldump -h127.0.0.1 -uroot -p123456 ph_game_fight fight_log_full --where="logid>=2500000 and logid < 3000000" > fight_log_full_3000000.sql
4. 导出指定库, 指定表,指定多行导出(默认只有一行insert语言,会很大)
mysqldump -h127.0.0.1 -uroot -p123456 log chat_log --skip-extended-insert > chat.sql