Where exactly does ShortPixel store the data on the database?
Here's where ShortPixel Image Optimizer (SPIO) stores all the necessary information on your WordPress database:
- The tables "wp_shortpixel_meta" and "wp_shortpixel_folders" are created by ShortPixel and they contain your settings for the Additional Media Folders: Images outside Media Library
- The image optimization data is in the table "wp_postmeta"
- The plugin settings are in the table "wp_options". All the ShortPixel entries are prefixed with the string "wp-short-pixel".
ShortPixel Adaptive Images stores its settings in the table "wp_options", just like SPIO.
Note: the prefix "wp_" may be different depending on each website's configuration.