MySQL Forums
Forum List  »  MySQL Workbench

Re: Using Mysql Workbench commandline to Load data
Posted by: Mike Lischke
Date: June 09, 2016 01:47AM

Vinay, the MySQL command line client allows to run LOAD DATA with csv data and is easy to schedule with the Windows task scheduler. MySQL Workbench would launch a GUI just for this which is probably not what you want, especially if you run this task unattended.

And WB cannot load a csv file from a command line parameter, only SQL or model files (and python scripts). Better go with the MySQL command line client for this special task.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/



Edited 1 time(s). Last edit at 06/09/2016 01:48AM by Mike Lischke.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Using Mysql Workbench commandline to Load data
608
June 09, 2016 01:47AM


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.