Huib Laurens wrote:
Okay,
The tables *text *page Contain all pages on the wiki (excluding categories, images ect ect).
But again, when you only back-up this two in case of a emergency it will be hard to get everything working again without errors.
Without the revision table you would have problems for restoring the articles. And archive table for deleted articles. And you presumably will also want the users (user table), and its preferences (user_properties)... Plus, a new mediawiki version might move things to a different table you aren't backing up.
You should instead backup everything, except perhaps a few selected tables (the ones with 'cache' in their name).