如何将我的Heroku + MediaWiki数据库从clearDB更改为本地数据库

Question

I build a wiki using MediaWiki. Initially, I used a remote database (clearDB), as setup was faster. I now want to migrate the data, and use a db local to the server instead.

My current db settings in Localsettings.php

## Database settings
$wgDBtype = "mysql";
$wgDBserver = "us-XXXX-XXXX-XXX-XX.cleardb.net";
$wgDBname = "heroku_XXXXXXXXX";
$wgDBuser = "XXXXXXXXX";
$wgDBpassword = "XXXXXXXXXX";

Obviously, if I just "changed" the $wgDBserver to localhost, it won't work.

What needs to be done to migrate the old data and default MediaWiki architecture to a new db local to the server?

Answer 1

You would need to use mysqldump on your old data store and save the pure SQL locally.

mysqldump -u <user> -p -h us-XXXX-XXXX-XXX-XX.cleardb.net heroku_XXXXXXXX > /tmp/wikidump.sql

Then on your local server, recreate the heroku_XXXXXXXXX DB t

CREATE DATABASE heroku_XXXXXXXX (exact same name);
use heroku_XXXXXXX;
source /tmp/wikidump.sql

This will do the trick.

I sometimes look inside the dump (/tmp/wikidump.sql) with a text editor to make sure no references to cleardb.net exists an change them. That's just me! Otherwise follow:

Change external links