Willem-Jan van Strien wrote :
I've been browsing the MW website for a while
looking for two pieces of
information. But I can't seem to find them.
http://lists.wikimedia.org/pipermail/mediawiki-l/2007-May/020358.html
First of all, would there be any way to backup the
database to a .--- file?
in a shell, type this :
mysqldump -u root -p --default-character-set=latin1 -d wikidb >
'/the/path/you/want/backup.sql'
it will ask for your *mysql* root password (not the wiki sysop passwd)
I'm not sure you need to do it as root, you might give it a try simply with the mysql
user you defined during install (default : wikiuser) --> it would be mysqldump -u
wikiuser -p etc...
I *believe* it to be possible with phpmyadmin, but I'm *sure* that its *default*
export options corrupt the database (e.g. it will mess with é è, ç, ù, ü,... chars)
And would there be any way to import a similar .---
file into a fresh
database?
mysql -u root -p wikidb < '/the/path/you/want/backup.sql'
again, it will ask for your mysql root password
Also, would it be possible to copy a wiki to a home
computer so you
could work on it offline?
yes, simply you need a LAMP or WAMP (Linux/windows + apache-mysql-php) install, then
import the backup using command above, then install mediawiki as usual (on your localhost
of course).
If you give it the correct info during install, it will detect the already existing
database and use it instead of creating a new one ;-)