WordPress.org

Support

Support » How-To and Troubleshooting » local database missing tables

local database missing tables

  • falafelle
    Member

    @falafelle

    Dear WordPress community,

    I hope you can help me,
    I just made my own website on local using MAMP.
    Then I tried to put on a distant server.

    But my site is empty, only 1 post, 1 comment, 1 welcomming message.
    So I think there is a problem with my database.
    When I look at it on the host, it appears to be empty. So the problem might be in exporting/importing it.

    When I go to my local MAMP I can only see the wp_spider tables…
    I can’t understand why
    here is a screenshot : screenshot

    maybe it’s a stupid question but I didn’t find any keyword that made me find the answer..

Viewing 12 replies - 1 through 12 (of 12 total)
  • esmi
    Forum Moderator

    @esmi

    falafelle
    Member

    @falafelle

    yes but before moving it,

    the tables :
    wp_commentmeta
    wp_comments
    wp_links
    wp_options
    wp_postmeta
    wp_posts…

    should appear on my local MAMP, right?

    esmi
    Forum Moderator

    @esmi

    In your local database, yes.

    falafelle
    Member

    @falafelle

    Yes, but look at this screenshot of my local DB :
    screenshot
    isn’t there something wrong?

    why do I only see the :
    wp_Spider_Video_Player_…
    tables? where are the others?

    esmi
    Forum Moderator

    @esmi

    Sorry but I cannot see any WordPress core database there. Only some tables for a plugin.

    falafelle
    Member

    @falafelle

    I don’t either and I don’t know why. 🙁
    when I run my site on local, I can see my article and all, I need to know to which database it refers to. Can I see it with chrome element inspector?

    in MAMP when I click on “search” I can see them!
    but where are them?!

    esmi
    Forum Moderator

    @esmi

    Can I see it with chrome element inspector?

    No – you will need to use something like Phpmyadmin. The name of the database will be in your wp-config.php file.

    falafelle
    Member

    @falafelle

    If I am in my local site, with my browser and MAMP, how can I know exactly to witch database my local site refers to?
    because on my local site I can see my site with articles, images and everything
    but when I go to the database I only see what I showed you, so I guess I’m in the wrong place in the db and I don’t know what to do.

    esmi
    Forum Moderator

    @esmi

    The name of the database will be in your wp-config.php file.

    falafelle
    Member

    @falafelle

    so the prob comes from MAMP or phpmyadmin
    when I click on “search” tab, all the tables are in the list.

    is there a way to reinstall MAMP without loosing my site and database please?

    esmi
    Forum Moderator

    @esmi

    Try asking on a forum dedicated to your server software.

    falafelle
    Member

    @falafelle

    yes I did and I finally foud THE solution :
    install the plugin : Lime Export

    export the DB

    it woOOOOOooorksSSS !!!!!!!

    🙂 thanx for your patience and your answers

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘local database missing tables’ is closed to new replies.