Mediawiki

mysql

back to database

getRemoteDb.sh

#!/bin/sh
echo "getting database $1"
read -p "Enter Your Password: "  pwd
echo "Welcome $pwd!"

mysqldump -h sitebuilt.net -uroot -p$pwd --opt $1 > $1.sql
mysql -uroot -p$pwd $1 < $1.sql

setup MYSQL

1. in phpmyadmin create the databases

2. put the databases in /var/backups/my. go there and run

  mysql -p -u root sitebuil_wikidb < sitebuil_wikidb.sql
  mysql -p -u root sitebuil_wrdp1 < sitebuil_wrdp1.sql
  mysql -p -u root sitebuil_wuffdb < sitebuil_wuffdb.sql
  mysql -p -u root taxplans < taxplans.sql
  mysql -p -u root webeshoppin < webeshoppin.sql
  mysql -p -u root pathbost_h211 < pathbost_h211.sql
  mysql -p -u root pathbost_h311 < pathbost_h311.sql
  mysql -p -u root pathbost_h409 < pathbost_h409.sql
  mysql -p -u root pathbost_h409 < pathbost_h409.sql

mobilefrontend

collapsable elements

mailto:mediawiki-l@lists.wikimedia.org

bot

mediawiki API

creating a bot

login bot (MrMcKenna bh)

append21.html (gets error badtoken)

Trying to send stuff to api.php to append to a page. Eventually I want to append to the main page of all users. First I'll us a POST form then I'll try multiple POSTS without a form using this snippet

http://www.linux.com/archive/feature/54334

bulk import to users

http://pathboston.com/forms/bulk.html then from terminal ssh'd to pathboston.com

cd public_html/hum310/maintenance/

php importUserSubpage.php --title test

will put a page with that title on each user page

Don't transclude especially not sources:biblio

mediawiki upgrade

• cp -r mediawiki-1.16.0/* /home/pathbost/public_html/hum08 - copy new vwrsion right over old
• from /maintainance run: php update.php

then get rid of all the revisions

• SpecialDeleteOldRevisions2 in code/mediawiki/extensions on mac, add this...

$wgGroupPermissions['sysop']['DeleteOldRevisions'] = true;

require_once( $IP.'/extensions/SpecialDeleteOldRevisions2/SpecialDeleteOldRevisions2.php');

old info

http://www.g-loaded.eu/2006/09/05/mediawiki-upgrade-procedure/ easy way:

• goto maintainance directory and run php dumpBackup.php --current> dumfile.xml
• on new site install wiki, put dumpfile.xml on its maintenance dir run php importDump.php dumfile.xml

mediawiki images

Does the user running the apache httpd instance ($ ps ax | grep httpd) have permission to write to images? Dan

mediawiki css

• sitewide changes go in Mediawiki:Monobook.css
• user changes go in User:MrMcKenna/monobook.css

compiling PH w /scripts/easyapache

!! You can change how PHP is configured. As root, simply execute:

   /usr/local/cpanel/bin/rebuild_phpconf --help

for more information.