this workflow assumes you are using the WP-DB-Backup plugin (I highly recommend) to backups of your mysql/wordpress db. Also am assuming that you use the mysql gui tools to interact with your desktop db (also highly recommended)
- do a database backup with WP-DB-Backup
- optional: save the archived .gz in your backups folder, nested inside a dated directory, and expand here … you will need to expand this either way
- expand downloaded .gz if you didn’t do it in 1.1
- download wp folder (or whatever the name of your root install is) via ftp
- optional: download this into your backups folder, nested inside a dated directory. Copy the wp directory to your inetpub folder
- if haven’t already done so in 2.1, move wp directory into inetpub folder
- change permissions on this folder so that user has read/script execute permissions on all child objects
- open up mysql query browser
- make your wp schema default (or create one if you don’t already have a schema for wp)
- next, file > open script > [browse to path of (expanded) .sql file saved with WP-DB-Backup]
- execute this query
- inside the wp_options change the following parameters to equal your new localhost install rather than the previous web install
- siteurl
- home
- any other options from plugins which have an external path defined