Title: Importing WP SQL Data
Last modified: August 19, 2016

---

# Importing WP SQL Data

 *  Resolved [pridedepot](https://wordpress.org/support/users/pridedepot/)
 * (@pridedepot)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/importing-wp-sql-data/)
 * I had an old version of WordPress installed into a Xoops CMS website that was
   adapted to work as a module inside of Xoops. This modularized version of WordPress
   is called Xpress and the version is 2.05 which “I think” translates to a real
   WP version. But I ma not absolutely sure of that.
 * Anyway…For reasons I will not go into here I had to upgrade and made the decision
   to try a new standalone version / installation.
 * Now I want to get my 2 years of posts, comments, views and category data into
   the new WordPress installation’s database.
 * The MySQL Tables that I have critical data in are”
 * wp_posts
    wp_comments wp_categories wp_ post2cat wp_views
 * I have tried a number of different export / import procedures from phpMyAdmin
   from old tables to new tables and I get a variety of unsuccessful results.
 * If I am successful at all importing, for example the wp_posts table data, I get
   a successful message in phpMyAdmin but the data does not show up in the blog.
   Nor do I see it in WP admin. Other times I have see the data in WP Admin it seems
   to break the WP installation as home page returns a data not found error message
 * I have tried Export / Import from old tables to new ones, I have tried CVS as
   well as trying to use the file from the backup plugin in WP but there does not
   seem to be any import functionality with that plugin.
 * Nothing seems to do it. I have perfumed export /imports before but it was a LONG
   time ago. I really hope that I am just missing something.
 * This is a popular blog with lot’s of posts, comments and google links to us that
   would be devastating to lose. I would be VERY GREATFUL for some expert assistance.
 * Thanks so much – Jody

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [pridedepot](https://wordpress.org/support/users/pridedepot/)
 * (@pridedepot)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/importing-wp-sql-data/#post-761879)
 * Update the error I get while importing data NO MATTER WHAT MY SETTINGS on the
   Export or Import is:
 * “Invalid field count in csv input line 1”
 * I have verified that essentially the table structure between the old and new 
   versions are the same. ARGGGG!!!
 *  819340
 * [17 years, 8 months ago](https://wordpress.org/support/topic/importing-wp-sql-data/#post-762320)
 * Hi Pridedepot,
 * Have you been able to do this? i have the same problem!!!!
 * Would appreciate very much your experience.
 * Thanks!
 *  819344
 * [17 years, 8 months ago](https://wordpress.org/support/topic/importing-wp-sql-data/#post-762321)
 * ANy luck? same problem here!! need to relocate the blog to a fresh installation…
   can’t export/import behaves the same way.
 * Thanks for the help!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Importing WP SQL Data’ is closed to new replies.

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: 819344
 * Last activity: [17 years, 8 months ago](https://wordpress.org/support/topic/importing-wp-sql-data/#post-762321)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics