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

If your page is in Google, you can use the texts from the Google cache and paste them back into your database. This should at least bring "some" pages back.

If all that does not help, there still is another way to get your information back - a hard way:

All your texts are still there, see the table "text". The page names also are still there, see the table "page". What you lost is the relation of the entries in "text" to the pages in "page". Both were connected in this way:

"The text of the page itself is stored in the text table. To retrieve the text of an article, MediaWiki first searches the page table for page_title. Then, page_latest is used to search the revision table for rev_id, and rev_text_id is obtained in the process. The value obtained for rev_text_id is used to search for old_id in the text table to retrieve the text."

So as a last help you can check the texts from the table "text" and try to manually put them into the right pages again. To do that, it might be wise to use a new database, so that you do not build upon the missing relations in the old DB. However, this task will be cumbersome, take a long time and won't be fun at all. Estimate yourself, if your data is worth the hassle!

Whatever you do: You should really start using backups! Automatically generated backups; what has to be done manually will be forgotten.