Exporting without Trackbacks

  • I’ve waited for far too long to change to WordPress. I’m still running MT 2.64, and I really want to make the switch. The only problem is that I have so much trackback spam that I can’t export my blog entries. There’s over 60,000.

    Does anyone know how to export without the trackbacks?

Viewing 5 replies - 1 through 5 (of 5 total)

  • Delete them first. Perhaps a MySQL query would come in handy.

    Thread Starter opaun

    (@opaun)

    I’d like to delete them, but other than clicking each item on each entry, I don’t know how. Could you direct me to a site that might explain how to do that using MySQL? My programming knowledge doesn’t extend much beyond the CSS that I learned three years ago when I created the site ??

    DELETE FROM table_name WHERE somecolumn='something'

    Not sure on the WHERE syntax as I’ve never used MT, but basically you want to do where comment type = trackback. Oh, and make sure to backup first!!! You don’t want to delete any comments or anything after all. ??

    https://dev.mysql.com/doc/refman/5.0/en/delete.html

    Thread Starter opaun

    (@opaun)

    Thanks for the reference. Unfortunately, part of the problem is that I can’t backup, I have so many spam trackbacks that it always crashes when I try.

    As we said, delete the spam trackbacks before backing up.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Exporting without Trackbacks’ is closed to new replies.