I recently found this quick and easy tutorial on installing XAMPP Lite locally on Windows XP. This provides a great environment for testing and developing WordPress websites from your PC. The next logical step is converting this nice local installation into a live site as quickly and easily as possible. I found some excellent instructions from The Tamba2 WordPress Guides. These guides contain almost all the information used in this tutorial. I really just combined a bunch of the provided information to accomplish this specific task. I put all the instructions together here in a quick, and (hopefully) easy to follow tutorial. Let’s get started.
Prepare Your Database
Backup your local XAMPP MySQL database using the WordPress Backup Plugin. If you have the latest version of WordPress (2.03) this plugin is included. Just login to your WordPress Admin area, activate the plugin, go to Manage, and download a backup.
Find and isolate your *.sql file by unzipping the backup you just created.
Use SCR(a simple program that will search a large document and find and replace text) to search your *.sql file and replace all instances of
Save and close your SQL file.
Note: You could also use the find and replace feature in Wordpad if your database isn’t very large.
Log on to your hosting account or your webserver and create a new MySQL database for WordPress, call it whatever you want.
Once you have created your new database, find PHPMyAdmin, and open it.
Click the name of the database you just created from the dropdown menu.
At the top of the screen it should say “Server: your_server(probably localhost) Database: your_database_name”
Click the Import Tab.
Now click the Browse Button and browse to the location where you saved your *.sql file in the first part of the tutorial.
Click Go at the bottom.
You should get a message at the top stating: “Import has been successfully finished, XXX queries executed.”
Your new database is now ready to go, exit PHPMyAdmin.
Important: If you are importing an extremely large database, over 5MB, you may suffer from a timeout and failed import. If this is the case you need to manually upload your data in parts. See Podz detailed instructions for restoring if you are having this problem
Edit, Upload, and Go!
Browse to your local WordPress installation.
Open up your
wp-config.php file and input the MySQL details (username, password, etc.) of the new database you created in the previous step.
Note: If you want to continue using your local installation you will need to change wp-config.php back to what it was originally. You could also save a copy before editing.
Save and close
Upload the ENTIRE contents of your local WordPress folder to the new location on your webserver. This new location
should must be the same one you used in the first part of this tutorial when making changes to your *.sql file. This is important. If the locations are different, it will not work.
Your done, navigate to your new “live” WordPress powered website and enjoy.