Page 1 of 1

Import mySQL sql dump to database

Posted: Wed Nov 03, 2010 10:25 am
by withersd
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.

Re: Import mySQL sql dump to database

Posted: Wed Nov 03, 2010 2:08 pm
by Support_Mary
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.

Re: Import mySQL sql dump to database

Posted: Wed Nov 03, 2010 2:39 pm
by withersd
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.