Themsg_resource table was a table used to cache JSON messageblobs for the resource loader.Its content can be deleted and excluded from backups as it will be regenerated when needed.See alsoManual:Msg resource links table.

Resource name.

Language code.

JSON blob.

Timestamp of last update.

DESCRIBEmsg_resource;

+--------------+----------------+------+-----+---------+-------+| Field        | Type           | Null | Key | Default | Extra |+--------------+----------------+------+-----+---------+-------+| mr_resource  | varbinary(255) | NO   | PRI | NULL    |       || mr_lang      | varbinary(32)  | NO   | PRI | NULL    |       || mr_blob      | mediumblob     | NO   |     | NULL    |       || mr_timestamp | binary(14)     | NO   |     | NULL    |       |+--------------+----------------+------+-----+---------+-------+

SHOWINDEXINmsg_resource;

+--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| Table        | Non_unique | Key_name         | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |+--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| msg_resource |          0 | mr_resource_lang |            1 | mr_resource | A         |           0 |     NULL | NULL   |      | BTREE      |         |               || msg_resource |          0 | mr_resource_lang |            2 | mr_lang     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |+--------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

• MediaWiki database tables