mysqldump--Export Tools #导出某个数据库-structure + data shell>mysqldump-h192.168.161.124-uroot-pxxxxxx--opt db_name |gzip-9 >/ db_bakup/db_name.gz #导出某个数据库的表-structure + data + functions + stored procedure shell>mysqldump-h192.168.161.124-uroot-pxxxxxx--opt-r db_ Name |gzip-9 >/db_backup/db_name.gz #导出多个数据库shell >mysqldump-h192.168.161.124-uroot-pxxxxxx--opt-- Databases db_name1 db_name2 db_name3 |gzip-9 >/db_backup/mul_db.gz #导出所有的数据库shell >mysqldump- H192.168.161.124-uroot-pxxxxxx--opt--all-databases |gzip-9 >/db_bak/all_db.gz #导出某个数据库的结构shell > Mysqldump-h192.168.161.124-uroot-pxxxxxx--opt--no-data db_name|gzip-9 >/db_bak/db_name.strcut.gz # Export data for a database shell>mysqldump-h192.168.161.124-uroot-pxxxxxx--opt--no-create-info db_name|gzip-9 >/db_bak/db_ naem.data.gz #导出某个数据库的某张表shell >mysqldump-h192.168.161.124-uroot-pxxxxxx--opt db_name tbl_name |gzip-9 > /db_bak/db_name.tal_name.gz # the structure of a table that exports a database shell>mysqldump-h192.168.161.124-uroot-pxxxxxx--opt--no-data db_name tal_name | gzip-9 >/db_bak/db_name.tal_name.struct.gz #导出某个数据库的某张表的数据shell >mysqldump-h192.168.161.124-uroot- Pxxxxxx--opt--no-create-info db_name tbl_name | gzip-9 >/db_bak/db_name.tbl_name.data.gz ##--opt==--add-drop-table +--add-locks +--create-options +--disables-keys +--extended-insert +--lock-tables +--q Uick +--set+charset# #默认使用--opt,--skip-opt disable--opt parameter
Mysqldump Export--Data + structure + (functions + stored procedures)