Help with importing .sql file

  • mariafgp

    (@mariafgp)


    10 years, 4 months ago

    I have an old backup .sql file from a version 3.4.1 WordPress installation. Had to reinstall WordPress using 4.4.2. Not sure what version the old MYSQL was using. Got this from the .sql file:
    — Server version: 5.0.92
    — PHP Version: 5.3.4

    Currently using version 5.5 of MYSQL and PHP Version: 5.4

    Is there any way that I can use the backup .sql file so that I can see the posts that were entered and maybe import them into the current installation of WordPress? I don’t mind copy and pasting as long as I can see the posts.

    I have tried installing the old code and then overwriting the database but that just gives me a blank screen.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Lalit Nagrath

    (@laliz)

    10 years, 4 months ago

    I have tried installing the old code and then overwriting the database but that just gives me a blank screen.

    was this on home page of website or in wp-admin screen was white too?

    if you can access wp-admin after importing, go to posts and check if old posts are there. white page on front page can be due to theme, go to themes and reselct a theme.

    to import .sql files you should use mysql or phpmyadmin.
    http://codex.ww.wp.xz.cn/Restoring_Your_Database_From_Backup

    Thread Starter mariafgp

    (@mariafgp)

    10 years, 4 months ago

    I tried everything suggested. It didn’t work. I think since the .sql file is so old there may not be anything in there worth saving. I gave a brand new up to date WordPress blog. She will have to start posting from scratch.

    yenuel

    (@yenuel)

    10 years, 2 months ago

    I am kind of new here and this post is a month old. So i don’t know the site’s rule about that. But for others who might find this post in the future.. .
    I encountered the exact same problem today. Where importing will be successful, but the website just disappears, With no error code white page and no title. as it turns out the problem is with the wp_options table. So if you want to recover your posts, pages, links, menus and just all of your data except for your general settings such as site title and theme options, such as where your menus appear And how your website looks, make a copy of your sql file and open it in a notepad++ or other text editor and delete wp_options, all of it. I am currently looking at the wp_options code to find the exact problem so you may recover the wp_options table too so keep the original sql … But you can use this method to import your other data.

    Cheers

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

The topic ‘Help with importing .sql file’ is closed to new replies.