I accidently lost a whole tables data today. Lucky me I also created a XML-file on the server which was for printing.
I parsed the files back into a simplexmlobject and recovered most of the lost data. 💪

Backups my friend, always backup

I once did the same on Azure, luckily we have point in time restore, just rolled back to a minute before the accident .-.

@gitpush I definitely will implement next a cronjob to backup the databases....

@Divisionbyzero hope it is not a huge db, or that crone will cripple the server until it is done

@gitpush it is actually pretty small, I think. Are there better methods for that? 🤔

@Divisionbyzero well depends on the purpose of the server. if it has some cool off time like midnight where no one is using it, then a crone would be fine.

Though @Linux will be more of a help when it comes to these things. For me I'd just run a backup at night or follow this: https://dev.mysql.com/doc/refman/...

in-case of a cluster

@gitpush
The solution you use is fine for this purpose :)

Thank you very much!

@Linux What about his method for his scenario? I'm just curios O:)

@gitpush
What method? :P

@Linux lol crone job but I don't know the rest 😂
The thing is for backups a crone is better or scheduled maintenance and backing up is better?

@gitpush
Doing db backups by running a script in cron is Good :)

@Linux alright then, thanks man :D

I am deeply sorry that this has happened to you. However, I might have a solution to the problem that you have faced. If you used G Suite, then you will be able to quickly restore your data with the help of Google Apps backup from https://spinbackup.com/products/..., a service that bailed me a lot in the past.