If the wikis have not just separate PHP, but have that because they are also different versions of the Mediawiki software, then simply copying the database and images director tree may not work.

Between major revisions at least, there should be expected to be changes to the DB. I have also run into grief when our hosting service discontinued support for older versions of PHP that were required for an older version of Mediawiki.

You would be advised to have both wikis at the same version of software. If you do this then the procedure Dave Humphrey outlines may be sufficient.

On 2/17/2016 4:00 AM, mediawiki-l-request@lists.wikimedia.org wrote:

Send MediaWiki-l mailing list submissions to mediawiki-l@lists.wikimedia.org

To subscribe or unsubscribe via the World Wide Web, visit https://lists.wikimedia.org/mailman/listinfo/mediawiki-l or, via email, send a message with subject or body 'help' to mediawiki-l-request@lists.wikimedia.org

You can reach the person managing the list at mediawiki-l-owner@lists.wikimedia.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of MediaWiki-l digest..."

Today's Topics:

1. A second, Duplicate Wiki (Ray Paseur)
2. Re: A second, Duplicate Wiki (Dave Humphrey)
3.  A second, Duplicate Wiki (Bartosz Dziewoński)

---

Message: 1 Date: Tue, 16 Feb 2016 18:05:45 +0000 From: Ray Paseur ray.paseur@armedia.com To: "mediawiki-l@lists.wikimedia.org" mediawiki-l@lists.wikimedia.org Subject: [MediaWiki-l] A second, Duplicate Wiki Message-ID: DM2PR0101MB1088F18E52E5DA9C650A146486AD0@DM2PR0101MB1088.prod.exchangelabs.com

Content-Type: text/plain; charset="iso-8859-1"

I don't write these requirements, I just try to comply.

We have two wiki installations named "spw" and "spw_public" that have slightly different PHP code sets. They live in different URLs. We want to make the display contents identical. The "spw" can be edited; the "spw_public" is read-only. These have separate underlying databases and images collections, etc.

The "spw" will always be the canonical source. The "spw_public" should look the same to site visitors, but it does not need to have any revision history.

What would be a good way to "sync" them? Is there a standard process for backing up and restoring a mediawiki installation, so that I could backup "spw" and restore it to "spw_public?"

Thanks and regards, Ray

---

Message: 2 Date: Tue, 16 Feb 2016 13:19:33 -0500 From: Dave Humphrey dave@uesp.net To: MediaWiki announcements and site admin list mediawiki-l@lists.wikimedia.org Subject: Re: [MediaWiki-l] A second, Duplicate Wiki Message-ID: CAD5rsfr=QDV75dmxAxTQt4z3DV5rPMe8cq8Oy8Tip3cRDWUFMg@mail.gmail.com Content-Type: text/plain; charset=UTF-8

Assuming you want to copy the database and images from "spw" to "spw_public" you could do:

• Backup Database: mysqldump --opt -u username -p spw > spw,sql
• Copy Database: mysql -u username -p spw_public < spw.sql

Note that these assume your database names are "spw" and "spw_public". The time this takes depends on the size of your database. For example, our 15GB MediaWiki database takes about 15min to backup and 1 hour to restore.

For copying images you can do: rsync -av /path/to/spw/images/ /path/to/spw_public/images/

If you want an exact copy you can add the "--delete" option to rsync to delete files in "spw_public/images" not found in "spw/images". If you don't have many images being uploaded this should be pretty quick as it only copies any new/updated image file.

On 16 February 2016 at 13:05, Ray Paseur ray.paseur@armedia.com wrote:

...

I don't write these requirements, I just try to comply.

We have two wiki installations named "spw" and "spw_public" that have slightly different PHP code sets. They live in different URLs. We want to make the display contents identical. The "spw" can be edited; the "spw_public" is read-only. These have separate underlying databases and images collections, etc.

The "spw" will always be the canonical source. The "spw_public" should look the same to site visitors, but it does not need to have any revision history.

What would be a good way to "sync" them? Is there a standard process for backing up and restoring a mediawiki installation, so that I could backup "spw" and restore it to "spw_public?"

Thanks and regards, Ray

---

MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l