下文给大家带来有关MySQL数据库逻辑备份工具mysqldump介绍内容，相信大家一定看过类似的文章。我们给大家带来的有何不同呢？一起来看看正文部分吧，相信看完MySQL数据库逻辑备份工具mysqldump介绍你一定会有所收获。
创新互联公司成立十年来，这条路我们正越走越好，积累了技术与客户资源，形成了良好的口碑。为客户提供
成都做网站、网站制作、网站策划、网页设计、
主机域名、网络营销、
VI设计、网站改版、漏洞修补等服务。
网站是否美观、功能强大、用户体验好、性价比高、打开快等等，这些对于网站建设都非常重要，创新互联公司通过对建站技术性的掌握、对创意设计的研究为客户提供一站式互联网解决方案，携手广大客户，共同发展进步。
[mysql@wallet01 ~]$ mysqldump --help
-u, --user=name 指定连接数据库云服务器使用的用户
-p, --password 指定连接数据库云服务器使用的密码
-P, --port=# 指定连接数据库云服务器使用的端口
-h, --host=name 指定连接数据库云服务器的主机名
-A, --all-databases 备份全部的数据库
-B, --databases 备份指定的数据库
-t, --no-create-info 仅备份表记录
-d, --no-data 仅备份表结构
-w, --where=name 仅备份表中匹配条件的记录
-E, --events 备份数据库的事件
-R, --routines 备份数据库的存储过程与函数
--triggers 备份表的触发器
-x, --lock-all-tables 锁定全部数据库中的全部表。
-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
仅备份表结构
[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
表结构备份为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
还原表结构
[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
对于上文关于MySQL数据库逻辑备份工具mysqldump介绍，大家觉得是自己想要的吗？如果想要了解更多相关，可以继续关注我们的行业资讯板块。
另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
网站名称：MySQL数据库逻辑备份工具mysqldump介绍-创新互联
当前URL：
http://cdkjz.cn/article/gcodi.html
