Flush tables for export not executing

[jason millington]

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 192.168.0.203 < 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.

thanks
for all help