MySQL Forums
Forum List  »  MySQL Workbench

moving mysql import or export outside of mysql workbench into standalone script
Posted by: Wes ..
Date: September 08, 2017 08:28AM

I see that workbench shows the command being run for imports and exports, and I'd like to run that command on another machine in a standalone script. Unfortunately, the script appears to reference a "defaults file" that is temporary and not accessible after the command runs... it seems that workbench is dynamically creating this extraparams.cnf file each time the command is run.. therefore it makes it difficult for me to reproduce this command elsewhere

13:45:52 Restoring /Users/wes/dumps/Dump20170907.sql
Running: /Applications/MySQLWorkbench.app/Contents/MacOS/mysql --defaults-file="/var/folders/x1/8vgyglcd0hv44_5fdlqj1zssm53dzs/T/tmpsmXKI3/extraparams.cnf" --protocol=tcp --host=server.edu --user=riuser --port=3306 --default-character-set=utf8 --comments --database=prd2 < "/Users/wes/dumps/Dump20170907.sql"
13:46:02 Import of /Users/wes/dumps/Dump20170907.sql has finished


Any suggestions?

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
moving mysql import or export outside of mysql workbench into standalone script
130
September 08, 2017 08:28AM


Sorry, only registered users may post in this forum.

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.