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: 14 13 12 11 10 9 8 7 6 5 4 … 1 » Show All
There are 138 comments (+Add)
Pages: 14 13 12 11 10 9 8 7 6 5 4 … 1 » Show All
Loading ...
138 Graphist http://animators.ir
January 22nd, 2010 at 8:39 am
your website theme is very beautiful.
thanks for content.
137 slim http://qtemplate.org
January 11th, 2010 at 4:47 pm
喜欢你们的设计与技术. thanks
136 online stock trading advice http://community.bsu.edu/members/Online_Stock_Trading.asp
January 10th, 2010 at 6:39 pm
I don’t usually reply to posts but I will in this case, great info…I will add a backlink and bookmark your site. Keep up the good work!
I’m Out!
135 vincentdresses http://www.hibridal.com
January 6th, 2010 at 1:41 am
喜欢你们的设计与技术，常来看看
134 australian real estate http://www.propertynow.com.au
January 2nd, 2010 at 8:12 pm
Great info but my needs are simpler.Can you explain the basics of merely exporting a theme from ne of my existing blogs to my harddrive. I just want to be able to upload that same theme again and again. Thanks.
Andrew
Coffs Harbour Australia
133 panel radyatör http://panelradyator.wordpress.com
December 22nd, 2009 at 8:26 am
great job bro thanks
132 Doug C. http://dougdraws.com
December 21st, 2009 at 8:29 am
There’s no widgets in the GlossyBlue theme. Bummer.
131 panel radyatör http://panel-radyator.blogspot.com
December 15th, 2009 at 8:27 am
nice tutorial i will translate my language
130 pyemachine
December 8th, 2009 at 1:28 am
excellent help these articles. Created a wordpress theme and went from local to live based on these articles.
129 Zoho http://www.zoho.co.uk
December 1st, 2009 at 11:40 am
Thanks for sharing. Helped a lot.