MySQL database embedded images in posts

  • I’m not sure how this happened, but one of my clients’ WP sites appears to be embedding every single image that is uploaded to a post, directly into the MySQL database for the site. As you can imagine, this enormous amount of data is slowing things down immensely. This is made worse by the fact that the blog is relatively popular.

    Right now I’m backing up the database, and I’m already at 290 MB. This is up >210 MB since I transferred her website from a WordPress.com site, to a local WP.org installation on her own server, it was still a large 80 MB back then.

    Is there some kind of setting in the WP backend I’m missing that is directly uploading all images into the database? Or is this some MySQL setting I have to change, that occurred because I exported her site from WordPress.com? I’m confused as to why this is happening, and would like to prevent it from continuing to occur.

    I would also like to extract all db-embedded images, and have the posts link to their uploaded files instead. How would I go about doing this?

    (The database backup is currently at 325MB and still going…)

Viewing 1 replies (of 1 total)
  • Thread Starter tinuviel

    (@tinuviel)

    Never mind, the actual culprit was a spam box of 40,000 spammed comments, being inflated by Akismet, for some reason.

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL database embedded images in posts’ is closed to new replies.