[Mediawiki] instructions 2: transferring existing sites to the farm

[scott]

**** To transfer an existing mediawiki site onto the farm ****

#toc

*** set up admin user ***

each site should have an admin user. this person should

# be subscribed to mediawiki at lists.aktivix.org
# have ssh access with +rw attributes for site maintenance (not upgrades)

[ # adduser USER

*** initialise the site ***

you need to run the first setup script for this.

this will create the basic directories for the new mediawiki site install.
unfortunately, it's not very good (that's cos i'm no good at writing them) so if
anyone wants to improve it, feel free :-)

the variables need to be set within the actual script itself:

USER=user
WIKISITE=wiki.site.tld

[ # ./root/bin/wiki1

*** set up the apache config ***

alias the sitename to

*.wikifarm.aktivix.org



*** set up the database ***

existing database data will need to be imported, but the first thing is to
create the database. *you will need mysql root access* for this.

from orb.tachanka.org,

[ $ lynx site.wikifarm.aktivix.org

and then fill in the appropriate values (only admin users who know the correct
passwords and settings can do this)

*** finalise the site settings ***

you need to run the second setup script for this, after settign the appropriate
variables.

[ # ./root/bin/wiki2

*** import database data ***

first, connect to mysql as root and assign appropriate privileges to the new
database user:
[[
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX,
ALTER ON database.* to user at orb.tachanka.org IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
]]

then, from the dump directory, you can import data into the database:

[ $ cat databasedump.* | mysql -u USER -h HOST -p DATABASE

*** set up DNS ***

set the dns to be CNAMEd to orb.tachanka.org:

[ wiki.domain.tld    1900 IN CNAME orb.tachanka.org


you are now ready to go :-)