导出带数据的DUMP (忽略部分表)
mysqldump --set-gtid-purged=OFF --skip-lock-tables --ignore-table=merchant.glb_person_login_log --ignore-table=merchant.glb_dest_hirchy_mst_old --ignore-table=merchant.glb_shop_dest_hirchy_tbl_old -P 3301 -h dev-dm-intl401z.dev.jp.local -u merchant_user -p merchant>e:/merchant2.sql
导出不带数据的DUMP
mysqldump --no-data --set-gtid-purged=OFF --skip-lock-tables -P 3301 -h dev-dm-intl401z.dev.jp.local -u merchant_user -p merchant>e:/merchant_nodata.sql
Linux环境下
/MYSQL/cloud101/product/bin/mysqldump -u root -P 3301 merchant -S /usr/local/mysql/sock/cloud101.sock --set-gtid-purged=OFF --skip-lock-tables --ignore-table=merchant.glb_person_login_log --ignore-table=merchant.glb_shop_status_log --ignore-table=merchant.glb_merchant_status_log >/tmp/merchant3.sql
查看数据库大小
SELECT s.schema_name, CONCAT(IFNULL(ROUND((SUM(t.data_length)+SUM(t.index_length)) /1024/1024,2),0.00),"Mb") total_size, CONCAT(IFNULL(ROUND(((SUM(t.data_length)+SUM(t.index_length))-SUM(t.data_free))/1024/1024,2),0.00),"Mb") data_used,CONCAT(IFNULL(ROUND(SUM(data_free)/1024/1024,2),0.00),"Mb") data_free,IFNULL(ROUND((((SUM(t.data_length)+SUM(t.index_length))-SUM(t.data_free)) /((SUM(t.data_length)+SUM(t.index_length)))*100),2),0) pct_used,COUNT(table_name) total_tables FROM INFORMATION_SCHEMA.SCHEMATA s LEFT JOIN INFORMATION_SCHEMA.TABLES t ON s.schema_name = t.table_schema WHERE s.schema_name = "merchant" GROUP BY s.schema_name ORDER BY pct_used DESC\G;