CODEWITHSUNDEEP
sqldatabasewordpress
Guillermo Orellana Ruiz
Guillermo Orellana Ruiz

Reputation: 734

Export images embebbed in a Wordpress Database

I have imported a Blogger account into a Wordpress installation. But suddenly I saw that the table wp_posts grow up to 128 MiB, and I noticed that inside some posts there were embebbed images encoded in base64 like this

<img alt="" src="data:image/png;base64,iVBORw0KGgo...." />

How can I export all these images outside the database, to the wp-content folder, and lighten the database?

Is there any kind of plugin doing that?

Some guidelines if not?

Thank you very much.

Upvotes: 0

Views: 256

Answers (1)

fuxia
fuxia

Reputation: 63556

There is a plugin named Blogger Importer. It should handle those images. If it doesn't, write your own importer. That's really simple. Then you have to base64_decode() the images and insert them into the upload directory with wp_insert_attachment().

We have some questions about this topic on WordPress Stack Exchange. Take a look at those and ask there for help if you get stuck.

Upvotes: 1

Related Questions