Title: SQL Import Problem/ wp_users: Table 'franklinian.wp_users' doesn't exist
Last modified: August 21, 2016

---

# SQL Import Problem/ wp_users: Table 'franklinian.wp_users' doesn't exist

 *  [ChrisUCLA](https://wordpress.org/support/users/chrisucla/)
 * (@chrisucla)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/sql-import-problem-wp_users-table-franklinianwp_users-doesnt-exist/)
 * Hi, I moved my wordpress site from godaddy to my wamp server at home where I 
   have 2 other wordpress sites working perfectly. I imported the sql file from 
   godaddy and then when trying to acces the wp-admin page, it directed to a repair
   page and gave me these errors and said paste them in the forum.
 * wp_users: Table ‘franklinian.wp_users’ doesn’t exist
    wp_usermeta: Table ‘franklinian.
   wp_usermeta’ doesn’t exist wp_posts: Table ‘franklinian.wp_posts’ doesn’t exist
   wp_options: Table ‘franklinian.wp_options’ doesn’t exist wp_postmeta: Table ‘
   franklinian.wp_postmeta’ doesn’t exist wp_terms: Table ‘franklinian.wp_terms’
   doesn’t exist wp_term_taxonomy: Table ‘franklinian.wp_term_taxonomy’ doesn’t 
   exist wp_term_relationships: Table ‘franklinian.wp_term_relationships’ doesn’t
   exist

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

 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/sql-import-problem-wp_users-table-franklinianwp_users-doesnt-exist/#post-4010874)
 * Check the database that you’ve imported the SQL file into. With that error there’s
   really only two things that could be wrong. First, the prefix might be different,
   so it’s looking fof `wp_*` instead of whatever you had set for the imported database.
   If that doesn’t help then check the database connection details. If the tables
   are there but WordPress can’t see them it normally means that you’re connecting
   to the wrong database.
 *  Thread Starter [ChrisUCLA](https://wordpress.org/support/users/chrisucla/)
 * (@chrisucla)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/sql-import-problem-wp_users-table-franklinianwp_users-doesnt-exist/#post-4010908)
 * Im very green with this sorta stuff. Where do I look for the possible prefix 
   issues? How do I correct it from connecting to the wrong database? Thank you 
   for your help 🙂
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/sql-import-problem-wp_users-table-franklinianwp_users-doesnt-exist/#post-4010909)
 * I suggest you start by reviewing [Moving_WordPress](http://codex.wordpress.org/Moving_WordPress).
 *  Thread Starter [ChrisUCLA](https://wordpress.org/support/users/chrisucla/)
 * (@chrisucla)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/sql-import-problem-wp_users-table-franklinianwp_users-doesnt-exist/#post-4010941)
 * When I imported the sql database, this is what came up first:
 * Error
    SQL query:
 * CREATE TABLE `wp_netblog_bibitem` (
 *  `itemID` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    `fieldID` SMALLINT( 5)
   UNSIGNED NOT NULL , `fieldValue` VARCHAR( 255 ) NOT NULL , `usage` INT( 10 ) 
   UNSIGNED NOT NULL DEFAULT ‘1’, PRIMARY KEY ( `itemID` ) ) ENGINE = M– MySQL dump
   10.11 — — Host: localhost Database: fra1301704504244 — —————————————————— — Server
   version 5.0.96-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT*/;
 * MySQL said: Documentation
 * #1064 – You have an error in your SQL syntax; check the manual that corresponds
   to your MySQL server version for the right syntax to use near ‘SET @OLD_CHARACTER_SET_CLIENT
   =@@CHARACTER_SET_CLIENT */’ at line 13
 *  Thread Starter [ChrisUCLA](https://wordpress.org/support/users/chrisucla/)
 * (@chrisucla)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/sql-import-problem-wp_users-table-franklinianwp_users-doesnt-exist/#post-4010942)
 * oh and when i look at that database,(localhost/phpmyadmin/franklinian/) those
   missing tables do not show on the list. Only 4 tables (wp_commentmeta, wp_comments,
   wp_links, wp_netblog) show up.
 *  Thread Starter [ChrisUCLA](https://wordpress.org/support/users/chrisucla/)
 * (@chrisucla)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/sql-import-problem-wp_users-table-franklinianwp_users-doesnt-exist/#post-4010958)
 * Any Ideas on what to do about this?

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

The topic ‘SQL Import Problem/ wp_users: Table 'franklinian.wp_users' doesn't exist’
is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 3 participants
 * Last reply from: [ChrisUCLA](https://wordpress.org/support/users/chrisucla/)
 * Last activity: [12 years, 10 months ago](https://wordpress.org/support/topic/sql-import-problem-wp_users-table-franklinianwp_users-doesnt-exist/#post-4010958)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics