Where are the thumbnails in mysql? Which table?

I use automatic thumbnails plugin that generates thumbs from the picture in postbody, but now when I want to replace the string in mysql and change localhost to my domain, I can’t find it

Only text and meta-data are stored in the database .
Media files (pictures, video … ) are stored in folders .
WP-root/wp-content/themes/themename/images could be a posible location .

In the table ‘wp_posts’ you will find the image url with ‘post_type’ attachment, if the image belongs to a post.

However you could just use the export and import options in WordPress.

Theb use settings > permalinks to rebuild the post and page links, this might be better than playing in the tables.

HTH

David

the problem is that the links to thumbnails are relative, but online they show to local host.

The plugin automatically generates thumbs from the post, but it does not care if you are using xampp or not.

is there another plugin where the thumbs are generated easily in 1 take from picture in posts, I dont want to mess with this plugin anymore

I use Ajax Thumbnail Rebuild not sure if it will help.

If you are transfering WordPress from url to url there are loads of topics about that, it might be worth looking at some of them.

Some of the more experienced guys might jump in with some answers.

Regards

David

what i did is load the mysql in the dreamveaver and just replaced local host with my domain

worked like a charm