MyBB Community Forums

hello. i was trying to back up mysql db and found that there is a huge database (more than 700mb) at mybb_events. After browsing through the events in phpmyadmin, i found that they are all spams, but it just doesnt appear on the forum itself (or does it? i don't know where it was hidden).

how do i remove that huge chunk of db before doing an update?

You can truncate (empty) the table with phpMyAdmin, but that will clear all data in the events table. If they are all spam, then do that.

TRUNCATE `mybb_events`;

If not, then all you can do is simply go through the database and delete them as you go along.

Another suggestion would be to delete the calendar in your ACP, and create a blank one.

thanks! mybb db down to only 2.2mb