FLUSH TABLES FOR EXPORT
MariaDB starting with 10.0.8
FLUSH TABLES ... FOR EXPORT was introduced in MariaDB 10.0.8
Syntax
FLUSH TABLES table_name [, table_name] FOR EXPORT
Description
FLUSH TABLES ... FOR EXPORT
flushes changes to the specified tables to disk so that binary copies can be made while the server is still running. This works for Archive, CSV, InnoDB, MyISAM, MERGE, and XtraDB tables.
If a storage engine does not support FLUSH TABLES FOR EXPORT
, a 1031 error (SQLSTATE 'HY000') is produced.
If FLUSH TABLES ... FOR EXPORT is in effect in the session, the following statements will produce an error if attempted:
- FLUSH TABLES WITH READ LOCK
- FLUSH TABLES ... WITH READ LOCK
- FLUSH TABLES ... FOR EXPORT
If any of the following statements is in effect in the session, attempting FLUSH TABLES ... FOR EXPORT
will produce an error.
- FLUSH TABLES ... WITH READ LOCK
- FLUSH TABLES ... FOR EXPORT
- LOCK TABLES ... READ
- LOCK TABLES ... WRITE
FLUSH FOR EXPORT
is not written to the binary log.
This statement requires the RELOAD and the LOCK TABLES privileges.