So, In our catalog_product_entity_media_gallery table in the Magento 2.3.1. database are around 25.000 lines. Like:
18963,90,/_/_/__1_3.jpg,image,0 18965,90,/_/_/__1_4.jpg,image,0 10815,90,/_/_/__1.jpg,image,0 31586,90,/_/_/__12_1_1.jpg,image,0
Now some images mentioned in the table are not actually any longer on the server:
So when you run command php bin/magento catalog:image:resize
It will fail. We need to reupload image or delete from table. The run command again.
This is extremely timeconsuming. What I want.
Compare contents of catalog_product_entity_media_gallery with what is actually on our server. So we see at once what is missing. Then we can upload those at once and run command again.
All help how to do this comparison is welcome.