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).