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