Flush tables for export not executing
Posted by: jason millington
Date: November 22, 2016 05:38AM

Hi I am using the the Flush tables for export as part of migrating a db from one server to another. If I do all the steps manually through workbench everything works perfectly fine and I can move a 32Gb db in around 40min. Much faster that doing a restore!!

I am hoping to script up the whole procedure and run as a batch file in windows. All is going well but the script to fire the Flush tables command doesn't execute I can see the script login and display the command in the general log, it just doesn't execute. I can copy the contents of the script into workbench and it executes just fine. I have given root every perrmission possible via workbench.

here is how I call the script

mysql -u root -p -h < kissflushforexport.sql

and the contents

use kiss;
FLUSH TABLES additonal_carriage_charge_info_add_ire for EXPORT ;

their are many other tables and each is separated by a comma.

for all help

Options: ReplyQuote

Written By
Flush tables for export not executing
November 22, 2016 05:38AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.