{"id":169,"date":"2010-07-09T16:30:15","date_gmt":"2010-07-09T23:30:15","guid":{"rendered":"http:\/\/www.wellys.org\/wellysblog\/?p=169"},"modified":"2011-06-10T15:16:43","modified_gmt":"2011-06-10T22:16:43","slug":"riding-the-local","status":"publish","type":"post","link":"http:\/\/www.wellys.org\/wellysblog\/?p=169","title":{"rendered":"Riding the local… [UPDATED]"},"content":{"rendered":"

With the upgrade to Snow Leopard, I took the opportunity to make my MacBook Pro, a better development machine. This meant creating a Web server environment which matches my production shared hosting environment.<\/p>\n

Far easier said then done.<\/p>\n

I started with MAMP<\/a>. I wanted to have a complete server environment that is well supported by the community and was easy to maintain. I felt that MAMP met these goals better than going with the native OS X web environment. Apple hasn’t been the best at offering the latest stable release of Apache, MySQL (in fact, not supported at all) and PHP. MAMP offered all three plus PHPMyAdmin (handy at times) and a smattering of additional goodness.<\/p>\n

Using Sequel Pro<\/a> (a fantastic, freeware MySQL GUI), I was able to create the databases required for my films and WordPress. \u00c2\u00a0[A quick plug for Sequel Pro, they took the very nice code from CocoaMySQL and created a phenomenal tool. Well worth free, I gave them $50 for my copy, please donate if you can.]<\/p>\n

Changing the link references from my hosted version to a MAMP version wasn’t hard. Unfortunately, I wasn’t thinking clearly. Having a blank PHP page tends to do that… All the errors were mine. (Remember to put a closing slash on a directory link and MAMP references require a port number.)<\/p>\n

The hard part was duplicating WordPress. I finally kludged it by creating a fresh install of WP on MAMP then hand editing the WP database links to match my MAMP configuration. \u00c2\u00a0It’s working now but I’m worried about my first upgrade. I also had to go through my site and switch all references to a .com site to the localhost (MAMP) site.<\/p>\n

But at an absurdly high level to create a local WP site from a working hosted site:<\/p>\n

    \n
  1. Install MAMP<\/li>\n
  2. Fresh install WP onto MAMP site<\/li>\n
  3. Copy the wp-content folder from the hosted site to the MAMP site<\/li>\n
  4. Export the hosted WP MySQL database and import it into the MAMP MySQL database<\/li>\n
  5. Hand edit the links in the “-options” table to match those required for the MAMP site (remember to edit the uploads option as well)<\/li>\n
  6. Test. I turned off my wireless so I knew I was only local.<\/li>\n<\/ol>\n

    As soon as I finish this post, I’ll need to figure out how I’m going to duplicate this entry locally. I have two options, one, I could copy the text from my post page into the post page on the local site or two, export the hosted MySQL db and import it in to my local site. The latter would require me to hand edit the options page again. (or I could try keeping it the same). Mmmmmm.<\/p>\n

    UPDATE: Using two tabs on my browser, it took 30 seconds to duplicate the entry. Copy\/Paste, Copy\/Paste, click, click, click. That wasn’t so bad!<\/p>\n

    UPDATE July 8th, 2010: As I migrated to WordPress 3.0 locally (went from 2.84 to 3.0), I needed to reacquaint myself with using WordPress locally. Here are the directions in greater detail in updating WordPress locally (this is a personalization of the detailed upgrade installation on the WordPress Codex):<\/p>\n

      \n
    1. Backup MySQL database using Sequel Pro; File – Export – MySQL Dump (select all tables and make sure Drop Table, Create Table and Add Table Content are all selected. Use this backup to create backup MySQL database for the backup old installation, I called it oldBackup. Use the Database Administration part of Sequel Pro to create a new database then Import the dump.<\/li>\n
    2. Duplicate the oldblog directory using Finder – Duplicate then rename i.e; \u00e2\u0080\u009coldblog28\u00e2\u0080\u009d<\/li>\n
    3. Verify new site works by doing the following:\n