PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
<field name="column_name">NULL</field> The output when --xml is used with mysql matches that of mysqldump --xml. See Section 6.5.4, “mysqldump — A Database Backup Program”, for details. mysql supports the following options, which can be ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
You can use such MySQL programs as mysqldump and MySQL Shell to perform logical backups, dump databases, and similar tasks instead. Prior to MySQL 8.0, the --routines and --events options for mysqldump and mysqlpump were not required to include ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html
For example, mysqladmin and mysqldump set program_name to mysqladmin and mysqldump, respectively. Connection attributes are key-value pairs that application programs can pass to the server at connect time. For applications based on the C API ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
In some cases, you may need to restart mysqld with --skip-grant-tables to run mysqldump. If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the problem.
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html
mysqldump A client that dumps a MySQL database into a file as SQL, text, or XML. mysqldumpslow A utility to read and summarize the contents of a slow query log. Later sections provide a more detailed description of each one, with the exception of ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
There are several variants of this method, the difference being in the manner in which data dumps and transactions from binary logs are transferred to the replica, as outlined here: Data Set Create a dump file using mysqldump on the source server.
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/server-logs.html
Log flushing occurs when you issue a FLUSH LOGS statement; execute mysqladmin with a flush-logs or refresh argument; or execute mysqldump with a --flush-logs option. See Section 15.7.8.3, “FLUSH Statement”, Section 6.5.2, “mysqladmin — A ...