[Cialug] Mediawiki Migration

[David Champion]

Jeffrey Ollie wrote:
> On Wed, Jan 14, 2009 at 4:09 PM, Todd Walton <tdwalton at gmail.com> wrote:
>   
>> 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
>>     
>
> That should do it... I've done this myself just recently.
>
>   
>> 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?
>>     
>
> Borrow Bill & Ted's phone booth, go back in time, and make a backup of it?
>
>   
I wouldn't use the Donny Darko method of time travel, unless you're 
impervious to falling jet engines. Besides, Patrick Swayze is having a 
hard enough time as it is these days without having people burn his 
house down.

-dc