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
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.
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 Specialist
- Posts: 11
- Joined: Tue Feb 09, 2010 11:16 am
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.
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.
3 posts
Page 1 of 1