Manual:msg_resource table

↑ Manual:ContentsManual:Contents

MediaWiki database layoutManual:Database layout

msg_resource table

MediaWiki versions:

1.17 – 1.26

msg_resource was a table used to cache JSON message blobs for the resource loader. Its content can be deleted and excluded from backups as it will be regenerated when needed. See also Manual:Msg resource links tableManual:Msg resource links table.

Field

mr_resource

Resource name.

mr_lang

Language code.

mr_blob

JSON blob.

mr_timestamp

Timestamp of last update.

Schema summary

MediaWiki versions:

1.17 – 1.26

DESCRIBE msg_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    |       |
+--------------+----------------+------+-----+---------+-------+

DatabasesManual:Database layout

Engines: MySQL/MariaDBManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite – SQL ServerManual:Microsoft SQL Server Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associations – Field prefixesDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Wikimedia extension tablesCategory:Wikimedia extension database tables Configuration: SettingsManual:Configuration_settings#Database_settings – SharingManual:Shared database Development: AccessManual:Database access – OptimizationDatabase optimization – PolicyDevelopment policy#Database_patches – UpdaterManual:DatabaseUpdater.php – Extension schema updatesManual:Hooks/LoadExtensionSchemaUpdates – Patch fileManual:SQL patch file Core tables: archive – bot_passwords – category – categorylinks – change_tag – comment – config – externallinks – filearchive – hitcounter – image – imagelinks – image_comment_temp – interwiki – iwlinks – ipblocks – ip_changes – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – revision_comment_temp – searchindex – sites – site_identifiers - site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – tag_summary – valid_tag – watchlist