.sql file import issue in phpMyAdmin

  • Hey everyone,
    I’ve been looking through some of the other posts relating to MySQL backups and stuff but couldn’t find an answer to my problem.

    I have old WP posts from an old website backed up as a .sql file on my hard drive. I would now like to add these old posts to a new website. This obviously doesn’t work in WordPress itself because it doesn’t support .sql import, so I checked phpMyAdmin but for some strange reason I could only find an export button and no import button.

    Does anyone know why that is? And what I could try to get to the posts in that .sql file?

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

  • Some hosts remove the import feature from phpMyAdmin…I was helping someone out a few weeks ago and ran across this…can’t remember who the host was.

    You may be able to get around this by using Bigdump. See a video here on importing large db’s using it.

    https://educhalk.org/blog/?p=125

    Thread Starter meeresfarben

    (@meeresfarben)

    Wow, thanks so much – worked perfectly!

    However, I now get a complete blank page when I try to access WP but I’m thinking this may have to do with my .sql file. It’s only about 600KB large which seems extremely small. Ugh, there may have been something wrong with the back up – as I said, it was done a couple of years ago, and I’m not sure how exactly it was done etc.

    But anyways, BigDump really helped! Thanks!

    You’re welcome…that is a small db, but is still reasonable for a small site without a lot of content…may just need to poke around a bit and experiment.

    Thread Starter meeresfarben

    (@meeresfarben)

    Hm okay, so when I try to access the wp-admin area, it tries to go back to the previous domain – it automatically goes to the old path. How do I “update” this?

    Well, since you asked ?? See the videos below…you will probably only need to watch the part about changing the url in the db since it looks like you have everything else done…that part is in the second video.

    https://educhalk.org/blog/?p=50

    Thread Starter meeresfarben

    (@meeresfarben)

    Oh, I actually knew the most of this. Duh. But I guess I found the problem because when I open the file no URL to replace ever appears anywhere. Now I’m no expert AT ALL (obviously) but it almost looks as though the database were – gasp! – empty. ?? I don’t know, I guess I’ll just have to play around some more and figure this out…

    But thanks again! Great site, by the way, I’m gonna have to save it. Heh.

    You’re welcome…you may just need to open the db in a text editor and take a look at it…at 600k something is there, but maybe not everything.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘.sql file import issue in phpMyAdmin’ is closed to new replies.