WWu777 wrote: ↑
Thu Dec 14, 2017 2:38 am
Because I'm on VPS and only have 30 GB hosting space. Not enough for backups.
Your database is 2.5 GB and you only have 30 GB hosting space. Correct me if I am wrong but that leaves 27.5 GB available for other things. Seems to me that there's room for a copy of the whole forum.
Also, a webhosting account isn't the only place one can keep backups.
Extensions here don't usually crash databases. They are safe and tested and approved.
Extensions are modifications and are tested as such. It's hard to guarantee that certain combinations of extensions won't cause conflicts somewhere, no matter how thoroughly they've been tested. And it's not exactly easy to test extensions in crash situations either.
The principle is: the more changes/additions are made, the higher the risk of something going wrong, which is not saying that extensions are the cause.
No my host doesn't do automatic backups unless I'm on shared hosting.
Well, there's also another principle which comes in handy sometimes: DIY
How do you do incremental backups?
Only backup the differences between the current state and the state of the previous backup. BTW the previous backup could thus also be an incremental backup. I'ld suggest going for differential backups so that your last backup contains the differences with your latest full
How? Look it up and try it, test and learn.
What if I do a backup now and then try to download the corrupted database and repair it offline?
Actually (the dead horse is being flogged to gibberish now). If the database cannot be repaired online, what would you download to repair? With some luck it's only one table which is corrupt (you didn't even mention which table) but that one table may be linked to others.
Either this can be solved by the database software, or by the host, or by uploading a working backup (perhaps there are other possibilities but I can't think of any now). According to you, the database software can't do the repairs, and your host can't either. That leaves the third option and sooner or later you will have to decide which way to go