mbouteneff
Mar 11 2008, 08:13 PM
Dear MT Folks,
I recently realized my MT database is overdrawn, and I need to clear records ASAP via PHPMyAdmin. The bulk of the records are in "mt_log", and the bulk of those seem to be either "MT-Blacklist" related, or "MT-Keystrokes" related. There are 580,000 records in the folder. How do I delete ALL the "Keystrokes" records in one act, for example? (It's my first time using PHPMyAdmin.) Please help!
Thanks,
Mike
imabug
Mar 12 2008, 04:40 AM
unless you have a specific reason to keep the other entries in the log table, i'd just dump the whole table. Select the mt_log table and use the big red EMPTY button at the top. mt_log is pretty much a standalone table so it won't affect anything in your blog.
justinmc
Mar 21 2008, 03:07 PM
I wouldn't drop the whole table. If you're still using those plugins you could have errors if the table doesn't exist. Instead, use:
CODE
TRUNCATE TABLE tablename;
In the MySQL query window.