User talk:Catrope

Discussion page of User:Catrope
Revision as of 18:01, 23 September 2007 by Catrope (talk | contribs) (Removing archived content)


I speak English (near-native), Dutch (native) and German (limited)
Feel free to ask your question in either of these three languages


creating and modifying templates

i've been looking around on the internet for pointers on creating my own templates and working with other more interesting wiki features, but i'm not having much luck. is there a site you can point me to? the feature i was trying to add on my userinfo was school. thanks! Caw 17:14, 15 September 2007 (CDT)

Here is a pretty extensive guide on templates. For more complex templates ParserFunctions are useful, although you probably won't have to use them at first. If you want to add stuff to the box templates, you might also want to read about tables, which we use to format the boxes. Good luck! ---Catrope(Talk to me or e-mail me) 09:33, 17 September 2007 (CDT)

dumpBackup.php

I figure you might know the answer to this, so I'll ask you before I make a query on the mediawiki mailing list. Is there a way to specify what kinds of pages can be dumped using dumpBackup.php? For instance, I want to make a dump of pages in the article, portal, sources, category, template, and Battlestar Wiki namespaces, but not anything pertaining to the user or any talk namespaces. Is there an option I need to pass in the command line to do that? Or another program? Thanks! -- Joe Beaudoin So say we all - Donate - Sanctuary Wiki — New 11:55, 23 September 2007 (CDT)

How about using MWDumper instead? BTW, why would you want an XML dump of content-only stuff? --Catrope(Talk to me or e-mail me) 12:05, 23 September 2007 (CDT)
Cool. Thanks again! :-) As for why, I'm building a mirror in the event the main server should ever go down. (I don't expect it to, but you never know.) -- Joe Beaudoin So say we all - Donate - Sanctuary Wiki — New 12:07, 23 September 2007 (CDT)
It can be done with dumpBackup.php also:
php dumpBackup.php --filter=namespace:NS_MAIN,NS_CATEGORY,NS_TEMPLATE,NS_PROJECT,100,102
Where 100 and 102 are the numbers associated with the Portal and Sources namespaces (see also here). BTW, wouldn't it be wise to include Quotes (104) and Podcast (106) too? --Catrope(Talk to me or e-mail me) 12:14, 23 September 2007 (CDT)
Yeah, I'll add those namespaces too. -- Joe Beaudoin So say we all - Donate - Sanctuary Wiki — New 12:17, 23 September 2007 (CDT)
Well, by just restricting it to the most valuable content, it cut the xml filesize down by half. ;-) -- Joe Beaudoin So say we all - Donate - Sanctuary Wiki — New 12:26, 23 September 2007 (CDT)
I see. For serious backups, you want to backup the entire DB though, so as to also backup users and their preferences, not to mention the quite huge {page,template,image,category,external,lang}links, redirect, *cache and math tables. You could exclude them to cut down on backup size, as they can be rebuilt from the pages' content. That would take quite some time, though, considering the amount of pages we have here. During the rebuild, categories, Special:Whatlinkshere and redirects won't work very well. Also, the wiki might be somewhat slower since its internal caches are gone. --Catrope(Talk to me or e-mail me) 12:39, 23 September 2007 (CDT)
Well, the entire database is backed up on a weekly basis. ;-) -- Joe Beaudoin So say we all - Donate - Sanctuary Wiki — New 12:41, 23 September 2007 (CDT)
That's a comforting thought. Like I said, some tables can be rebuilt on the fly (you might wanna try excluding them to see if it makes a difference in the backups, I think that it'll at least speed up recovery, less stuff for mysqlbackup to import), but rebuilding will take significant time, although there's not much denial of service involved: the wiki will be somewhat slower, and some features aren't used very often anyway will not work fully. --Catrope(Talk to me or e-mail me) 12:45, 23 September 2007 (CDT)
BTW, if you want to get a general idea of how all those tables work together, see this picture. --Catrope(Talk to me or e-mail me) 12:46, 23 September 2007 (CDT)