• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

How can I delete images in bulk with MySQL query?

T

twm

Chevereto Member
I need to delete all the images of a user,
But this user has a lot of images(1M).
How can I delete images in bulk with MySQL query?


In new version(3.13.2), this tips isn’t valid.

Purge guest images older than specific date with SQL query

If you are looking to reclaim some space on your server by deleting those guest images without any views, run the below query to force expire them in database which will get deleted cleanly. update chev_images set image_expiration_date_gmt='2018-11-10 00:00:00' WHERE image_date
chevereto.com chevereto.com

Thank you very much.
 
You must log in or register to reply here.
Back
Top