Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
How do I get get rid of 36.8MB of txp_log_mention's in MySQL
I did a database backup yesterday before finally upgrading to Txp 4.0.3, an found I have nearly 2700 articles that add up to 24.9MB, and nearly 6,300 comments adding up to 4.8MB.
Considering that contains over 5 years of content, not too bad. But the problem is the table for txp_log_mention, which has over 80,000 items totalling 36.8MB … considerably more than the total for the actual content.
As I understand it, txp_log_mention was for features that weren’t and will never be implemented. If this is true, how can I get rid of this massive waste?
My primary concern is that this extra 36.8MB makes the SQL export file total over 60MB, and right there next to the box you’d use to import said backup file, it says “(Max: 40,960KB)”.
TextPattern user since 04/04/04
Offline
Re: How do I get get rid of 36.8MB of txp_log_mention's in MySQL
Textpattern never inserted data into that table, IIRC. But I think there was a plugin that did.
Anyway, you can simply “truncate tablename;” or even “Drop tablename;” (empty and delete the complete table respectively).
Offline
Re: How do I get get rid of 36.8MB of txp_log_mention's in MySQL
Nope, it’s a Dean Deal. It would appear to be a vestigial table from around g1.18, which is where I started with Textpattern, later deprecated.
Should’ve done the search before, but I wanted to confirm you guys aren’t currently using it, or planning to. Since you weren’t sure where it came from to begin with, I’ll take that as a “yes,” and delete the table.
Edit: For the next upgrade (or perhaps when crockery is added and other database changes are required), it might not be a bad idea to add auto-deletion of that table to your other changes made upon upgrade, because those of us who’ve been upgrading for a while apparently still have it.
And it’s really really big.
Last edited by reid (2006-01-15 19:04:10)
TextPattern user since 04/04/04
Offline
#4 2006-01-15 21:54:22
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: How do I get get rid of 36.8MB of txp_log_mention's in MySQL
I wanted to confirm you guys aren’t currently using it, or planning to.
I think Sencer is correct: the table was created by the Textpattern installer, but was never used by the core code. We’ve since abandoned the ‘mentions’ idea (like Trackback, there’s no way to secure it).
Alex
Offline