Backup Remote MySQL Database

[michaelslamet]

I have MySQL databases that hosted in a hosting server.

Is it possible building a command line backup utility using AutoIT so I can schedule it to run every day from my PC ?

I have no physical access and have no shell access/account on the server

Thank you

[michaelslamet]

Maybe we can use mysqldump?

Anybody here ever use mysqldump to backup remote MySQL databases?

[Artisan]

It's interesting that you "have" databases, but don't have access to them. How is that possible?

I've never used mysqldump.  Can you access the database files directly from a web browser?

[michaelslamet]

@Artisan: I mean i dont have a physical access to the server, I only have a access through cpanel.

I cant access the database files directly from a web server, but I can access it using MySQL function/statement.

Thanks

[michaelslamet]

Answering my own post, this is not connected with AutoIT, but hopefully this post can help somebody somewhere who landed on this page:

mysqldump.exe that come with MySQL server has a ability to backup from a remote server:

c:>mysqldump -u MyUserName -pMyPassword -h my-server.com --all-databases > c:backupalldbs_of_myserver_dot_com.sql

Note that between "-u" and MyUserName has a space, but between "-p" and "MyPassword" has no space.