Delete all transients from your WordPress multisite

Someone asked how he could delete all the transients from a WordPress multisite, as I wrote the code for him, thought to share it here for everyone 🙂

if ( is_multisite() ) {
    global $wpdb;
 
    $all_sites = $wpdb-&gt;get_results( &quot;SELECT * FROM $wpdb-&gt;blogs&quot; );
 
    if ( $all_sites ) {
        foreach ($all_sites as $site) {
            $wpdb-&gt;set_blog_id( $site-&gt;blog_id );
            $wpdb-&gt;query( &quot;DELETE FROM `{$wpdb-&gt;prefix}options` WHERE `option_name` LIKE ('_transient_%')&quot; );
        }
    }
}

if ( is_multisite() ) {

global $wpdb;

$all_sites = $wpdb->get_results( "SELECT * FROM $wpdb->blogs" );

if ( $all_sites ) {

foreach ($all_sites as $site) {

$wpdb->set_blog_id( $site->blog_id );

$wpdb->query( "DELETE FROM `{$wpdb->prefix}options` WHERE `option_name` LIKE ('_transient_%')" );

}

2 thoughts on “Delete all transients from your WordPress multisite”

Pingback: Delete all transients from your WordPress multisite – SecondHack
Beachbum says:

June 7, 2014 at 8:30 pm

Greetings, Thank you for the code. It works perfect. I added a couple more conditions to get rid of the new “nextgen gallery” crap.

Cheerz

get_results( "SELECT * FROM $wpdb->blogs" );
if ( $all_sites ) { foreach ($all_sites as $site) { $wpdb->set_blog_id( $site->blog_id ); $wpdb->query( " DELETE FROM{$wpdb->prefix}options
WHERE option_name LIKE ('_transient_%')
or option_name LIKE ('_site\_transient\_%')
or option_name LIKE ('displayed\_galleries\_%')
" );
}
}
}

?>

Reply

2 thoughts on “Delete all transients from your WordPress multisite”

Leave a Reply Cancel reply