There is no other way. But if you formulate the query without specifying column names: > INSERT INTO fileDB.table SELECT * FROM memDB.table; Then the xfer-optimization will kick in and help it to run faster.
There is no other way. But if you formulate the query without specifying column names: > INSERT INTO fileDB.table SELECT * FROM memDB.table; Then the xfer-optimization will kick in and help it to run faster.