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.

Import mySQL sql dump to database

Postby 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.
withersd
 
Posts: 2
Joined: Wed Nov 03, 2010 9:11 am

Re: Import mySQL sql dump to database

Postby 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 http://www.goanywheremft.com/forum To view the GoAnywhere web tutorials, click on http://www.goanywheremft.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.
Support_Mary
Support Specialist
 
Posts: 9
Joined: Tue Feb 09, 2010 11:16 am

Re: Import mySQL sql dump to database

Postby 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.
withersd
 
Posts: 2
Joined: Wed Nov 03, 2010 9:11 am


Return to Community Forum

Who is online

Users browsing this forum: Google [Bot] and 0 guests

cron