Skip to content

Instantly share code, notes, and snippets.

@joshbeckman

joshbeckman/gist:ec331f2b57ac5fc975bb

Last active August 29, 2015 14:06
Show Gist options
  • Save joshbeckman/ec331f2b57ac5fc975bb to your computer and use it in GitHub Desktop.
Save joshbeckman/ec331f2b57ac5fc975bb to your computer and use it in GitHub Desktop.
Download ZIP
Steps to install a PROD WordPress MYSQL database locally in MAMP
Raw
gistfile1.md
  • Download Sequel Pro
  • Follow their instructions on connecting to MAMP
  • Run Sequel Pro
  • Create a new database (I suggest something like dump_import_<date>)
  • Select File > Import
  • Select your sql dump file
  • Wait like 15 minutes
  • Go in and change the necessary fields (like, site_urls, paths, etc) for every site and/or blog you want to work with
  • Edit the blogs to be in all the same network/site (MAMP doesn't handle multiple domains or path installs)
  • Open up your wp-config.php file and switch out the DB_NAME value to your newly-created database
  • Voila!

1: http://www.sequelpro.com/ 2: http://www.sequelpro.com/docs/Connecting_to_MAMP_or_XAMPP

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment