WordPress conversion data through SQL statementsfor converting large amounts of data between Blog, often using the usual blog conversion process will be very slow and error-prone, for MySQL is based on the WordPress upload data have some limitations, so I came up with some SQL statements directly through Z-Blog to WordPress conversion method. For the Z-Blog users, you can execute the following SQL data tables set up. CREATE TABLE blog_Article (log_ID int NOT NULL, log_CateID int NULL, log_AuthorID int NULL, log_Level int NULL, log_Url varchar (255) NULL, log_Title varchar (255) NULL, log_Intro longtext NULL, log_Content longtext NULL, log_IP varchar (15) NULL, log_PostTime datetime NULL, log_CommNums int NULL, log_ViewNums int NULL, log_TrackBackNums int NULL, log_Tag varchar (255) NULL, log_IsTop varchar (10) NOT NULL) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1; CREATE TABLE blog_Category Air Jordan 12 (cate_ID int NOT NULL , cate_Name varchar (50) NULL, cate_Order int NULL, cate_Intro varchar (255) NULL, cate_Count int NULL) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1; then use the ACCESS database MYSQL database conversion software to convert the database to MySQL, Then execute the following SQL statements directly into the MySQL database 2015 Latest Nike Shoes conversion can be realized. Here in Z-BLog Nike Air Max 90 Premium 1.7 Conversion to WordPress 2.3, for example, the following is used to convert SQL statements before executing Nike Air Presto Mens the SQL table please clear the following data: INSERT INTO wp_posts (id, post_author, post_date, post_date_gmt, post_content, post_title, post_category, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, Top Design Nike Air Force 1 Unisex Yellow White Shoes post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count) Latest Nike Lunar Force 1 Fuse PRM QS Mens All White Shoes SELECT log_ID, '1', log_PostTime, log_PostTime, log_Content, log_Title , log_CateID, log_Intro, 'publish', 'open', 'open', '', log_ID, '', '', log_PostTime, log_PostTime, '', Latest Nike Air Force 1 Unisex Green White Shoes 0, log_ID, 0, 'post', '', 0 FROM blog_Article; INSERT INTO wp_terms (term_id, name, slug, term_group) SELECT cate_ID, cate_Name, cate_Intro, 0 FROM blog_category; INSERTINTO wp_term_taxonomy (term_taxonomy_id, term_id, taxonomy, description, parent, count) SELECT cate_ID, cate_ID, 'category', ' ', 0, cate_Count FROM blog_category; INSERT INTO wp_term_relationships select id, post_category from wp_posts; If you installed WP-PostViews plug-ins, you can also execute the following SQL statement to Article Hits into WordPress: INSERT INTO `wp_postmeta` select log_ID, log_ID, 'view', log_ViewNums FROM blog_Article; for other systems to convert to WordPress, you can use similar methods to achieve, for example, we can convert Discuz comments to WordPress comment, use something like the following statement: insert wp_comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) select tid, author, '[email protected]', '', useip, from_unixtime (dateline), from_unixtime (dateline) , message, 0, '0', '', '', 0,0 FROM t_posts;