MySQL导出DUMP命令备忘

来源：互联网发布：nvh有限元软件编辑：程序博客网时间：2024/05/01 16:38

导出带数据的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;

0 0