Title: phpMyAdmin Import
Last modified: August 19, 2016

---

# phpMyAdmin Import

 *  Resolved [johnathan1707](https://wordpress.org/support/users/johnathan1707/)
 * (@johnathan1707)
 * [16 years, 10 months ago](https://wordpress.org/support/topic/phpmyadmin-import/)
 * Hi, last night I reinstalled wordpress for a friend, before I did I made a backup
   up his wordpress database through phpMyAdmin. When I installed wordpress I went
   to import, chose the SQL file and went but it was rtaking a few hours and showed
   no signs of stopping so I stopped it and decided to put it in in chunks rather
   than in one big go.
    So about 8 hours ago I put in 600 lines or so of SQL, the
   part containing the blog posts and it’s still running. I was wondering if there’s
   a faster way to do this, the SQL file itself is around 2.5MB.
 * Thanks
    J.Barrett

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

 *  [whooami](https://wordpress.org/support/users/whooami/)
 * (@whooami)
 * [16 years, 10 months ago](https://wordpress.org/support/topic/phpmyadmin-import/#post-1162521)
 * sure, the faster way is to open the .sql file with a plain text editor, and copy
   and paste into the sql window.
 * if you look at the file, the breaks are pretty evident.
 * >  So about 8 hours ago I put in 600 lines or so of SQL, the part containing 
   > the blog posts and it’s still running.
 * i doubt that. you just arent aware that its either done, or timed out.
 * finally, you went to import where?
 * you cannot import .sql files into wordpress through the wp-admin interface, if
   thats what you are trying to do.
 * .sql dumps (backups) need to be imported through phpmyadmin or another tool that
   directly accesses the db.
 *  Thread Starter [johnathan1707](https://wordpress.org/support/users/johnathan1707/)
 * (@johnathan1707)
 * [16 years, 10 months ago](https://wordpress.org/support/topic/phpmyadmin-import/#post-1162551)
 * I use phpMyAdmin import. Left it for around an hour, stopped it and some of the
   tables had been created and populated.
    I done the text-editor way, left it for
   8 hours, might have times out be still appeared to be doing stuff. I got this
   sorted by going through the SQL and doing it in really small chunks, each table
   on it’s own and that worked.

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

The topic ‘phpMyAdmin Import’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [johnathan1707](https://wordpress.org/support/users/johnathan1707/)
 * Last activity: [16 years, 10 months ago](https://wordpress.org/support/topic/phpmyadmin-import/#post-1162551)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics