Nzira yeBulk Delete WordPress Custom Sections/Fields/Domains?

WordPressMakolamu echinyakare haana simba chete, asiwo anoshanda zvakanyanya.Mazhinji WordPress themes uye plugins anoshandisa tsika makoramu kuita mabasa akasiyana.

Chinyorwa chinotarisa manhamba plugin WP-PostViews yatinoshandisa kunyora tsika makoramu mudura ▼

views

Akashandiswa wordpress themes kana plugins, mushure mekudzima uye kudzima, kazhinji vanochengeta yavo yetsika minda mudhatabhesi.

Kana huwandu hwe data hwakakura, pese pese webhusaiti painobvunza dhatabhesi, inodya iyo RAM ndangariro yemuiti, izvo zvinonyatso kanganisa kushanda kwakajairika kwewebhusaiti.

tinoitaSEO, kunyora zvinopfuura chinyorwa chimwe, kana iwe ukadzima aya marara tsika makoramu, hazvishande zvachose.

Kutaura zvazviri, tinofanira chetephpMyAdminIta murairo weSQL kudzima aya marara tsika makoramu mumabhechi mudhatabhesi.

Kuchenjerera

Sezvo WordPress yakawanda inobvisa tsika makoramu, ine hukama neMySQL databasekushanda, kune dzimwe njodzi.

Naizvozvo, iva nechokwadi chekugadzira dhatabhesi yekuchengetedza usati waita mashandiro edhatabhesi.

Method 1: Delete redundant tsika makoramu nemirairo yedatabase (inokurudzirwa)

1) Mushure mekupinda mu phpMyAdmin dhatabhesi, sarudza yako dhatabhesi.

2) Dzvanya pa "SQL" pamusoro pe database.

3) Pinda uye uite mirairo inotevera mu "SQL":

DELETE FROM wp_postmeta WHERE meta_key = "自定义栏目名称";

4) Wobva watarisa chikamu chetsika muchinyorwa chewebhusaiti yako kuti uone kana chabviswa zvakabudirira.

Method 2: PHP kodhi yekudzima yakareruka tsika makoramu

1) Ndapota wedzera kodhi inotevera kumabasa.php faira yezvino musoro ▼

global $wpdb;
$wpdb->query( "
DELETE FROM $wpdb->postmeta
WHERE `meta_key` = '栏目名称'
" );

2) Shandura "Zita reColumn" kune iyo tsika column yaunoda kudzima.

• Iyo yetsika column inozocheneswa otomatiki kubva kune database.

3) Iyi kodhi inoshandiswa chete kana ichidikanwa:

• Iva nechokwadi chekuidzima mushure mekupedza basa rekudzima.
• Kana iwe uchida kuishandisa nguva inotevera, ndapota wedzera kune function.php faira yezvino tema zvakare,
• Nekuti inoda kuwedzerwa nekudzimwa, zvinonetsa, saka hazvikurudzirwe.

Bvisa zvinyorwa zvepostmeta zvisingabatsiri

Iyo rekodhi rekodhi inogona kunge yakadzimwa, asi iyo data iri mulog yekuwedzera tafura postmeta haina kubviswa, saka yakangobviswa pamaoko.

1) Mushure mekupinda mu phpMyAdmin dhatabhesi, sarudza yako dhatabhesi.

2) Dzvanya pa "SQL" pamusoro pe database.

3) Pinda uye ita murairo unotevera mu "SQL" ▼

DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL

Kana yako WordPress webhusaiti, CPU, memory MEMORY kushandiswa kwakanyanyisa ...

Kuti uwane mhinduro, ndapota tarisa kune ino tutorial▼

Chii chandinofanira kuita kana iyo CPU uye ndangariro kushandiswa kweiyo WordPress webhusaiti yakanyanya kukwirira?

Chii chandinofanira kuita kana iyo CPU uye ndangariro kushandiswa kweiyo WordPress webhusaiti yakanyanya kukwirira? 1) Tarisa cron timing mabasa Chero bedzi CPU uye MEMORY yeWordPress webhusaiti zvakawandisa, iyo WP Crontrol plugin inofanira kuiswa uye kushandiswa.Tarisa mu "Zvishandiso" → "WP-Cron Zviitiko"...