Page MenuHomePhabricator

Migrate thegoodplace.wmflabs.org to MariaDB
Closed, ResolvedPublic2 Estimated Story Points

Description

Problem
Since The Good Place uses SQLite instead of MariaDB, sometimes database-specific issues can crop up that effect the environment, but wont exist on production.

Examples

Quesitons

  1. Is there a tool in MediaWiki (or elsewhere) to move data from one database to another?

Proposed Solution

  1. Use maintenance/dumpBackup.php to create a dump of all of the pages.
  2. Reinstall MediaWiki on a MariaDB database
  3. Use maintenance/importBackup.php to import all of the pages

Unfortunately MediaWiki's (built in) import/export does not import/export other data (like users or CheckUser data).

Event Timeline

ARamirez_WMF renamed this task from Migrate thegoodplace.wmflabs.org to MariaDB to Migrate thegoodplace.wmflabs.org to MariaDB [medium].Mar 12 2020, 6:43 PM
ARamirez_WMF set the point value for this task to 2.
dbarratt renamed this task from Migrate thegoodplace.wmflabs.org to MariaDB [medium] to Migrate thegoodplace.wmflabs.org to MariaDB.Mar 13 2020, 8:54 PM
dbarratt triaged this task as Medium priority.

Since we have the schema for both databases, it might be simple to export the data for each table rather than the whole schema.