I need some help setting up a script to automatically backup of my mysql server. I also need that backup to somehow get to my full machine so I can store it with out using the limited VDS space. I was thinking of using dropbox somehow, but I don't know if it works on Ubuntu. The VDS is running Ubuntu and the full machine is on Windows 2008. I know how to work scripts on windows and know how to make a bat file to move what I want to where I want, but Ubuntu is foreign to me. The person that set up the mysql for us is, unfortunately, off in college right now and can't help us.
If anyone can help me, I would need a literal step by step on what to do. I know how to connect to the server with putty, but that is the limit of what I know how to do.
Automatic backup of mysql on ubuntu VDS
-
jpwanabe
- A semi-regular
- Posts: 17
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Wed May 22, 2013 1:06 pm
Re: Automatic backup of mysql on ubuntu VDS
The easiest way for you would be to make a batch script using mysqldump to get the databases from your ubuntu server.
mysqldump comes with mysql server for windows. You don't actually need to use the mysql server, you just need the mysqldump program.
Here is a guide on how to use mysqldump remotely: http://blog.winhost.com/using-mysqldump ... asetables/
mysqldump comes with mysql server for windows. You don't actually need to use the mysql server, you just need the mysqldump program.
Here is a guide on how to use mysqldump remotely: http://blog.winhost.com/using-mysqldump ... asetables/
Not a NFO employee
Re: Automatic backup of mysql on ubuntu VDS
Can I kiss you?soja wrote:The easiest way for you would be to make a batch script using mysqldump to get the databases from your ubuntu server.
mysqldump comes with mysql server for windows. You don't actually need to use the mysql server, you just need the mysqldump program.
Here is a guide on how to use mysqldump remotely: http://blog.winhost.com/using-mysqldump ... asetables/