Sign in to follow this  
Followers 0
michaelslamet

Backup Remote MySQL Database

5 posts in this topic

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 :)

Share this post


Link to post
Share on other sites



Maybe we can use mysqldump?

Anybody here ever use mysqldump to backup remote MySQL databases?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

@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 :)

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0