[BBLISA] How to retreive data from an old MySQL database

[Mark W. Manley]

What wiki software were you running?  If it's MediaWiki, you can 
retrieve text from the <your wikidb name>_text table.  For instance, I 
can retrieve the last incarnation from my wiki (acwiki) about PAM by doing:

 select old_text from acwiki_text where old_text like '%PAM%' and old_id 
= (select max(old_id) from acwiki_text where old_text like '%PAM%');

and I get a big dump of the wiki text that I just wrote today about our 
PAM module setup.

I personally like the SQL approach to wikis the way MediaWiki does it, 
but I am weird that way (and a part-time DBA/programmer, as well as 
sysadmin/floor wax/dessert topping).

-MM

On 10/26/2006 6:17 PM, Douglas Alan wrote:
> Hi.  I'd like to retrieve some wiki pages from an old MySQL database.
> Unfortunately, mysqldump doesn't work -- I'm guessing because the
> version of mysqld currently installed doesn't match the version of the
> database that was used for the wiki.
>
> I really don't want to head down the rat-hole of trying to downgrade the
> currently installed version of MySQL to some unknown old version in
> order to resurect the database just so that I can run mysqldump on it.
>
> With enough effort I can probably extract all the stuff I care about via
> "strings *" in the /var/lib/mysql directories, but it seems as if there
> must be a better way.
>
> Any ideas?
>
> Gee, I like flat text files better and better every day....  Moin Moin
> rules.
>
> |>oug
>
> _______________________________________________
> bblisa mailing list
> bblisa at bblisa.org
> http://www.bblisa.org/mailman/listinfo/bblisa
>