[quote author="CT Schubert” date="1298445266"
Once you are satisfied w/ the staging install, you will want to do the following.
Make sure you do this at a time that you are sure no one will be shopping on your store, perhaps really late at night or really early in the morning. Or put up a temporary index page. Either way, should be down for just a few minutes.
1. Create a new folder in the root called “backup” and copy your entire live store into that folder
2. Delete all of the files for the live store wherever they currently reside (again, MAKE SURE you have them copied to a backup folder just in case)
3. Move all of the files from the staging area to the folder the live site was in (so if the live site was in /public_html/ then move them there)
4. Login to phpmyadmin or whatever interface you use to access your databases and edit the core_config_data table and point the unsecure and secure urls to the new path (so if they were currently set to www.domain.com/staging/, rename them to www.domain.com/)
5. That should be it. Unless you have absolute paths being used anywhere in your template or your CSS, you shouldn’t have any template issues
6. Login to your admin and refresh all of the cache and re-index everything. Generate your sitemap, etc. Go through all the settings and make sure everything is fine.
Some side notes. If you were using a shipping extension that required a CSV file, make sure to re-upload that just in case. Run some verifications once the site is live. Signup as a new user, try to do a full checkout w/ payment going through (I had to re-input API/Transaction keys for one clients merchant account). Check to make sure existing customer accounts are working w/ passwords ,etc.
Hi, Just so I understand, using this method, the staging database that was created is now going to become the production database, correct?