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

  • ChrisUCLA

    (@chrisucla)


    10 years, 8 months ago

    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

    (@catacaustic)

    10 years, 8 months ago

    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

    (@chrisucla)

    10 years, 8 months ago

    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

    (@esmi)

    10 years, 8 months ago

    I suggest you start by reviewing Moving_WordPress.

    Thread Starter ChrisUCLA

    (@chrisucla)

    10 years, 8 months ago

    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

    (@chrisucla)

    10 years, 8 months ago

    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

    (@chrisucla)

    10 years, 8 months ago

    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.