Import mySQL sql dump to database
Posted: 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.
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.