Did you ever experienced hard times trying to get your hand crafted Wordpress website transferred from your local test environment to the destination server? Did you spend countless hours trying to make things work? If you can answer yes to these questions then this article is for you. I’ll explain in plain English how to make a smooth transition from you localhost to the destination server.
Before we begin, I need to make some assumptions:
- You have your website working perfectly on your local machine.
- Local environment is either a PC or Mac on which you run a web server with PHP and a MySQL database and you have access to phpMyAdmin.
- Destination server runs Apache or IIS, you have FTP details, access to phpMyAdmin, database server name, database name, database user name & password.
- Other configurations may work as well.
- It doesn’t matter which version of Wordpress you are using.
- Export your local Wordpress database to a text file.
- Search and replace http://localhost/yoursite with http://www.yoursite.com
- Create a database on your destination server and import your database.
- Copy all files from your local machine to destination server and amend wp-config.php file with new database details.
- If necessary change file and folders permissions so Wordpress will be able to use them.
Step 1 – Export Local Database To Text File
Open up your browser and access phpMyAdmin and select your website database from the drop down box on the left. This may look like this:
Step 1a (click to enlarge)
Click ‘Select All’ in the Export form. All tables should be selected now. Leave other options as they are. Navigate to the bottom and tick ‘Save as file’ checkbox. Click ‘Go’.
Step 1b (click to enlarge)
Step 1c (click to enlarge)
Step 1d (click to enlarge)
Step 2 – Search & Replace
Now, we have to change your database export file and find & replace all URLs that contain http://localhost/yoursite with http://www.yoursite.comI’m using Dreamweaver but you can use any text editor to do the same.
Step 2a (click to enlarge)
C:\\Program
Files\\xampp\\htdocs\\yoursite/wp-content/uploads and strip it down to
/wp-content/uploads and finally save your SQL file.
Step 2b (click to enlarge)
Step 3 – Import Information Into Destination Server Database
On your destination server you have to create database for your WP installation. It may look like this screen below (assuming you’ll be using phpMyAdmin) However in most cases you’ll have to log onto your server administration panel and create database, user and password from there. It varies from provider to provider so please refer to your hosting provider help section.
Step 3a (click to enlarge)
Step 3b (click to enlarge)
Step 3c (click to enlarge)
Step 4 – Upload Wordpress Files
In this step you should use your favourite FTP client to upload all files to your destination server. If you created a brand new website than you can upload everything including index.php file. If you upgrading an existing website then you have to make sure that it will work until you launch your WP website. DON’T DELETE ANY FILES that belongs to your existing website. Make sure your Wordpress website works first, then you’re safe to delete the old files.To make your website work you should update wp-config.php file with your database details: database name, database server address, database user and password. Once done, you should be able to see your new website at http://www.yoursite.com/
Now, you have to test if you can login to the administration panel. So type in http://www.yoursite.com/wp-admin/ to find out. If you can see WP admin login screen you’re half way there. Type in your login details and login. If you’re successfull you should see WP Dashboard.
That’s it. You’re done.
Step 5 – Fine Tuning your Wordpress website
Few other thing you should take care of:- Make sure that you can upload any new images or documents. If you can’t it means that you have to change files/folders permissions and give Wordpress read/write right for necessary folders.
- Check if your permalink structure works. Amend if necessary.
- Make sure you’re running the latest version of Wordpress and upgrade automatically to the newest one where possible.
- Check if you have installed latest versions of any plugins that you’re using. Be careful though! Some plugins require PHP5 to work properly or require additional libraries to be enabled. Check this prior to any upgrades.
