[13:13:24] hi, if no one has a ".sql" backup of a MW db the only way to backup and access the pages and such is to do a full mysql dir backup no? [13:18:19] if nobody has a .sql backup, you can create one... [13:26:49] biberao: if you want a backup of *content*, you should make an XML dump using maintenance/dumpBackup.php [13:27:08] that's future proof, in that it can be imported into future versions of mediawiki, into other instances, etc. [13:27:27] if you need a backup of the operational data (e.g. user accounts), you have to make an SQL dump [13:27:35] while an SQL dump is pretty future proof in practise [13:27:35] i highly recommend doing both on a regular basis [13:27:45] Worst case scenario you just have to run update.php [13:28:07] restoring from an sql dump is a lot easier than from an XML dump [13:28:20] bawolff: yea, but an XML dump is portable, and easy to splice using scripts, and so on [13:28:32] also, sql dumps are *very* sensitive to encoding issues [13:29:05] depends on the usecase, but if its a backup in case of db server exploding, I think an sql dump would probably be more useful [13:29:11] biberao: when making sql dumps (and when restoring from them), ALWAYS use --default-character-set=BINARY ! [13:29:56] otherwise, mysql may try to be smart and convert to your console's encoding. [13:30:26] If you want to merge two wikis contents together, give random people your wiki contents, merge the current wiki's content into a new wiki, or anything like that, xml dump is much more useful [13:30:26] bawolff: yes, xml is more for archival for posterity [13:35:48] duesen__: but that requires query the db [13:35:54] which isnt possible at the moment [13:36:05] and note that neither sql nor xml dumps include the uploaded files [13:36:55] biberao: that's a new condition you hadn't told us [13:41:19] ya [13:41:24] thats what i meant sorry [13:43:09] then yes, you would have to copy the mysql dir [13:43:19] you can then at one point start the mysql server :P [13:44:48] Platonides: the problem is i cant find it haha [13:44:58] what? [13:45:08] the database server [13:45:18] its nowhere [13:45:44] Well then i think you have a problem... [13:47:21] biberao: should be in /var/lib/mysql [13:47:31] biberao: but may it's on a different box?... [13:48:22] can you tell us how you got into the current situation? [13:48:30] also, do you have root rights on the system(s) in question? [13:48:31] its not my system [13:48:36] it runs in a glusterfs [13:48:42] then you cannot see or copy the raw database files [13:48:48] ya [13:49:41] ...and the mysql server is not running? [13:49:49] ...and you have no control over starting it? [13:49:51] ya [13:49:52] not there [13:49:53] who des, then? [13:50:10] im waiting for an answer hehe [13:50:24] thanks guy [13:50:45] yea, well - you either need the mysql server to be running, or access to raw mysql data files. [13:50:47] good luck! [13:52:42] thanks [21:30:14] "ValidSkinNames": { [21:30:14] - "minervaneue": "MinervaNeue", [21:30:14] - "minerva": "Minerva" [21:30:15] + "minerva": "MinervaNeue" [21:30:15] }, [21:30:21] * Azxiana proceeds to throw a desk across the room. [21:30:32] Time to update thousands of wikis settnigs because of that change. [21:36:53] or just change that to "minervaneue": "MinervaNeue",\n"minerva": "MinervaNeue" [21:38:25] ! [21:38:25] Hello, I'm wm-bot. The database for this channel is published at http://wm-bot.wmflabs.org/db/%23mediawiki.htm More about WM-Bot: https://meta.wikimedia.org/wiki/wm-bot [21:38:32] Platonides: Thank you for saving my sanity.