Hi, what is a good method to backup the whole system (DB, Images, Configs, DB-Users, Wiki-Users...)? dumpBackup.php does only an export of the wiki-content. What other data is needed to backup the system and how can this be done? Regards Stefan
On 19/04/06, MediaWiki-l.20.stefan817@spamgourmet.com MediaWiki-l.20.stefan817@spamgourmet.com wrote:
Hi, what is a good method to backup the whole system (DB, Images, Configs, DB-Users, Wiki-Users...)?
1. Backup the database; use something like mysqldump for this 2. Backup the entire wiki directory
Rob Church
The simplest backup process is to dump the whole database to SQL by using this command-line script:
"Path to mysqldump.exe" -u"db username" -p"db user password" "database name"
"Path to Name of filedump.sql"
To import the same file back again use this command-line script:
"Path to mysqldump.exe" -u"db username" -p"db user password" "database name" < "path to name of dumped file"
Just drop the quotation marks but keep the < & >.
It can take some time depending on your db size but it dumps everything. Remember this is just your data all config files should be backed up as per normal system file backups.
Good Luck Trevor
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of MediaWiki-l.20.stefan817@spamgourmet.com Sent: 19 April 2006 10:27 AM To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] Method for Backup whole system
Hi, what is a good method to backup the whole system (DB, Images, Configs, DB-Users, Wiki-Users...)? dumpBackup.php does only an export of the wiki-content. What other data is needed to backup the system and how can this be done? Regards Stefan
i don't think it will backup the image files and LocalSettings.php
On 4/19/06, Trevor Richardson mibrad@iafrica.com wrote:
The simplest backup process is to dump the whole database to SQL by using this command-line script:
"Path to mysqldump.exe" -u"db username" -p"db user password" "database name"
"Path to Name of filedump.sql"
To import the same file back again use this command-line script:
"Path to mysqldump.exe" -u"db username" -p"db user password" "database name" < "path to name of dumped file"
Just drop the quotation marks but keep the < & >.
It can take some time depending on your db size but it dumps everything. Remember this is just your data all config files should be backed up as per normal system file backups.
Good Luck Trevor
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of MediaWiki-l.20.stefan817@spamgourmet.com Sent: 19 April 2006 10:27 AM To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] Method for Backup whole system
Hi, what is a good method to backup the whole system (DB, Images, Configs, DB-Users, Wiki-Users...)? dumpBackup.php does only an export of the wiki-content. What other data is needed to backup the system and how can this be done? Regards Stefan
-- Analog-/ISDN-Nutzer sparen mit GMX SmartSurfer bis zu 70%! Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
-- Vedant Lath
Trevor Richardson wrote (...) I started like you then adapted :-)
so, first on the source computer
mysqldump -p wikidb > wikidb.sql
for me I nedded to do this as root. then option -p made mysqladmin to call for the passwd (root mysql pass) (linux, no "exe")
tar cvfz med_158.tgz mediawiki/
to have all the old files.
then on the target computer:
mysql -p and mysql opens it's console use wikidb source wikidb.sql
but one must start from a clean mysql (no wikidb before, or delete it)
tar xfvz med_158.tgz
test: it should work. same mediawiki site but on the new computer.
then overwrite the folder with the new 1.6.3 files, in the mediawiki root folder cp AdminSettings.exampl to AdminSettings.php and in it replace wikiuser by root and set it passwd
run maintenance/update.php
and enjoy the new mediawiki 1.6.3
in fact I missed at first the Admi.. stuff
thanks all
jdd
Moin,
On Monday 24 April 2006 12:20, jdd wrote:
Trevor Richardson wrote (...) I started like you then adapted :-)
so, first on the source computer
[snip]
Can you please write this up as some FAQ or article, on META or anywhere else it can be found easily?
Thanx for figuring it out,
Tels
My parser is doing major weirdness; I don't know why. This is sort of urgent, as it's running on a production site.
The wikitext I export: '''[[DND:Home|D&D]]''' • '''[[DDO:Home|DDO]]''' • '''[[LotRO:Home| LotRO]]''' • '''[[AA:Home|AA]]''' • '''[[DFO:Home|DFO]]''' • '''[[RFO:Home|RFO]]''' • '''[[Halo:Home|Halo]]''' • '''[[TR:Home| TR]]''' • '''[[AoC:Home|AoC]]''' • '''[[TES:Home|TES]]''' • '''[[SCI:Home|SCI]]''' • '''[[HP:Home|HP]]''' • ''[[SC:Home|SC]]'' • ''[[Diablo:Home|D3]]'' • ''[[WAR:Home|WAR]]'' • ''[[CO:Home|C:O]]''
All of those are set up as interwiki prefixes. This is the HTML I get out:
<p><b><a href="http://en.dndwiki.ws/index.php?title=Home" class='extiw' title="dnd:Home">D&D</a></b> • <b><a href="http:// en.ddowiki.ws/index.php?title=Home" class='extiw' title="ddo:Home">DDO</a></b> • <b><a href="http://en.lotrowiki.ws/ index.php?title=Home" class='extiw' title="lotro:Home">LotRO</a></b> • • <b><a href="http://en.dfowiki.ws/index.php?title=Home" class='extiw' title="dfo:Home">DFO</a></b> • <b><a href="http:// en.rfowiki.ws/index.php?title=Home" class='extiw' title="rfo:Home">RFO</a></b> • <b><a href="http://en.halowiki.ws/ index.php?title=Home" class='extiw' title="halo:Home">Halo</a></b> • • <b><a href="http://en.aocwiki.ws/index.php?title=Home" class='extiw' title="aoc:Home">AoC</a></b> • <b><a href="http:// en.teswiki.ws/index.php?title=Home" class='extiw' title="tes:Home">TES</a></b> • <b><a href="http://en.sciwiki.ws/ index.php?title=Home" class='extiw' title="sci:Home">SCI</a></b> • <b><a href="/index.php?title=HP:Home&action=edit" class="new" title="HP:Home">HP</a></b> • <i><a href="/index.php? title=SC:Home&action=edit" class="new" title="SC:Home">SC</a></i> • <i><a href="/index.php?title=Diablo:Home&action=edit" class="new" title="Diablo:Home">D3</a></i> • <i><a href="/index.php? title=WAR:Home&action=edit" class="new" title="WAR:Home">WAR</a></ i> • <i><a href="/index.php?title=CO:Home&action=edit" class="new" title="CO:Home">C:O</a></i>
Look between halo and AoC - the link is totally missing! I can't seem to puzzle this out...
Elliott F. Cable wrote:
My parser is doing major weirdness; I don't know why. This is sort of urgent, as it's running on a production site.
[snip]
'''[[TR:Home|TR]]'''
This is an interlanguage link to a page in Turkish.
-- brion vibber (brion @ pobox.com)
I don't have a turkish interwiki link... On Apr 24, 2006, at 5:43 PM, Brion Vibber wrote:
Elliott F. Cable wrote:
My parser is doing major weirdness; I don't know why. This is sort of urgent, as it's running on a production site.
[snip]
'''[[TR:Home|TR]]'''
This is an interlanguage link to a page in Turkish.
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Elliott F. Cable wrote:
I don't have a turkish interwiki link...
Yes you do. That's why it appears in "Other languages" on your sidebar. (Look for it, you'll see it.)
-- brion vibber (brion @ pobox.com)
Tels wrote:
Moin,
On Monday 24 April 2006 12:20, jdd wrote:
Trevor Richardson wrote (...) I started like you then adapted :-)
so, first on the source computer
[snip]
Can you please write this up as some FAQ or article, on META or anywhere else it can be found easily?
Thanx for figuring it out,
sure, when all is ended :-) jdd
On 26/04/06, jdd jdd@dodin.org wrote: http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.6#Upgrading_Mediawiki_an...
Thanks for clogging up the documentation. I'm going to move this to another page.
Rob Church
Rob Church wrote:
On 26/04/06, jdd jdd@dodin.org wrote: http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.6#Upgrading_Mediawiki_an...
Thanks for clogging up the documentation. I'm going to move this to another page.
if you want. It's not really different from what is on the other sections of the page, just seen from a different point of view :-)
jdd
On 26/04/06, jdd jdd@dodin.org wrote:
Rob Church wrote:
On 26/04/06, jdd jdd@dodin.org wrote: http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.6#Upgrading_Mediawiki_an...
Thanks for clogging up the documentation. I'm going to move this to another page.
if you want. It's not really different from what is on the other sections of the page, just seen from a different point of view :-)
No, it's quite different, in fact. Most users who upgrade MediaWiki shouldn't need to upgrade MySQL, and the advice (not instructions) on doing that should be kept on a different page. The principle of good documentation is to keep pages clean and relevant.
Rob Church
Rob Church wrote:
On 26/04/06, jdd jdd@dodin.org wrote:
Rob Church wrote:
On 26/04/06, jdd jdd@dodin.org wrote: http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.6#Upgrading_Mediawiki_an...
Thanks for clogging up the documentation. I'm going to move this to another page.
if you want. It's not really different from what is on the other sections of the page, just seen from a different point of view :-)
No, it's quite different, in fact. Most users who upgrade MediaWiki shouldn't need to upgrade MySQL, and the advice (not instructions) on doing that should be kept on a different page. The principle of good documentation is to keep pages clean and relevant.
as I said it's like you want.
I fact I didn't want to move mysql, but had to do so to use mediawiki 1.6.3 and, for sure, I like your work and want to keep in touch with it :-)
jdd
Moin,
On Wednesday 26 April 2006 09:52, Rob Church wrote:
On 26/04/06, jdd jdd@dodin.org wrote: http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.6#Upgrading_Mediawi ki_and_Mysql_in_the_same_time
Thanks for clogging up the documentation. I'm going to move this to another page.
Rob, please don't be so harsh and rude!
jdd, thanx for writing it up! Even if it might be moved, it is still better to have the documentation than to not have it. Now someone needs to clean up the How_do_I_write_an_(extension/Specialpage)" docs :-D
Best wishes,
Tels
Tels wrote:
Moin,
On Wednesday 26 April 2006 09:52, Rob Church wrote:
On 26/04/06, jdd jdd@dodin.org wrote: http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.6#Upgrading_Mediawi ki_and_Mysql_in_the_same_time
Thanks for clogging up the documentation. I'm going to move this to another page.
Rob, please don't be so harsh and rude!
don't worry. I know what writing a nice doc is hard. I work hard now on cleaning the french fr.opensuse.org wiki and so have little time to add to mediawiki (however I did in the past and will do in the future)
jdd
On 26/04/06, Tels nospam-abuse@bloodgate.com wrote:
Rob, please don't be so harsh and rude!
I'm terribly sorry.
jdd, thanx for writing it up! Even if it might be moved, it is still better to have the documentation than to not have it. Now someone needs to clean up the How_do_I_write_an_(extension/Specialpage)" docs :-D
Yes, thanks for the skeleton documentation. Most of the stuff on Meta ought to be moved (read: rewritten) to MediaWiki.org.
Rob Church
Moin,
On Wednesday 26 April 2006 21:17, Rob Church wrote:
On 26/04/06, Tels nospam-abuse@bloodgate.com wrote:
Rob, please don't be so harsh and rude!
I'm terribly sorry.
Don't worry :)
jdd, thanx for writing it up! Even if it might be moved, it is still better to have the documentation than to not have it. Now someone needs to clean up the How_do_I_write_an_(extension/Specialpage)" docs :-D
Yes, thanks for the skeleton documentation. Most of the stuff on Meta ought to be moved (read: rewritten) to MediaWiki.org.
I plan to do that for the "how to write a special page" doc, because it is confusing, partly wrong and half empty.
But first I need to actually finish my special page to be able to document the process.
best wishes,
tels
mediawiki-l@lists.wikimedia.org