7.4 Using mysqldump for Backups使用mysqldump进行备份

7.4.1 Dumping Data in SQL Format with mysqldump使用mysqldump以SQL格式转储数据
7.4.2 Reloading SQL-Format Backups导入SQL备份文件
7.4.3 Dumping Data in Delimited-Text Format with mysqldump使用mysqldump以分隔文本格式转储数据
7.4.4 Reloading Delimited-Text Format Backups重新加载分隔文本格式备份
7.4.5 mysqldump Tipsmysqldump提示
Tip

Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL Database Service compatibility checks and modifications. 考虑使用MySQL Shell转储实用程序,该实用程序提供多线程并行转储、文件压缩和进度信息显示,以及Oracle云基础设施对象存储流和MySQL数据库服务兼容性检查和修改等云功能。Dumps can be easily imported into a MySQL Server instance or a MySQL Database Service DB System using the MySQL Shell load dump utilities. 转储可以使用MySQL Shell加载转储实用程序轻松导入MySQL Server实例或MySQL数据库服务DB系统。Installation instructions for MySQL Shell can be found here.MySQL Shell的安装说明可以在这里找到。

This section describes how to use mysqldump to produce dump files, and how to reload dump files. A dump file can be used in several ways:本节介绍如何使用mysqldump生成转储文件,以及如何重新加载转储文件。转储文件可以通过多种方式使用:

mysqldump produces two types of output, depending on whether the --tab option is given:mysqldump根据是否给出--tab选项产生两种类型的输出:

7.4.1 Dumping Data in SQL Format with mysqldump
7.4.2 Reloading SQL-Format Backups
7.4.3 Dumping Data in Delimited-Text Format with mysqldump
7.4.4 Reloading Delimited-Text Format Backups
7.4.5 mysqldump Tips