Title: .sql file import issue in phpMyAdmin
Last modified: August 19, 2016

---

# .sql file import issue in phpMyAdmin

 *  [meeresfarben](https://wordpress.org/support/users/meeresfarben/)
 * (@meeresfarben)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/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)

 *  [figaro](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/sql-file-import-issue-in-phpmyadmin/#post-972831)
 * 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.
 * [http://educhalk.org/blog/?p=125](http://educhalk.org/blog/?p=125)
 *  Thread Starter [meeresfarben](https://wordpress.org/support/users/meeresfarben/)
 * (@meeresfarben)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/sql-file-import-issue-in-phpmyadmin/#post-972847)
 * 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!
 *  [figaro](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/sql-file-import-issue-in-phpmyadmin/#post-972859)
 * 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](https://wordpress.org/support/users/meeresfarben/)
 * (@meeresfarben)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/sql-file-import-issue-in-phpmyadmin/#post-972878)
 * 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?
 *  [figaro](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/sql-file-import-issue-in-phpmyadmin/#post-972882)
 * 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.
 * [http://educhalk.org/blog/?p=50](http://educhalk.org/blog/?p=50)
 *  Thread Starter [meeresfarben](https://wordpress.org/support/users/meeresfarben/)
 * (@meeresfarben)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/sql-file-import-issue-in-phpmyadmin/#post-972902)
 * 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.
 *  [figaro](https://wordpress.org/support/users/figaro/)
 * (@figaro)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/sql-file-import-issue-in-phpmyadmin/#post-972906)
 * 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.

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 7 replies
 * 2 participants
 * Last reply from: [figaro](https://wordpress.org/support/users/figaro/)
 * Last activity: [17 years, 3 months ago](https://wordpress.org/support/topic/sql-file-import-issue-in-phpmyadmin/#post-972906)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics