FLUSH TABLES FOR EXPORT

Syntax

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 , , , , and tables.

The table is read locked until you issue .

If a storage engine does not support FLUSH TABLES FOR EXPORT, a 1031 error ( '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

FLUSH FOR EXPORT is not written to the .

This statement requires the and the privileges.

If one of the specified tables cannot be locked, none of the tables will be locked.

If a table does not exist, an error like the following will be produced:

If a table is a view, an error like the following will be produced:

Example

For a full description, please see .

See Also

• - Compressing the MyISAM data file for easier distribution.

_{This page is licensed: CC BY-SA / Gnu FDL}