Exporting and Importing WordPress Databse

Exporting and Importing WordPress

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.

Related posts:

  1. Install Multiple WordPress Installations Using a Single Database
  2. Multiple WordPress installations on a single database
  3. How to Change Absolute Links
  4. WordPress 1and1 Server 500 Internal Server Errors and NexGen Gallery
  5. WordPress URL directory Change
  6. WordPress 3.0.1 Image Upload Error
  7. Word Press Error 404
  8. How to decode encrypted WordPress footers
  9. WordPress Plugins I love
  10. WordPress Perma Links Setting
  11. How To Remove Author Details from posts In WordPress Blog
  12. Change Role Names or Add new Roles in WordPress
  13. Offering More Subscription Options
  14. How to make money as a welder and market your skill
  15. Tri-Magnum – R.Q. Riley
  16. VTR “S”
  17. WordPress
  18. Blogs
  19. FREE SOLAR PANELS – how to get them
  20. Private: Sites
  21. What is Net Metering?
  22. Webdesign
  23. Tips for using Google AdWords
  24. How to write popular and useful ehow articles

Leave a Reply