Syntax\n------\n\nFLUSH TABLE[S] table_name [, table_name] FOR EXPORT\n\nDescription\n-----------\n\nFLUSH 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, Aria, CSV, InnoDB, MyISAM and MERGE tables.\n\nThe table is read locked until you issue UNLOCK TABLES.\n\nIf a storage engine does not support FLUSH TABLES FOR EXPORT, a 1031 error (SQLSTATE 'HY000') is produced.\n\nIf FLUSH TABLES ... FOR EXPORT is in effect in the session, the following statements will produce an error if attempted:\n\n FLUSH TABLES WITH READ LOCK\n FLUSH TABLES ... WITH READ LOCK\n FLUSH TABLES ... FOR EXPORT\n Any statement trying to update any table\n\nIf any of the following statements is in effect in the session, attempting FLUSH TABLES ... FOR EXPORT will produce an error.\n\n FLUSH TABLES ... WITH READ LOCK\n FLUSH TABLES ... FOR EXPORT\n LOCK TABLES ... READ\n LOCK TABLES ... WRITE\n\nFLUSH FOR EXPORT is not written to the binary log.\n\nThis statement requires the RELOAD and the LOCK TABLES privileges.\n\nIf one of the specified tables cannot be locked, none of the tables will be locked.\n\nIf a table does not exist, an error like the following will be produced:\n\n``\nERROR 1146 (42S02): Table 'test.xxx' doesn't exist\n`\n\nIf a table is a view, an error like the following will be produced:\n\n`\nERROR 1347 (HY000): 'test.v' is not BASE TABLE\n``\n\nExamples\n--------\n\nFLUSH TABLES test.t1 FOR EXPORT;\nCopy files related to the table (see below)\nUNLOCK TABLES;\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/flush-commands/flush-tables-for-export