5/26/2015 - 9:29 PM

2.5.15 MAMP PRO and manual install of WP 4.1

My notes

2.5.15 MAMP PRO and manual install of WP 4.1
• Configure new host in same way as in earlier version of MAMP
• Unzip latest version of WP and rename the unzipped folder something like deborahasbranddev and place inside Sites
• Create new DB with same name as development folder/local host name with _db suffix, like this: deborahasbranddev_db
• Copy the wp-config-sample.php file, rename wp-config and use the settings you see below:
Variable	    Value
DB_NAME	      deborahasbranddev_db
DB_USER	      root
DB_PASSWORD	  cya85Rugone
Editing Variables

• You don’t have to change anything else, at least yet. Later, check to make sure DB prefix matches the actual DB you’ve cloned from the live site.
• In MAMP PRO, click on site arrow to see in browser. Enter basic info, use admin/admin for username and password (this will change 
when you import the live site DB). This will finalize the WP install and you can now log in.
• htaccess file must be created manually; copy one from a live site, then:
Go to Permalinks and copy the content provided on the Permalinks page into a new .htaccess file (copy one from live site).
• Use wp-migrate-db plug-in to clone DB from live to local site. **NOTE: use wp-migrate-db v0.5, not 0.6.
• Remember to install live site’s CONTENT folder of themes and plug-ins. Use Duplicator or BUB to clone live site’s files.
• Backup Buddy migrate didn’t work for me when cloning to a local install, so that’s why I follow the above steps instead.

4.14.14 MAMP PRO v3.0.5 installed; has auto-installer for WP 3.5.1 (not the most current version); I had trouble updating WP with this method.
• Configure new host in same way as in earlier version of MAMP
• Click on "Extras" to install WP
• A new DB is automatically created by the MAMP PRO Extras installation process
• Check the wp-config.php file for the settings you see below (used to do this manually)
• Change /** MySQL hostname */ from localhost:3306 to just localhost, like this: define('DB_HOST', 'localhost');
• Log into new site manually (hostname/wp-login.php) - username & password = admin
• Go to local site Settings > General: change both WP address URL and site address URL to be without suffix ":80”
• Screen will go back to login page, with same default settings of admin. Log in again.
• Open both production and local wp sites. Install WP Migrate DB on local site simply by cloning plug-in files.
• Using WP Migrate DB, copy production db to local db.  Never, ever, change the contents of the GUID column, under any circumstances.
• Permalinks should be refreshed.
• Check prefix of db table on local dev site. Sometimes, it is installed as “wp”. Make a note of the prefix.
• Import production site’s db into local dev site
• Check the db again to see if there is an additional group of tables with a different prefix than the original one. 
• If so, open wp-config.php and change the prefix of the  db tables to match the newly imported production file's db 
$table_prefix  = 'wrd_’; (instead of ‘wp’)
• Local wp site user log-in will initially be local host info (admin-admin)., but changes to production login after db is imported.
• IMPORTANT: .htaccess file should be manually cloned, then edited per instrux. on Permalinks page.

Install WP inside new dev folder

11.19.13 THE BEST instructions for local WP install

• Set up new WP-dev folders and databases, using MAMP for local development.
--It's very important to have the MAMP server name match the folder name!
--It's also important to name the database with underscores, not space bands or hyphens!

• Using Duplicator plug-in, clone production files into .zip archive. Extract into new folder locally.
• Create new host, create new database
Host	localhost
Port	3306
User	root
Password	cya85Rug0ne

• If necessary, manually duplicate wp-config-sample to be wp-config; edit appropriate areas with above host, user, word info.

9.6.18 - Make a backup of site with BUB
- In Mamp Pro, install WP 4.0 using the Extras tab
- Log into Mamp Pro default site
- Install WP Migrate DB on BOTH sites
- Copy the URL paths from the local site to the production site
- Export the db
- Import the db into local site