Export db with fireFTP?

February 11, 2009 4:28 PM

Can I use the "custom command" function in FireFTP (in the Tools menu) to export a MySQL database from my host server?

i.e. with the command: mysqldump -u DBUSER -p DBNAME > DBNAME.sql

I need to export the database and I do not have SSH, control panel, or other access to the server (only FTP).

posted by scribbler to Computers & Internet (2 answers total)

Whether or not you can issue useful custom commands will depend on how the FTP server is configured.

It will probably be a lot easier if you just use a command line ftp client. You'll probably want to 'shell out' by prefixing your desired backup command with an exclamation point "!mysqldump ...."

If that doesn't work, then you probably can't do what you want.

Another option though, presumably you have some way of issuing ad hoc commands to the DB server? Can't you initiate the backup from within a mysql session and tell it to write out the backup to a directory you can get to via FTP (or HTTP)
posted by Good Brain at 4:48 PM on February 11, 2009

Unless FireFTP got SSH capabilities I didn't know about, you can't execute random shell commands to an FTP server.
posted by Civil_Disobedient at 5:24 PM on February 11, 2009