Import mySQL sql dump to database

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
3 posts Page 1 of 1

withersd

Posts: 2
Joined: Wed Nov 03, 2010 9:11 am

Post by withersd » Wed Nov 03, 2010 10:25 am
I am currently setting up a Project that FTP Gets a mysql backup/dump file. Filename.sql for example. I have all connections working for the FTP. I also have my database resource setup. I can query tables, view etc. My issue is I can’t figure out exactly how to setup a task for Goanywhere to take my .sql dump and import it into the database. Is it possible to achieve through the database actions available, or how to execute this command on the local DB itself from goanywhere.
Basically I am looking for the equivalent of the examples below that I would do on the database servers local command line:

cat filename.sql | mysql –uUsername –pPassword database_prod
or
mysql –uUsername –pPassword database_prod < filename.sql

Thank you for any assistance.

Support_Mary

Support Specialist
Posts: 11
Joined: Tue Feb 09, 2010 11:16 am

Post by Support_Mary » Wed Nov 03, 2010 2:08 pm
There are examples and tutorials as well as templates available to help you with this project.

There are answers to commonly asked questions as well as project examples on our GoAnywhere Community Forum at https://forum.goanywhere.com To view the GoAnywhere web tutorials, click on https://www.goanywhere.com/tutorials

To use templates when creating a new project click on double dots ".." to the right of the template parameter. This will list all the available templates.

withersd

Posts: 2
Joined: Wed Nov 03, 2010 9:11 am

Post by withersd » Wed Nov 03, 2010 2:39 pm
I have gone through the tutorials and through the examples and either I am missing something or I am not seeing anything that solves my importing mysql dump file into a database.
3 posts Page 1 of 1