Nov 21
Exporting and Importing WordPress
In the last two chapters, I talked about Installing WordPress Locally and Building Custom WordPress Theme. This chapter will cover exporting your local WordPress to a web host. Assume you are done with the local WordPress development, it is time to learn how to export and import WordPress. Then you can keep the local version for backup purpose and future development (ie. testing new themes, plugins, and upgrades).
1. Export Local Database
Login to your local phpMyAdmin, select the database from the dropdown. Click on the Export tab:
- Under the Export field, make sure all tables are selected
- Under the Structure field, tick "Add DROP TABLE / DROP VIEW"
- Tick "Save as File"
- Then click Go and it will prompt you to download a SQL file
2. Find & Replace All Local URLs
Open the database SQL file with a text editor. Find and replace all local URLs with your domain URL (eg. replace all "http://localhost:8888/mysite" with "http://www.yourdomain.com").
3. Import The Database
Login to your server cPanel, go to MySQL Databases, create a new database and assign a user. Now go to phpMyAdmin, select the database (the one that was just created) from the dropdown, click on the Import tab, browse the SQL file and click Go.
4. Upload WordPress
Upload the entire WordPress folder to your server.
5. Change The wp-config.php Setting
On your server, open the wp-config.php file. Change the database details to reflect your server settings.
6. Done
Go to your website and everything should work perfect.
Building Custom WordPress Theme Best of CSS Design 2008
Comments
Pages: 7 6 5 4 3 2 1 » Show All
There are 64 comments (+Add)
Pages: 7 6 5 4 3 2 1 » Show All
Post Your Comments
Advertise Here
Loading ...
64 Web Designer http://www.raycreationsindia.com/
December 31st, 2008 at 3:35 pm
This is a very useful tutorial as I recommend everyone who has a word press theme to switch to your domain name because you never know when word press decides to reactivate your blog.
63 Salva
December 30th, 2008 at 10:18 pm
Dude “YOU ROCK SO HARD!!!”
I will vote my socks off for you - thanks for this great tutorial series.
62 manS http://www.fleedy.com
December 27th, 2008 at 1:03 pm
Tq very much for the tutorial… Great..
61 devlim.com http://www.devlim.com
December 24th, 2008 at 10:00 pm
Great tutorial, thank for teaching
60 joao http://www.joaobem.biz/blog
December 12th, 2008 at 5:49 pm
This actually is easier than it sounds.
my blog
59 David Costales http://blog.davidcostales.com
December 11th, 2008 at 6:43 am
Thanks for this entry!
58 Nneon http://nneon.net
December 11th, 2008 at 12:05 am
Scrap my last comment about writing an article about upgrading your version of wordpress…
With the release of Wordpress 2.7 it’s as simple as clicking a button
57 João Henrique Ferreira da Mata Ferreira da Mata
December 10th, 2008 at 7:12 am
Thanks Web Designer Wall !!!
http://www.swebstudio.com.br
56 charles http://tekrebeldesigns.com
December 8th, 2008 at 10:18 pm
wow what an awesome design!
55 osu
December 4th, 2008 at 11:04 am
Ah,
Stupid me, I didn’t read your tutorial properly! I see you’ve already mentioend about localhost!