Migrate wiki to bay

From PTAGISWiki

One of the services still running on sebastes is the wiki.

Todd has set up php on bay. That's the hard part.

Now there are three steps to moving everything:

• Configure apache
• Sync the filesystems
• Sync the databases

The apache config on bay looks like this for testing:

<VirtualHost *>
    ServerName php.ptagis.org
    ServerAlias testphp.ptagis.org
    ServerAdmin webmaster@psmfc.org
    DocumentRoot "/usr/local/pitweb/ptagis/wiki"
    <Directory "/usr/local/pitweb/ptagis/wiki">
        AllowOverride All
        Options Indexes Includes FollowSymLinks
        Order allow,deny
        Allow from all
    </Directory>
</VirtualHost>

The filesystem can be copied with a handy rdist. The rdist takes a minimum of about 10 minutes.

The following is the config file on reedi that can be used to push the wiki files to bay:

HOSTS = ( bay )

DATAFILES = (
/global/ds1/misc/www-php.ptagis/htdocs/mediawiki-1.5.6-restricted
)

(${DATAFILES}) -> (${HOSTS})
install -R /usr/local/pitweb/ptagis/wiki/mediawiki-1.5.6-restricted;
except_pat AdminSettings.php;
except_pat LocalSettings.php;

LocalSettings.php and AdminSettings.php will have to be localized to bay to set IP address, google site key, paths, passwords, etc and shouldn't be synchronized when copying the wiki data.

The database can be exported from sebastes via phpMyAdmin. Export the db through http://www.psmfc.org/phpMyAdmin/

• Choose ptagiswiki
• export
• select all tables
• add drop table
• save as file

Copy the approximately 25MB (230MB uncompressed) file to bay. Unzip it. login to mysql like this:

mysql ptagiswiki

Then import the database file like this:

source /home/rday/ptagiswiki.sql

The import takes about 5 minutes.

Now the DB should be in sync as long as no changes were made on reedi in the time it took to do the export.