Nov 21

Tagged in: Comments:Add

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

export database

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").

export database

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.

export database

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.

export database

6. Done

Go to your website and everything should work perfect.

Delicious Stumbleupon Digg

Building Custom WordPress Theme Best of CSS Design 2008

Comments

Pages: 14 13 12 11 10 9 8 7 6 5 41 » Show All

There are 138 comments (+Add)

  • 138 Graphist http://animators.ir

    your website theme is very beautiful.
    thanks for content.

  • 137 slim http://qtemplate.org

    喜欢你们的设计与技术. thanks

  • 136 online stock trading advice http://community.bsu.edu/members/Online_Stock_Trading.asp

    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

    喜欢你们的设计与技术,常来看看

  • 134 australian real estate http://www.propertynow.com.au

    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

    great job bro thanks

  • 132 Doug C. http://dougdraws.com

    There’s no widgets in the GlossyBlue theme. Bummer.

  • 131 panel radyatör http://panel-radyator.blogspot.com

    nice tutorial i will translate my language

  • 130 pyemachine

    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

    Thanks for sharing. Helped a lot.

Pages: 14 13 12 11 10 9 8 7 6 5 41 » Show All

Post Your Comments

(required)

(required)

Comment Guidelines

  • Please keep comments related to topic. And be nice, don't spam!
  • Basic HTML tags are allowed:
    <a href> <abbr> <acronym> <blockquote> <code> <em> <strike> <strong>
  • Note: un-related or spam comments will be deleted.

Live Comment Preview

Back to top