[Cialug] Mediawiki Migration

[Todd Walton]

Question: If I'm leaving one Mediawiki installation and setting up
another (this is not an in-place upgrade) how do I keep my pages?

Answer:

on the old install:
     mysqldump -u root -p wikidb > wikidb.sql

on the new install:
     mysql -u username -p
     create database wikidb;
     grant create, select, insert, update, delete, lock tables on wikidb
     mysql -u username -h sqldb-hostname -p wikidb < wikidb.sql

--------

Question: Does anyone know how to restore a MySQL database that was
created on a web hosting provider and deleted about a year ago with no
backups made of it?

-todd