下文給大家?guī)碛嘘P(guān)MySQL數(shù)據(jù)庫邏輯備份工具mysqldump介紹內(nèi)容，相信大家一定看過類似的文章。我們給大家?guī)淼挠泻尾煌?？一起來看看正文部分吧，相信看完MySQL數(shù)據(jù)庫邏輯備份工具mysqldump介紹你一定會有所收獲。
[mysql@wallet01 ~]$ mysqldump --help -u, --user=name 指定連接數(shù)據(jù)庫云服務(wù)器使用的用戶 -p, --password 指定連接數(shù)據(jù)庫云服務(wù)器使用的密碼 -P, --port=# 指定連接數(shù)據(jù)庫云服務(wù)器使用的端口 -h, --host=name 指定連接數(shù)據(jù)庫云服務(wù)器的主機(jī)名 -A, --all-databases 備份全部的數(shù)據(jù)庫 -B, --databases 備份指定的數(shù)據(jù)庫 -t, --no-create-info 僅備份表記錄 -d, --no-data 僅備份表結(jié)構(gòu) -w, --where=name 僅備份表中匹配條件的記錄 -E, --events 備份數(shù)據(jù)庫的事件 -R, --routines 備份數(shù)據(jù)庫的存儲過程與函數(shù) --triggers 備份表的觸發(fā)器 -x, --lock-all-tables 鎖定全部數(shù)據(jù)庫中的全部表。 -T, --tab=name Create tab-separated textfile for each table to given path. (Create .sql and .txt files.) --fields-terminated-by=name Fields in the output file are terminated by the given string. --fields-enclosed-by=name Fields in the output file are enclosed by the given character. --lines-terminated-by=name Lines in the output file are terminated by the given string. --dump-slave[=#] This causes the binary log position and filename of the master to be appended to the dumped data output. Setting the value to 1, will printit as a CHANGE MASTER command in the dumped data output; if equal to 2, that command will be prefixed with a comment symbol. This option will turn --lock-all-tables on, unless --single-transaction is specified too (in which case a global read lock is only taken a short time at the beginning of the dump - don't forget to read about --single-transaction below). In all cases any action on logs will happen at the exact moment of the dump.Option automatically turns --lock-tables off. --master-data[=#] This causes the binary log position and filename to be appended to the output. If equal to 1, will print it as a CHANGE MASTER command; if equal to 2, that command will be prefixed with a comment symbol. This option will turn --lock-all-tables on, unless --single-transaction is specified too (in which case a global read lock is only taken a short time at the beginning of the dump; don't forget to read about --single-transaction below). In all cases, any action on logs will happen at the exact moment of the dump. Option automatically turns --lock-tables off. --single-transaction Creates a consistent snapshot by dumping all tables in a single transaction. Works ONLY for tables stored in storage engines which support multiversioning (currently only InnoDB does); the dump is NOT guaranteed to be consistent for other storage engines. While a --single-transaction dump is in process, to ensure a valid dump file (correct table contents and binary log position), no other connection should use the following statements: ALTER TABLE, DROP TABLE, RENAME TABLE, TRUNCATE TABLE, as consistent snapshot is not isolated from them. Option automatically turns off --lock-tables. 備份指定的庫 [mysql@wallet01 ~]$ mysqldump -uroot -p --databases tpcc100 > tpcc100.sql 備份指定的表 [mysql@wallet01 ~]$ mysqldump -uroot -p tpcc100 customer >customer.sql 僅備份表結(jié)構(gòu) [mysql@wallet01 ~]$ mysqldump -uroot -p --no-data tpcc100 customer >customer.sql 僅備份表記錄 [mysql@wallet01 ~]$ mysqldump -uroot -p --no-create-info tpcc100 customer >customer.sql 僅備份表中匹配條件的記錄 [mysql@wallet01 ~]$ mysqldump -uroot -p --where="c_state='z3'" tpcc100 customer >customer.sql 還原指定的庫 [mysql@wallet01 ~]$ mysql -uroot -p tpcc100 < tpcc100.sql 還原指定的表 [mysql@wallet01 ~]$ mysql -uroot -p tpcc100 < customer.sql 表結(jié)構(gòu)備份為sql文件，表記錄備份為文本文件 [mysql@wallet01 ~]$ mysqldump -uroot -p --tab=/var/lib/mysql-files \ --fields-terminated-by=',' --fields-enclosed-by='"' --lines-terminated-by='\n' tpcc100 customer [mysql@wallet01 ~]$ cd /var/lib/mysql-files [mysql@wallet01 mysql-files]$ ls -lh total 165M -rw-rw-r-- 1 mysql mysql 2.5K Sep 18 10:08 customer.sql -rw-rw-rw- 1 mysql mysql 165M Sep 18 10:08 customer.txt 還原表結(jié)構(gòu) [mysql@wallet01 ~]$ mysql -uroot -p tpcc100 < customer.sql 還原表記錄 [mysql@wallet01 ~]$ mysqlimport -uroot -p tpcc100 \ --fields-terminated-by=',' \ --fields-enclosed-by='"' \ --lines-terminated-by='\n' /var/lib/mysql-files/customer.txt Enter password: tpcc100.customer: Records: 300000 Deleted: 0 Skipped: 0 Warnings: 0
對于上文關(guān)于MySQL數(shù)據(jù)庫邏輯備份工具mysqldump介紹，大家覺得是自己想要的嗎？如果想要了解更多相關(guān)，可以繼續(xù)關(guān)注我們的行業(yè)資訊板塊。
另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點(diǎn)與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。
重慶分公司
重慶分公司
