TTEH !FFSTTEHV7. joined in and replied with this 11 years ago, 4 hours later, 8 hours after the original post[^][v]#566,267
@previous (D)
everyone knows his references are outta control
r04r joined in and replied with this 11 years ago, 8 hours later, 16 hours after the original post[^][v]#566,362
This is a joke, but the database dump is about 800mb, which compresses down to 250mb. That is everything, including private information such as IP addresses. It might be a nice idea to release just the topics and replies sometime, without uid/ip information. Then there's the images of course, which clock in at 2gb.
I do keep daily backups.
(Edited 1 minute later.)
Anonymous G joined in and replied with this 11 years ago, 6 minutes later, 17 hours after the original post[^][v]#566,364
@previous (r04r)
Why do you post with an admin hyperlink? Is it like a reminder to other posters or a badge of authority?
r04r replied with this 11 years ago, 1 minute later, 17 hours after the original post[^][v]#566,366
@previous (G)
It's so people see the post is made by an admin. I normally post anonymously, but that wouldn't make a lot of sense here.
FuckAlms !vX8K53rFBI joined in and replied with this 11 years ago, 2 hours later, 19 hours after the original post[^][v]#566,399
@566362 (r04r)
How can I shrink the database? OTK is bloated to over 1GB and we barely even have any content.
(Edited 49 seconds later.)
r04r replied with this 11 years ago, 3 hours later, 22 hours after the original post[^][v]#566,516
@previous (FuckAlms !vX8K53rFBI)
I've not done anything to shrink it. I occasionally delete UIDs that have 0 posts and have not been used in a long time, and clear the activity table, but that doesn't do that much. The size I cited is that of an .sql backup file generated by mysqldump of all the databases I have, which excludes any kind of indexes though it's not a compact format either. However phpmyadmin still only shows 885mb for the entire database, which nearly matches the actual disk usage of 887mb.
The largest table is the users table at 265mb, then replies at 228mb, then failed postings at 80.6mb (i should prune this one probably), then activity at 74.8mb.
squeegee (OP) replied with this 11 years ago, 42 minutes later, 23 hours after the original post[^][v]#566,518
neat, that's what i wanted to know.
Metæ joined in and replied with this 11 years ago, 23 minutes later, 23 hours after the original post[^][v]#566,524
@566,362 (r04r)
Do you have any backups of early MC from 2010? It would be neat to have like museum.minichan.org and relive all the old drama.