Title: import sql into local wp installation
Last modified: August 18, 2016

---

# import sql into local wp installation

 *  [outchy](https://wordpress.org/support/users/outchy/)
 * (@outchy)
 * [20 years, 10 months ago](https://wordpress.org/support/topic/import-sql-into-local-wp-installation/)
 * i’ve searched the other posts on this matter but haven’t been able to find an
   answer to this specific question:
 * last night, i installed a clean version of wordpress 1.5 locally on my mac powerbook
   so i could test out the new features and everything is up and running fine with
   the one default post showing. now, i just want to import my backup .sql database
   so i can see all of my old posts but i don’t know how to do so. i tried some 
   plugins but i couldn’t get them to work, nor could i find a good answer on the
   internet.
 * now my real blog on the net is running on wordpress 1.2.1 on a remote server 
   and last night, i went into phpadmin and successfully exported a .sql backup 
   file. is there an easy way to just import that .sql file locally on my mac localhost
   installation? does anyone know a terminal command or something like that to interact
   with mysql? i know nothing about this but i really need to verify that my backup
   is complete and that i can in fact go from 1.2 to 1.5 without issue.
 * thanks so much.

Viewing 1 replies (of 1 total)

 *  [viper007bond](https://wordpress.org/support/users/viper007bond/)
 * (@viper007bond)
 * [20 years, 10 months ago](https://wordpress.org/support/topic/import-sql-into-local-wp-installation/#post-248866)
 * Well, I doubt your 1.2.1 posts table will be compatible with 1.5.x.
 * But you can either import it via PHPMyAdmin, command line (dunno how to do that
   with a Mac), or as a last resort, via a PHP file, but that’s a PITA.

Viewing 1 replies (of 1 total)

The topic ‘import sql into local wp installation’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [viper007bond](https://wordpress.org/support/users/viper007bond/)
 * Last activity: [20 years, 10 months ago](https://wordpress.org/support/topic/import-sql-into-local-wp-installation/#post-248866)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics