wpvidZ

Learn WordPress With Video Tutorials

  • Blog
  • Browse
    • Backup & Restore
    • WordPress Localhost
    • WordPress Hosting
    • WordPress themes
    • Version Updates
    • Plugin Tips
    • Security
    • Tutorials
    • WordPress SEO
    • WP Miscellaneous
    • Sitemap
  • WP 5+ Tutorial
  • Search
wpvidZ Blog Tutorials Copy “Live” WordPress Blog To Computer

Tutorials

Copy “Live” WordPress Blog To Computer

Last updated on February 18, 2017
Posted on July 21, 2010

How to copy the whole post and contents of your “live online” wordpress blog to your local server of your computer.

If you are curious and want to apply something new to your online website in your wordpress blog which is installed locally in your PC, you can of course copy your online blog.

In the tutorial i am using bigdump, because i am sure your online site has big size of database.


You need to have these two stuff done before we begin.

1. Save .sql file in your desktop, if you haven’t, follow this video tutorial, how to back up your database and save the .sql file to desktop.

2. Install wordpress locally, in windows or mac.

3. Close all browsers which are connected with your “real live” online blog, to avoid dropping database mistake. So we will be only concentrated on local server.

  • Is my site loading fast? I use this shared hosting
  • Try my theme >

Let’s start!

1. Download bigdump. And save it to your desktop. Extract this bigdump.zip file, and you will have bigdump.php file.

Bigdump Website.

2. Create a new folder in your desktop, name it “bigdump”.

3. Drag then drop bigdump.php and .sql file into “bigdump” folder.

Drag those two files into the bigdump folder.

4. Inside this bigdump folder, open bigdump.php with text editor (I use notepad++) and find line 39, fill the database name, username, and password. If you don’t know these three, open up wp-config.php of your installed wordpress local blog (line 19).

If your localhost is different, then change the line 38 too. But it is mostly left by default which is “localhost”.

Editing bigdump.php

Next still in bigdump.php, find line 66, and type in “utf8” next to $db_connection_charset. (see image for the final result).

Where to type utf8

Click “Save”.

5. Edit the sql file (your database backup) with notepad++. Find your live blog’s URL and replace it with localhost URL.

Example: find, http://www.yourdomain.com
replace it with http://localhost/wordpresslocal

All without “slash”.

Click “Replace All”.

Find and Replace URL

6. Next step is move “bigdump” folder to the folder where you installed wordpress locally (same root as wp-config.php).

Move bigdump folder to where wp-config is.

7. Drop the database that you use to install wordpress by opening phpMyAdmin page. It can be found in wampserver icon in the right bottom of your screen, and click once, you should see phpmyAdmin option, select it to open in your browser.

To open phpmyadmin in your browser

To drop, be sure you are in the right database, and click “select all” and in pull down menu, “with selected” select “drop”. Hit “Yes”.

Dropping the right database.

8. Open your web browser, type in: http://localhost/wordpressfolderwhereitisinstalled/bigdump/bigdump.php

Replace wordpressfolderwhereitisinstalled with the folder name, in this case, wordpresslocal.

You should see your sql file, and click “start import”.

Wait until the “Congratulations” message appears, it depends on your sql file size.

Import the sql file.

9. Refresh your local wordpress blog page. It usually displays installation page. Time to check your database table prefix, and double check your wp-config.php line 62. Edit this line to the new table prefix. Save wp-comfig.php.

Checking table prefix if installation page shows up.

10. Refresh your local blog, and it usually displays white screen. This is because your online blog’s theme you don’t have it in your computer.

11. Next step login to your admin page, note your username and password have to be the same as in live online blog.

12. Once you are in Admin page, go to Appearance/themes, and choose your theme. If you want to have different theme, simply move the folder of your theme in wp-content/themes inside the “www” folder where you installed wordpress locally.

13. Refresh your local blog, and it should have same content as your live blog.

Goodluck!

Video Tutorial:

Copy local pc to Wordpress

Latest Posts

  • Twenty Nineteen Theme Full Tutorial – Creating a Website
  • Uninstall W3 Total Cache Plugin – Incredibly Easy!
  • Create WordPress Website 2018 on SiteGround Genesis
  • WordPress Noopener Noreferrer Rel Attribute Quick Fix
  • WordPress CDN Setup with MaxCDN and W3 Total Cache Plugin
  • Twenty Seventeen One Page Parallax Scrolling Website Style
  • How To Add Google Map in WordPress Contact Page
  • WordPress 4.7 Justify Text and Underline
  • Twenty Seventeen Footer “Proudly Powered By WordPress” Text
  • How To Add YouTube Subscribe Button To WordPress Website
← Get Your Blog Indexed By Bing
→ Make Summary Post In WordPress Blog Homepage

Comments

  1. Aileen says

    July 22, 2010 at 12:41 am

    This is brilliant! I’m sharing it every where! It can be scary making a change on the live blog and by having a copy of it, I can see it exactly as it will look on my live site and it’s okay to make big mistakes on my computer version. It’s awful to have our blog site down because we made a mistake (fatal error) and that’s what makes this BRILLIANT! Thank you!!!

    • Kimi says

      July 22, 2010 at 7:10 am

      @Aileen, Hey there 🙂

      I am glad you made it! Good luck with the new coming theme.

  2. Shen says

    December 22, 2010 at 4:24 am

    Thank you so much!!!!!!!!!!!!!
    : )

  3. Roch says

    April 16, 2011 at 4:05 am

    What I am looking to do is similar. I am looking to have a static page as well as the blog appear on the main page of my wordpress site. Right now going to the settings section will only allow me to do one or the other. any feedback would be appreciated. Is there a special PHP INCLUDE tag I should be using for both to appear?

    • Kimi says

      April 17, 2011 at 7:26 am

      Hello Roch,

      I don’t really get what you meant..

      If you mean you want to have static page and blog page on your navigations, this post may help, also depending on your theme files:

      https://www.wpvidz.com/wordpress-change-home-page/

      Kimi.

  4. Michael Sandler says

    May 12, 2011 at 12:25 am

    Hi Kimi,

    You can delete the above post, I’m not sure how, but I’ve gotten past it. However, I’m now struggling with my dump size. My file is 37 mb and it says I can dump up to 32 mb.

    It says “alternatively you can upload your dump files of any size via FTP.” and then has a link to Dump file: (choose file). I’ve chosen the file and clicked “Upload” but cannot determine what to do next. (Nothing appears to happen)

    When I try starting my local installation of wordpress, it acts as if I’m reinstalling wordpress and gives me the “famous five minute WordPress installation process”.

    It doesn’t appear that it’s uploading my existing backed-up (from the internet) database. Any thoughts? Thanks again in advance and love your videos!

    • Kimi says

      May 12, 2011 at 6:45 pm

      Hi Michael,

      I have deleted the previous post as you wanted 🙂

      No, I haven’t encountered such problems, but then I am using Windows. I used to have a mac as well, but I sold it a few months ago LOL, so I have no idea how to fix it using Mac.

      Though I hope you are able to sort it by now.

      Thanks.

  5. maria says

    June 3, 2011 at 8:34 pm

    very usefull information on your site.. you must register your blog now so that you can get more trafic… do you have any face book account so that we can discuss computer related things on facebook platform
    if you change the theme of your site.. then your information will be easy to find and read
    thanks

  6. barak says

    May 28, 2012 at 3:54 pm

    very good
    i love youir article
    thank you very much

  7. prisha says

    June 6, 2012 at 1:07 pm

    thankx very help to me this article of copy live wordpress blog

    prisha

Comment form on this post is closed after 60 days.

Search

Worth Reading

  • WordPress CDN setupWordPress CDN Setup with MaxCDN and W3 Total Cache Plugin
  • WordPress Google maps in contact pageHow To Add Google Map in WordPress Contact Page
  • The configuration of YouTube Subscribe button in Google Developers web pageHow To Add YouTube Subscribe Button To WordPress Website
  • Adding Social Media Links to WordPress Menu With CSS Classes
  • Unable to create directory wp-content/uploads in WordPress
  • Forward Twitter to Facebook Using App and Feedburner Tutorial
  • Kitchen Sink WordPress - Seem Simple But Important
  • Admin Pointers, Drag and Drop WordPress 3.3 Media Upload Features
  • How to sell ebook in a wordpress blog?
  • Check your site's performance using Google labs Page Speed

Backup & Restore

Backup WordPress Without a Plugin or FTP

Export WordPress Database using phpMyAdmin

BigDump Alternative – When BigDump Failed Importing Large WP Database

At This Place The Current Query Includes More Than 300 Dump Lines

View All..

Live Online Website

View All..

Offline Installation

How to Upload WordPress localhost to live server manually

Steps to Install WordPress on Windows 8 and WAMP 2.4

Install WordPress on Mavericks OS X 2014

Maximum upload file size in WAMP WordPress

View All..


WPvidz Hosting Image

  • About Me
  • Contact
  • Affiliate Disclosure
  • Privacy Policy
  • Term of Use

Copyright© 2023 wpvidz.com SG2021 | sitemap.xml


WPvidz.com is independent from WordPress.org but is proudly powered by WordPress & its block-based editor (Gutenberg)

WpvidZ.com uses cookies" to give you the best browsing experience possible. If you click "I Accept" below then you are consenting to this. For more information about your privacy settings on this website, please visit the Privacy Policy page. I Accept