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
[email protected]
http://www.bblisa.org/mailman/listinfo/bblisa
_______________________________________________
bblisa mailing list
[email protected]
http://www.bblisa.org/mailman/listinfo/bblisa
