By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,374 Members | 1,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,374 IT Pros & Developers. It's quick & easy.

mySQL Remote Backups - No Access to FTP or Remote Command Line

P: n/a
I have a mySQL database located on a remote host's server. I would
like to schedule a task on my local Windows computer to retrieve a
backup/dump of this remote database.

I have contacted my host, and they indicated that the server is only
open to the Internet via mySQL. Therefore, even if I did have access
to that server's command line (which I don't) to create dumps via
mysqldump, I would not be able to retrieve via FTP.

Does anybody have any ideas as to how I can generate backup files from
my local computer through a local command-line interface? I have done
it through a GUI (DBTools), but I would like to have it done via DOS
batch, so that I can schedule it. Does anyone know of any mysql backup
GUIs with command line switches? Or can somebody recommend an
alternate means of getting a local backup?

Would appreciate any help. Thanks.
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Thanks very much. That's exactly what I needed.
Jul 20 '05 #2

P: n/a
JStrummer wrote:
Does anybody have any ideas as to how I can generate backup files from
my local computer through a local command-line interface?


Have you looked at the documentation for mysqldump?
It permits you to specify a remote host with -h 'hostname'.

Admittedly, the docs on mysql.com don't make this feature totally clear.

Then the user & password you specify with it is the MySQL user &
password (not the operating system login) you use to log in to the
database on that remote host.

Regards,
Bill K.
Jul 20 '05 #3

P: n/a
Thanks very much. That's exactly what I needed.
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.