When running a backup for my media wiki what files on the database should I be concerned about backing up the most? Wondering what tables/files matter the most incase I have to do an emergency backup.
Hello,
I would say that the *complete *back-up of the database is very important!
When talking about mediawiki files its more simple, the complete mediawiki version is always downloadable from www.mediawiki.org so the most files can you take from there but you should back-up the /images directory very good.
My main curiosity is where/what folder in the website directory or on the database are the pages for the wiki stored? Want to make sure I know where these are so I can easily back them up as needed so I don't lose information.
On Wed, Sep 8, 2010 at 12:34 PM, Huib Laurens sterkebak@gmail.com wrote:
Hello,
I would say that the *complete *back-up of the database is very important!
When talking about mediawiki files its more simple, the complete mediawiki version is always downloadable from www.mediawiki.org so the most files can you take from there but you should back-up the /images directory very good.
-- Regards, Huib "Abigor" Laurens
Support Free Knowledge: http://wikimediafoundation.org/wiki/Donate _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Okay,
The tables *text *page Contain all pages on the wiki (excluding categories, images ect ect).
But again, when you only back-up this two in case of a emergency it will be hard to get everything working again without errors.
Huib Laurens wrote:
Okay,
The tables *text *page Contain all pages on the wiki (excluding categories, images ect ect).
But again, when you only back-up this two in case of a emergency it will be hard to get everything working again without errors.
Without the revision table you would have problems for restoring the articles. And archive table for deleted articles. And you presumably will also want the users (user table), and its preferences (user_properties)... Plus, a new mediawiki version might move things to a different table you aren't backing up.
You should instead backup everything, except perhaps a few selected tables (the ones with 'cache' in their name).
On Wed, Sep 8, 2010 at 12:24 PM, Christopher Eicher predx97@gmail.com wrote:
My main curiosity is where/what folder in the website directory or on the database are the pages for the wiki stored? Want to make sure I know where these are so I can easily back them up as needed so I don't lose information.
<me> !backup <mw-bot> See http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki for information about backing up your wiki. For restoring your wiki, see http://www.mediawiki.org/wiki/Manual:Moving_a_wiki#Import_the_database_backu...
Hello all, I had a somewhat small wiki with not a lot of content in it, so when things went wrong with my mediawiki 1.15.x installation upgrade to mediawiki 1.16.0, I just started with a fresh install. At about the time that I figured out that mediawiki 1.16 was the latest version and I was using 1.15.x, I also was running into an error when I added a couple extensions. It was telling me that a cache table did not exist and this was crashing my site, my wiki. I couldn't just create an empty table because I had no idea how many columns were in that table. Anyway, I thought with the new installation I could bring in the content, the articles from the old installation. The problem is that in looking at my exported db, a mysql db, that I exported from phpmyAdmin and my cpanel, and from just browsing the db, I see that the content of the articles are in binary files. So, it's not text that I can just copy and paste into new articles - I only had about 10 of them. Is there a way to get at those binary files that contain the text of the articles, and the wiki code and somehow either import it into my new wiki install or look at it and examine it in some way so that I could copy and paste the content so as to recreate the articles. I should note that I don't seem to have shell access, so I have to use the cpanel and phpmyadmin. Thanks for any tips, Bruce
You may try to import the file in MySQL and use the update script to update the database. Make a backup before you try this.
At 09:50 ¿ÀÀü 2010-09-13, you wrote:
Hello all, I had a somewhat small wiki with not a lot of content in it, so when things went wrong with my mediawiki 1.15.x installation upgrade to mediawiki 1.16.0, I just started with a fresh install. At about the time that I figured out that mediawiki 1.16 was the latest version and I was using 1.15.x, I also was running into an error when I added a couple extensions. It was telling me that a cache table did not exist and this was crashing my site, my wiki. I couldn't just create an empty table because I had no idea how many columns were in that table. Anyway, I thought with the new installation I could bring in the content, the articles from the old installation. The problem is that in looking at my exported db, a mysql db, that I exported from phpmyAdmin and my cpanel, and from just browsing the db, I see that the content of the articles are in binary files. So, it's not text that I can just copy and paste into new articles - I only had about 10 of them. Is there a way to get at those binary files that contain the text of the articles, and the wiki code and somehow either import it into my new wiki install or look at it and examine it in some way so that I could copy and paste the content so as to recreate the articles. I should note that I don't seem to have shell access, so I have to use the cpanel and phpmyadmin. Thanks for any tips, Bruce
--
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ B. M. Whealton - Web Developer, Programmer, Owner: Future Wave Designs: http://FutureWaveDesigns.com "On Being a Poet and Other Existential Ideas":> http://WordSaladPoetryMagazine.com/words/ Publisher of Word Salad Poetry Magazine: http://WordSaladPoetryMagazine.com/ - Submit your poetry ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.851 / Virus Database: 271.1.1/3131
- Release Date: 09/13/10 03:34:00
_ _ (o) (o) oOOO----(_)----OOOo--- Henny (Lee Hae Kang) ----------------------------- http://www.henny-savenije.pe.kr Portal to all my sites http://www.hendrick-hamel.henny-savenije.pe.kr (in English) Feel free to discover Korea with Hendrick Hamel (1653-1666) http://www.hendrick-hamel.henny-savenije.pe.kr/indexk2.htm In Korean http://www.hendrick-hamel.henny-savenije.pe.kr/Dutch In Dutch http://www.vos.henny-savenije.pe.kr Frits Vos Article about Witsen and Eibokken and his first Korean-Dutch dictionary http://www.cartography.henny-savenije.pe.kr (in English) Korea through Western Cartographic eyes http://www.hwasong.henny-savenije.pe.kr Hwasong the fortress in Suwon http://www.oldKorea.henny-savenije.pe.kr Old Korea in pictures http://www.british.henny-savenije.pe.kr A British encounter in Pusan (1797) http://www.genealogy.henny-savenije.pe.kr/ Genealogy http://www.henny-savenije.pe.kr/phorum Bulletin board for Korean studies
B. M. Whealton wrote:
Hello all, I had a somewhat small wiki with not a lot of content in it, so when things went wrong with my mediawiki 1.15.x installation upgrade to mediawiki 1.16.0, I just started with a fresh install. At about the time that I figured out that mediawiki 1.16 was the latest version and I was using 1.15.x, I also was running into an error when I added a couple extensions. It was telling me that a cache table did not exist and this was crashing my site, my wiki. I couldn't just create an empty table because I had no idea how many columns were in that table. Anyway, I thought with the new installation I could bring in the content, the articles from the old installation. The problem is that in looking at my exported db, a mysql db, that I exported from phpmyAdmin and my cpanel, and from just browsing the db, I see that the content of the articles are in binary files. So, it's not text that I can just copy and paste into new articles - I only had about 10 of them. Is there a way to get at those binary files that contain the text of the articles, and the wiki code and somehow either import it into my new wiki install or look at it and examine it in some way so that I could copy and paste the content so as to recreate the articles. I should note that I don't seem to have shell access, so I have to use the cpanel and phpmyadmin. Thanks for any tips, Bruce
http://www.mediawiki.org/wiki/Manual:Upgrading http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki
The old database plus rerunning the installer (temporarily move away LocalSettings.php) creates the new tables.
For exporting a few pages, you can use Special:Export, then Special:Import.
I really like the search box at the upper right of http://www.mediawiki.org. Particularly how it combins a "starts with" search with the "containing" option.
I couldn't figure out how to implement it on my own mediawiki installation. Is there a link someone could direct me to that would explain how I could integrate it?
Thanks. - skew
The new search box is part of the UsabilityInitiative.
Here you'll find more information: http://www.mediawiki.org/wiki/Extension:UsabilityInitiative
- robert
2010/9/13 trueskew trueskew@gmail.com:
I really like the search box at the upper right of http://www.mediawiki.org. Particularly how it combins a "starts with" search with the "containing" option.
I couldn't figure out how to implement it on my own mediawiki installation. Is there a link someone could direct me to that would explain how I could integrate it?
Thanks.
- skew
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Thanks for the reply Robert. Including it on a fresh MW 1.16 did give me a nicer search results page, but the search box itself still doesn't match the one of www.mediawiki.org as I described it. Perhaps it's a component of the skin?
-----Original Message----- From: orschiro@googlemail.com [mailto:orschiro@googlemail.com] Sent: Monday, September 13, 2010 9:26 AM To: trueskew; MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Search box on MediaWiki
The new search box is part of the UsabilityInitiative.
Here you'll find more information: http://www.mediawiki.org/wiki/Extension:UsabilityInitiative
- robert
2010/9/13 trueskew trueskew@gmail.com:
I really like the search box at the upper right of
Particularly how it combins a "starts with" search with the "containing" option.
I couldn't figure out how to implement it on my own mediawiki
installation.
Is there a link someone could direct me to that would explain how I could integrate it?
Thanks.
- skew
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Well did you look at http://www.mediawiki.org/wiki/Extension:UsabilityInitiative#Vector ?
And please enable the vector skin in your preferences or global for every user in LocalSettings.php:
$wgDefaultSkin = 'vector'
- robert
2010/9/13 trueskew trueskew@gmail.com:
Thanks for the reply Robert. Including it on a fresh MW 1.16 did give me a nicer search results page, but the search box itself still doesn't match the one of www.mediawiki.org as I described it. Perhaps it's a component of the skin?
-----Original Message----- From: orschiro@googlemail.com [mailto:orschiro@googlemail.com] Sent: Monday, September 13, 2010 9:26 AM To: trueskew; MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Search box on MediaWiki
The new search box is part of the UsabilityInitiative.
Here you'll find more information: http://www.mediawiki.org/wiki/Extension:UsabilityInitiative
- robert
2010/9/13 trueskew trueskew@gmail.com:
I really like the search box at the upper right of
Particularly how it combins a "starts with" search with the "containing" option.
I couldn't figure out how to implement it on my own mediawiki
installation.
Is there a link someone could direct me to that would explain how I could integrate it?
Thanks.
- skew
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org