Database import not reflecting in WordPress

  • Resolved superroo

    (@superroo)


    7 years, 1 month ago

    Hi,
    I had a problem with my site and lost all pages/images but managed to export the database.
    Now have re-installed WordPress and imported the database backup but non of the information is showing.
    I can see the data in the tables but nothing is showing in the “All Posts” section…does this mean I have lost everything? I understand that I would have to reload the images but I thought the text & formatting would be OK.
    Can anyone help?

    • This topic was modified 7 years, 1 month ago by superroo.
Viewing 6 replies - 1 through 6 (of 6 total)

  • Is your new WordPress site pointed to the correct database?
    To check, try creating a dummy post, and see if it is visible on the db table wp_posts.

    Hello,
    Open you wordpress wp-config.php from your wordpress root directory.
    check the database name with your imported database name.
    If they are not same then put the same name in you wp-config.php file.
    Thanks.

    Thread Starter superroo

    (@superroo)

    Hi guys,
    have confirmed that database configs are correct in the wp-config.php file.
    I created a new database, imported the script from the backed up database and then changed the details in the wp-config.php to point to it…got the config page then it opens up as a blank site…no old posts are showing ????

    Hello,
    then check your database table.
    If there is posts or not.
    thanks.

    Can you check whether your previous theme files are available in the themes directory and is active?

    Blank page could be due to missing theme.
    Do check and let us know.

    Thread Starter superroo

    (@superroo)

    Theme is in and running….when I look at Dashboard-> Posts->All posts I just see the introductory post “Hello World”.

    When I look at the table: wp_blwc_posts I see the current records that are showing on the site i.e the “Hello World” blog and the “Sample Page”.

    When I look at wp_etiq_posts I see all the posts I have installed from the sql script of the export.

    I notice in the wp-config-php that I have: $table_prefix = ‘wp_blwc_’;

    SORTED…FIXED IT !!!

    Changed $table_prefix = ‘wp_blwc_’ to $table_prefix = ‘wp_etiq_’…reinstalled the theme and IT WORKS. Now I just have to upload the media and reattach…better than rewriting 20 blogs!!

    Thanks for all your help guys and particularly the mention of wp-config.php…much appreciated.

    Now why the different in table names?? Different version??

    • This reply was modified 7 years, 1 month ago by superroo.
Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database import not reflecting in WordPress’ is closed to new replies.