PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
MySQL Enterprise Backup can also create compressed backup files, and back up subsets of tables and databases. In conjunction with the MySQL binary log, users can perform point-in-time recovery. Logical Backups Using mysqldump In addition to physical ... The key to safe database management is making regular ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. The temporary files needed to sort the keys would be ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-visual-studio.html
A newer user interface for displaying query results, where different views are presented from result sets returned by a MySQL Server like: Multiple tabs for each result set returned by an executed query. Right-click your newly created connection, ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-backup.html
Along with --read-from-remote-server, it is common to specify other options: --host indicates where the server is running, and you may also need to specify connection options such as --user and --password. Use mysqlbinlog to make a continuous backup ... By default, mysqlbinlog reads binary log files and displays their contents in text ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
(It is necessary to use the mount option rather than setting innodb_flush_method if you want direct I/O for the log files.) Users of the Veritas file system VxFS should use the convosync=direct mount option. For more information, refer to the ... If ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). You can do this by creating ... You can add another replica to an existing replication configuration without stopping the source ...
https://dev.mysql.com/doc/refman/5.7/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. Configuration Options diagnostics() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, ...