Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-compression-options.html
punch-hole: ( Enables support for transparent page compression for InnoDB tables for directory backups, which means that when the target platform for the mysqlbackup backup or restore operation supports hole punching, mysqlbackup keeps the punched ... For an overview on backup compression, see Section 4.3.4, “Making a Compressed ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-repository-options.html
When restoring a single-file backup created with the option setting use-tts=with-minimum-locking, the folder specified with --backup-dir is also used for extracting temporarily all the tables in the backup and for performing an apply-log operation ... These options specify various parameters related to the backup image or directory, or to how the backup will be ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/manifest-usage.html
A management tool might use this information to confirm which tables are part of a backup. Each backup directory includes some files in the meta subdirectory that detail how the backup was produced, and what files it contains. The files containing ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-backup-cloud.html
Only single-file backups can be created on and restored from a cloud storage. All mysqlbackup options compatible with single-file operations (including, for example, the incremental, compression, partial, and encryption options) can be used with ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.full.html
Most backup strategies start with a complete backup of the MySQL server, from which you can restore all databases and tables. The timestamped subdirectories make it simpler to establish retention periods, allowing easy removal and archiving of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.restore.html
Use, for example, the copy-back-and-apply-log command, which converts the raw backup into a prepared backup by updating it to a consistent state, and then copies the tables, indexes, metadata, and any other required files onto a target server. To ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.verify.html
You can then execute SHOW statements to verify the database and table structures, and execute queries to verify further details of the database. You can check the integrity of your backup using the validate command. The following is a sample ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/restore.external-tablespaces.html
When a backup contains external InnoDB tablespaces that resided outside of the backed-up server's data directory, you can restore them to locations different from their original ones by updating their path names in the tablespace_tracker file ...
https://dev.mysql.com/doc/connector-cpp/9.7/en/connector-cpp-apps-general-considerations.html
The intent of the macros is to provide a way to systematically and predictably maintain version numbering of the Connector/C++ product. This section discusses general considerations to keep in mind when building Connector/C++ applications. For ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-configuration-file-locations.html
The configuration is stored per router as JSON in the mysql_innodb_cluster_metadata.routers table with one row per router. MySQL Router scans for the default configuration files at startup, and optionally loads user-defined configuration files at ...