MySQL Backup

[coolsurdy]

Hey,

Alright here's the deal. I currently use CubedHost as my minecraft hoster (it's affordable for me and no, I don't want to rent a dedi/vps and go through the hassle of installing multicraft there, so plz dont ask). Towny makes daily backups and CubedHost makes entire server backups once a day at midnight.

They have a MySQL server that we can use, and I'm using it for some of my plugins. However I would like to start using Towny on MySQL, but the problem is neither Towny nor CubedHost make backups for MySQL.

So, I'm asking any SysAdmins out there and/or experienced people how I can get a daily backup solution for MySQL going? What are all my options?

 

[Faxed]

Given that you don't have access to the machine, you can't set up a daily backup through using crontab. The only way that you would currently be able to do a backup is by manually exporting the data in an SQL format - Which you'd do via the PHPMyAdmin panel (Which CubedHost do give access to, if memory serves). One would need to simply click the table wanted, and then it's a case of clicking export at the top.

However, upon reading their terms they don't specifically state that they don't backup MySQL data. Have you tried sending them a ticket, asking about it?

 

[coolsurdy]

Yes I have, the COO responded and told me that they do not backup MySQL but he told me I can setup a cron mysql backup by getting a small droplet from DigitalOcean but im too lazy to do all that.

 

[Wvisoecj]

What kind of access are you granted? Do they just give you a panel? Do you have access to PHPMyAdmin?

 

[lAkjtzAZ0]

but im too lazy to do all that.

well...

 

[Wvisoecj]

Wait if you have external access to the database just make a crontab on your local machine?

 

[coolsurdy]

What kind of access are you granted? Do they just give you a panel? Do you have access to PHPMyAdmin?

A phpMyAdmin panel that looks like this:

https://gyazo.com/46d5840600ef882e803934dc2c75dccf[DOUBLEPOST=1471676435][/DOUBLEPOST]

well...

That's why I'm willing to pay for someone to set it up for me.

 

[Wvisoecj]

A phpMyAdmin panel that looks like this:

https://gyazo.com/46d5840600ef882e803934dc2c75dccf[DOUBLEPOST=1471676435][/DOUBLEPOST]
That's why I'm willing to pay for someone to set it up for me.

If you're lazy you can manually take SQL dumps via PHPMyAdmin.

 

[coolsurdy]

If you're lazy you can manually take SQL dumps via PHPMyAdmin.

That's not what I want, I want a way to schedule it daily automatically

 

[Wvisoecj]

That's not what I want, I want a way to schedule it daily automatically

But you said you're too lazy to set it all up? Are you fine with running crontabs on your local machine?