Cara Export Post Title, Post URL, Category WordPress via Cpanel PHPmyadmin

buka cpanel masuk ke phpmyadmin, pilih sql databasenya yang mau di export..
Masukkan perintah di bawah dan klik Go, kemudian export :

SELECT ID,
(SELECT group_concat(wp_terms.name separator ‘, ‘) FROM wp_terms
INNER JOIN wp_term_taxonomy on wp_terms.term_id = wp_term_taxonomy.term_id
INNER JOIN wp_term_relationships wpr on wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
WHERE taxonomy= ‘category’ and wp_posts.ID = wpr.object_id ) AS “Categories” ,

(SELECT group_concat(wp_terms.name separator ‘, ‘) FROM wp_terms
INNER JOIN wp_term_taxonomy on wp_terms.term_id = wp_term_taxonomy.term_id
INNER JOIN wp_term_relationships wpr on wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
WHERE taxonomy= ‘post_author’ and wp_posts.ID = wpr.object_id ) AS “Author” ,

(SELECT group_concat(wp_terms.name separator ‘, ‘) FROM wp_terms
INNER JOIN wp_term_taxonomy on wp_terms.term_id = wp_term_taxonomy.term_id
INNER JOIN wp_term_relationships wpr on wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
WHERE taxonomy= ‘post_tag’ and wp_posts.ID = wpr.object_id ) AS “Tags” ,

(SELECT group_concat(wp_terms.name separator ‘, ‘) FROM wp_terms
INNER JOIN wp_term_taxonomy on wp_terms.term_id = wp_term_taxonomy.term_id
INNER JOIN wp_term_relationships wpr on wpr.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
WHERE taxonomy= ‘post_modified_gmt’ and wp_posts.ID = wpr.object_id ) AS “Date” ,

post_title, post_name from wp_posts where post_status=’publish’ and post_type=’post’;

Download File TXT nya export sql

Artikel SEO Lainnya:  Jasa Pembuatan Portofolio Website Bergaransi di timor tengah selatan