mysql - Full backup of GoDaddy site via command-line script -

is there simple way automated backup of entire website on host godaddy via command-line?

so far, know need backup files in home directory recursively. possibly automated sftp connect , issue get -r * command full file dump, or use scp.

the other half of puzzle getting of tables available, wordpress tables. guess maybe there's command-line command issue dumps database contents flat file, pull via sftp. if such command exists, plan use combination of telnet , expect scripts login godaddy site, issue commands, disconnect local shell.

the end result should have folder of server content in it, plus flat file backup of sql database server. know there wordpress backup plugins, tend provide slew of zip files, when want raw data directly can put in private svn server backup , versioning.

so question: how extract of databases on godaddy server via command-line file?

thank you.

in end, found working solution.

first, used 2 separate expect scripts.

1. telnet server, delete old backups, use mysqldump extract tables flat file via mysqldump -u db_owner -p --all-databases > output.sql, , create massive tarball of everything. logout.
2. use scp pull newly created tarball, extract local svn controlled working copy folder.
3. use second expect script login server , delete backup. logout.

from there, manually svn add , svn commit needed.