Help - Search - Members - Calendar
Full Version: How Delete Bulk Records In A Database?
Movable Type Community Forum > Installing and Upgrading > Databases
mbouteneff
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
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
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.