Title: Imported data thru phpmyadmin not displaying in UI
Last modified: September 1, 2016

---

# Imported data thru phpmyadmin not displaying in UI

 *  Resolved [UserDG](https://wordpress.org/support/users/tenkepadu/)
 * (@tenkepadu)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/)
 * I move my website into new web server. Now, I exported the remaining data of 
   cf7dbplugin_submits and cf7dbplugin_st thru CSV from the old server and imported
   it to a new server (same database table name).
 * It’s successfully imported. I checked it with the query, and the new data is 
   existing now in the database but not in the UI in WP-Admin.
 * How to fix this?
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

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

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/#post-7500877)
 * The table names should have a prefix “wp_” by default, i.e. wp_cf7dbplugin_submits.
   All your WP tables for a particular instance should start with the same prefix
   that you set during the WP installation. make sure the CFDB table names have 
   the same prefix as the tables in the new installation.
 * PS. you only need to copy data from the wp_ cf7dbplugin_submits table.
 *  Thread Starter [UserDG](https://wordpress.org/support/users/tenkepadu/)
 * (@tenkepadu)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/#post-7500905)
 * yes, i have a table prefix. the old table name have the same name of the new 
   table but still not displayed
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/#post-7500929)
 * The old table has the same as the new one, but in the new database do all the
   other tables use the same prefix? If not, make the table have the same as the
   others.
 * I suspect you have 2 tables, one that you imported and on that CFDB created, 
   both with a different prefix.
 *  Thread Starter [UserDG](https://wordpress.org/support/users/tenkepadu/)
 * (@tenkepadu)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/#post-7500981)
 * yes, the old and new table have same prefix. I query the new added rows thru 
   phpmyadmin and the data is displayed but in WP UI is not 🙁
 * even I do a custom PHP that will display the data from _cf7dbplugin_submits table,
   the new added row is not displayed too.
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/#post-7500984)
 * I don’t think you understood my last post.
 * In a typical installation, the table name should be wp_cf7dbplugin_submits not
   _cf7dbplugin_submits. I suspect you have both of these tables and the plugin 
   is reading from the empty one (wp_cf7dbplugin_submits).
 * If you explicitly changed the table prefix for the installation from “wp_” to
   something else like “xxxx_” then the name name must be “xxxx_cf7dbplugin_submits”.
 * The plugin will create a table for itself with the right prefix if it does not
   find one existing.
 *  [higunjan](https://wordpress.org/support/users/higunjan/)
 * (@higunjan)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/#post-7501029)
 * Hello Michael I have same problem. I’m going to upload CSV as same as format 
   like table “wp_cf7dbplugin_submits”. Insertion done success but doesn’t display
   on front-end from that data entry display out of 500 entry.
 * What relation between “wp_cf7dbplugin_submits” & “wp_cf7dbplugin_st” ?
 * Need to add Dates in “wp_cf7dbplugin_st” ?
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/#post-7501031)
 * If you are using PHPMyAdmin to import CSV, make sure you use PHPMyAdmin to export
   the CSV. Don’t import CSV exported from the CFDB Admin page.

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

The topic ‘Imported data thru phpmyadmin not displaying in UI’ is closed to new 
replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [imported](https://wordpress.org/support/topic-tag/imported/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * 7 replies
 * 3 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [9 years, 10 months ago](https://wordpress.org/support/topic/imported-data-thru-phpmyadmin-not-displaying/#post-7501031)
 * Status: resolved