A good guide on Posting your offline local test Wordpress site to your online web server. Thank Revolution Media for this great info. It work for me, and I think it will for you too. The original post is
here
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.
Also, a quick
“executive summary” of all the steps below:
- 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)
Go to Export section (click on the Export tab at the top). Depend on
your version of the phpMyAdmin this section may look bit different but
the functionality will be the same.
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)
File save dialog will appear. Click OK and save that SQL file on your computer. Step 1 completed. Get yourself a coffee.
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.com
I’m using Dreamweaver but you can use any text editor to do the same.
Step 2a (click to enlarge)
We have to change another line as well. Find line
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)
Now as you have your database created you should populate it with your data. Click on the
Import tab at the top of the page. Click on
Browse in the ‘File to import’ section and select your amended SQL file. Click
Go to proceed.
Step 3b (click to enlarge)
If everything went well you should see table names on the left hand
side and a message saying something similar to this: ‘Import has been
successfully finished, 162 queries executed.’ You’re done and deserve
another coffee.
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.
