Thread:Project:Support desk/Recreate the REVISIONS table/reply (3)

Let's try to recreate the whole table before we begin with fiddly manual work:

You can use a backup and restore the table from there. Maybe your host regularly does backups for you? Maybe you or a friend or another admin has an older backup somewhere? Or maybe you still have one somewhere on the server?

Another idea: MySQL has options to create logs of recent actions. I think the interesting log is called binary log. If it is activated, this log can be used to rollback actions, which MySQL did. The log content is rotated, meaning: If you ask quickly enough, your DROP query might still be in and so can be rolled back.

And doesn't MySQL maintain backups of the raw database data? I think that is in the data folder of MySQL, inside the subfolder backup/. I don't know how often these backups are refreshed, but I at least saw a system where that does not happen immediately, but exactly once a day. Having this data might help you as well.

Does anything of that help you?