[Cialug] Mediawiki Migration

Todd Walton tdwalton at gmail.com
Wed Jan 14 16:09:56 CST 2009


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


More information about the Cialug mailing list