Export media data directly from the WordPress database

I recently had a client ask for a one-time data dump of images in the WordPress’ Media area, including title, description, alt tag and caption. WordPress stores common data in the POSTS table, with additional data in POSTMETA. I used this query to export the data to CSV/Excel. Following this, we discovered the full media … Read more