User Tools

Site Tools


tools:db:wpexport

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
tools:db:wpexport [2019/01/12 17:53]
127.0.0.1 external edit
— (current)
Line 1: Line 1:
-====== WordPress exporter ====== 
  
-Put this file in your blog root, say to /wpdump.php , then browse to %%http://​yoursite/​flatpress/​wpdump.php%% 
- 
-save the output as ''​export.sql''​ from your browser window. 
- 
-Import to the ''​wordpress''​ table of your database using phpMyAdmin or any analogue tool (if your WP installation is not new, do a backup before!) 
- 
-**IMPORTANT!** once you're done, delete it from the server! 
- 
-Many thanks to the people who wrote [[http://​www.byteclub.net/​wiki/​Sphpblog_to_wordpress|the ruby script]] and thanks to **native** from [[http://​spbitalia.altervista.org/​forum/​viewtopic.php?​pid=6174#​p6174|SPBItalia]] for sharing. 
- 
-<file php wpexport.php>​ 
-<?php 
-  ​ 
-    require_once('​defaults.php'​);​ 
-    require_once(INCLUDES_DIR.'​includes.php'​);​ 
-    ​ 
-    if (function_exists('​system_init'​)) { 
-    system_init();​ 
-    } else { 
-    plugin_loadall();​ 
-    } 
-    ​ 
-      header('​Content-Type:​ text/plain; charset=utf-8'​);​ 
- 
-    ​ 
-    function toutf($str) { 
-        // comment this one and uncomment the following line if you're using SPB! 
-    return $str; 
- 
-        //return mb_convert_encoding($str,​ '​UTF-8',​ '​ISO-8859-1'​);​ 
-    } 
- 
-    error_reporting(E_ALL);​ 
- 
-    $WP_PREFIX = '​wp_';​ 
-    ​ 
-    $POSTID = 10; 
-    $COMMENTID = 10; 
-    ​ 
-    $SQL_STRING = '';​ 
-    $q = new FPDB_Query(array('​start'​=>​0,​ '​count'​=>​-1,​ '​fullparse'​=>​true),​ null); 
-    while($q->​hasMore()) { 
-    ​ 
-        list($id, $e) = $q->​getEntry();​ 
-        ​ 
-        $obj =& new comment_indexer($id);​ 
-        $clist = $obj->​getList();​ 
-        $ccount = count($clist);​ 
-        $date = date("​Y-m-d H:​i:​s",​ $e['​date'​]);​ 
- 
-        ​ 
-        $SQL_STRING = "​INSERT INTO {$WP_PREFIX}posts (id, post_author,​ post_date, post_date_gmt,​ post_content,​ post_title, post_name, comment_count) "; 
-        $SQL_STRING .= "​VALUES ({$POSTID}, 1, '​{$date}',​ '​{$date}',​ '"​ . addslashes(toutf(apply_filters('​the_content',​ $e['​content'​]))) . "',​ '"​ .  
-                            addslashes(toutf($e['​subject'​])) ."',​ '";​ 
-        $SQL_STRING .= sanitize_title($e['​subject'​]) ."',​ {$ccount}); \n"; 
-        ​ 
-        echo $SQL_STRING;​ 
-    ​ 
-        foreach ($clist as $cid)  { 
-            $c = comment_parse($id,​ $cid); 
-            $cdate = date("​Y-m-d H:​i:​s",​ $c['​date'​]);​ 
-            $SQL_STRING = "​INSERT INTO {$WP_PREFIX}comments (comment_id,​ comment_post_id,​ comment_content,​ comment_author,​ comment_date,​ comment_date_gmt) "; 
-            $SQL_STRING .= "​VALUES ($COMMENTID,​ $POSTID, '"​ . /* in questo particolare caso */ addslashes(toutf(apply_filters('​the_content',​ $c['​content'​]))). "',​ '";​ 
-            $SQL_STRING .= addslashes(toutf($c['​name'​])) . "',​ '​{$cdate}',​ '​{$cdate}'​ ); \n"; 
-        ​ 
-            echo $SQL_STRING;​ 
-            ​ 
-            $COMMENTID++;​ 
- 
-        } 
-        ​ 
-        ​ 
-        $POSTID++; 
-    ​ 
-    } 
- 
-?>    ​ 
-</​file> ​ 
- 
-Added by marcoverga86 
-This **new version** ​ works (tested) with WP 2.8. I've also added the SQL for the categories. Enjoy! 
- 
-<file php wpexport_marcoverga86.php>​ 
-<?php 
-  
-    require_once('​defaults.php'​);​ 
-    require_once(INCLUDES_DIR.'​includes.php'​);​ 
-    require_once(SMARTY_DIR.'​plugins/​function.list_categories.php'​);​ 
-  
-    if (function_exists('​system_init'​)) { 
-    system_init();​ 
-    } else { 
-    plugin_loadall();​ 
-    } 
-  
-      header('​Content-Type:​ text/plain; charset=utf-8'​);​ 
-  ​ 
-    function toutf($str) { 
-        // comment this one and uncomment the following line if you're using SPB! 
-    return $str; 
-  
-        //return mb_convert_encoding($str,​ '​UTF-8',​ '​ISO-8859-1'​);​ 
-    } 
-  
-    error_reporting(E_ALL);​ 
-  
-    $WP_PREFIX = '​wp_';​ 
-  
-    $POSTID = 10; 
-    $COMMENTID = 10; 
- $CATID = 1; 
-  
-    $SQL_STRING = '';​ 
- 
- $cats=entry_categories_get();​ 
-  
- 
-  
- foreach ($cats['​defs'​] as $v) { 
- $SQL_STRING = "";​ 
- $SQL_STRING = "​INSERT INTO {$WP_PREFIX}terms (term_id, name, slug, term_group) VALUES ( $CATID, '"​ . $v . "',​ '"​ . sanitize_title($v) . "',​ 0);" . "​\n";​ 
- $CATID++; 
- echo $SQL_STRING;​ 
- } 
-  
-$q = new FPDB_Query(array('​start'​=>​0,​ '​count'​=>​-1,​ '​fullparse'​=>​true),​ null); 
-    while($q->​hasMore()) { 
-  
-        list($id, $e) = $q->​getEntry();​ 
-  
-        $obj =& new comment_indexer($id);​ 
-        $clist = $obj->​getList();​ 
-        $ccount = count($clist);​ 
-        $date = date("​Y-m-d H:​i:​s",​ $e['​date'​]);​ 
-  
-  
-        $SQL_STRING = "​INSERT INTO {$WP_PREFIX}posts (post_content_filtered,​ pinged, to_ping, post_excerpt,​ id, post_author,​ post_date, post_date_gmt,​ post_content,​ post_title, post_name, comment_count) "; 
-        $SQL_STRING .= "​VALUES ('',​ '',​ '','',​ {$POSTID}, 1, '​{$date}',​ '​{$date}',​ '"​ . addslashes(toutf(apply_filters('​the_content',​ $e['​content'​]))) . "',​ '"​ .  
-                            addslashes(toutf($e['​subject'​])) ."',​ '";​ 
-        $SQL_STRING .= sanitize_title($e['​subject'​]) ."',​ {$ccount}); \n"; 
-  
-        echo $SQL_STRING;​ 
-  
-        foreach ($clist as $cid)  { 
-            $c = comment_parse($id,​ $cid); 
-            $cdate = date("​Y-m-d H:​i:​s",​ $c['​date'​]);​ 
-            $SQL_STRING = "​INSERT INTO {$WP_PREFIX}comments (comment_id,​ comment_post_id,​ comment_content,​ comment_author,​ comment_date,​ comment_date_gmt) "; 
-            $SQL_STRING .= "​VALUES ($COMMENTID,​ $POSTID, '"​ . /* in questo particolare caso */ addslashes(toutf(apply_filters('​the_content',​ $c['​content'​]))). "',​ '";​ 
-            $SQL_STRING .= addslashes(toutf($c['​name'​])) . "',​ '​{$cdate}',​ '​{$cdate}'​ ); \n"; 
-  
-            echo $SQL_STRING;​ 
-  
-            $COMMENTID++;​ 
-  
-        } 
-  
-  
-        $POSTID++; 
-  
-    } 
-?> 
-</​file>​ 
tools/db/wpexport.1547312012.txt.gz ยท Last modified: 2019/01/12 17:53 by 127.0.0.1