InsideDarkWeb.com

Where does the Media Library live in the database?

I’m exporting a WordPress site from localhost to a web host, and I am unable to import the Media Library, as the web host is unable to contact localhost.

I’ve uploaded all of the localhost files from /wp-content/uploads/…, and I’m thinking I just need to isolate the part of the MySQL database which contains the Media Library, and adjust the URL, then import the SQL into the web host database.

Can you tell me where the Media Library lives in the MySQL database please?

WordPress Development Asked on November 11, 2021

3 Answers

3 Answers

SELECT    
    p.ID,
    p.post_title AS title, 
    p.post_name AS post_name,
   (SELECT meta_value from wp_postmeta where post_id = m.meta_value and meta_key='_wp_attachment_metadata') AS meta_value
FROM 
    wp_posts p, 
    wp_postmeta m
WHERE
        p.post_type = 'post'
    AND p.post_status = 'publish'
    AND p.id = m.post_id
    AND m.meta_key = '_thumbnail_id'
ORDER BY 
    p.post_date DESC
LIMIT 5;

And then use PHP unserialize 'meta_value'

Answered by Francisco Juan on November 11, 2021

Select * from wp_posts where post_type = 'attachment';

Will return all the entries in the Media Library.
After the execution, you can export the result table as SQL, or CSV, or any other portable data format you like. Remember, if you are not sure if the entries already exist in your database, use the INSERT IGNORE statement instead of INSERT. (This is possible through exporting pan in phpMyAdmin or other MySQL clients).
Also, there are entries referring to the Media Library in each post, such as attachment images or thumbnail images, which are stored in the wp_postmeta table. Wordpress stores them so the media "attaches" to posts or pages. If you want those to be exported too, you will need to use something like this :

 SELECT * FROM  `wp_postmeta` 
 WHERE meta_key IN (
   '_wp_attached_file', 
   '_wp_attachment_backup_sizes',  
   '_wp_attachment_metadata',  
   '_thumbnail_id'
 )

And then you can export them to wherever you want. It is all I know about media library stuff in Wordpress.

Answered by Mohsen Rabieai on November 11, 2021

The Media Library lives in both wp_posts and wp_postmeta.

  • wp_postmeta contains the image URL
  • wp_posts contains an entry for each image insertion into a post, along with the post ID.

Exporting and importing these 2 tables as SQL did not work for me - I received 'duplicate entry for key 7'...

Exporting and importing these 2 tables as CSV did work, using "CSV using load data".

Before importing, I emptied the 2 tables in the recipient database.

Answered by Steve on November 11, 2021

Add your own answers!

Related Questions

Sending current featured image to email

0  Asked on January 26, 2021 by hm-dadou

   

wp_mail doen’t send mails whit attachment

2  Asked on January 25, 2021 by stonesmith

   

How to get category id of current post?

5  Asked on January 24, 2021 by jrcollins

 

preg_replace regex problem

1  Asked on January 23, 2021 by jim-worrall

   

How to display a sidebar only for blog?

1  Asked on January 23, 2021 by johny-j

 

Fill post titles from post content?

1  Asked on January 23, 2021 by cecily

     

Ask a Question

Get help from others!

© 2021 InsideDarkWeb.com. All rights reserved.