Feature #1406
wiki.typo3.org - SlimFast for the database
| Status: | New | Start: | 2008-08-28 | ||
| Priority: | Should have | Due date: | |||
| Assigned to: | Cyrill Helg | % Done: | 20% |
||
| Category: | admin/ wiki.typo3.org | Spent time: | - | ||
| Target version: | 4.4CUR OOfficeMediawikiFORGE | ||||
Description
Please ask another question in #mediawiki: Is it enough to delete very old changes to get a SMALLER backup? The 67 MB of the "text"-table are to much. Question is if this is enough or if there are references to this table what should also be removed:
SELECT *
FROM text as a
WHERE a.old_title = 'Main_Page' and a.old_namespace=0 and a.old_timestamp < 20051200000000
and (SELECT count(*) FROM text as b WHERE old_title = a.old_title AND b.old_namespace =0) > 2
order by a.old_timestamp DESC
(this just deletes stuff, when 3 or more changes stay in the database)
I just wonder why 20050826162209 is the YOUNGEST timestamp in this table. Crazy! Please ask a second question: is the content in ANOTHER table?
Cheers!
Daniel
History
2008-08-28 20:57 - Cyrill Helg
Hmm why don't you ask them yourself? Furthmore ~60Mb seems totally small. I would not delete anything on such a small database...
2008-08-29 00:20 - Daniel Brüßler
The 67 MB is a tar.gz just from that one database-TABLE "text" - and I have to download it for every backup, because I don't have an ssh-account -- so that IS much.