Search Results
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
For SQL output (CREATE and INSERT statements), local or remote dumps can be done and generate output on the client. This section describes the characteristics of different types of backups. Physical (Raw) Versus Logical Backups Physical backups ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
You can generate new queries from existing ones that are similar by copying and editing script files. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
mysqld appends a numeric extension to the binary log base name to generate binary log file names. The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains ...
https://dev.mysql.com/doc/refman/8.4/en/binlog.html
It is generated by the mysqlbinlog program as the printable representation of certain events in binary log files. (See Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”.) The 'str' value is a base 64-encoded string the ...
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
For a nonexistent table, CHECKSUM TABLE returns NULL and generates a warning. [QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before and after a ...
https://dev.mysql.com/doc/refman/8.4/en/comp-err.html
comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. It compiles the errmsg.sys file from text-format error information in MySQL source distributions: The error ...
https://dev.mysql.com/doc/refman/8.4/en/compilation-problems.html
Normally, the build process does not need to create sql_yacc.cc because MySQL comes with a pregenerated copy. If you do reconfigure, take note of the following: If CMake is run after it has previously been run, it may use information that was ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
The mysql command, ssl_session_data_print, generates the session data file (see Section 6.5.1.2, “mysql Client Commands”). This section describes options supported by most MySQL client programs that control how client programs establish ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
Note An easier alternative to generating the files required for SSL than the procedure described here is to let the server autogenerate them; see Section 8.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. This section describes ...