How To Restore Your WordPress Website Backup On Local Server Using WAMP

Restore Your WordPress Website Backup On Local Server


There’s plenty of interest in installing & developing WordPress locally but how about if you already have a live WordPress site? How do you transfer WordPress to your local PC or restore your site backup locally?





If you haven’t already installed your own XAMPP or WAMP server locally, you’ll need to do that first. In this tutorial, you’ll learn how to restore backup of your WordPress files and databases locally on your own PC to WAMP (Windows, Apache, MySQL, PHP)

You May Like Below Article

You can use this tutorial if you are using MAMP for Mac or LAMP (Linux)



Remote Server Backup

Backup Your Files

Using FTP or cPanel, simply create a backup of your files. The easiest way to do this is to download a backup of the entire folder your WordPress installation is located. Its normally named something like your site name and located in your public_html directory folder.

Tip: If you are using Cpanel or Unlimited FTP within cPanel, i suggest you download a zip version rather than .tar.


how to restore wordpress website backup local server using wamp codetherush hosting server file manager


Backup Your Database(s)

Using PhpMyAdmin in cPanel, create a database backup copy of your database(s) to your desktop

Local WAMP Restoration

Create a new database(s)

Using PHPMyAdmin in WAMP, simply create a new databaseuser while adding a new database and import your database backup.

WordPress Backup Folder

Drag or extract your WordPress files into WAMPS www directory. Left click the WAMP icon in your system tray and click www directory. If you’re using XAMPP navigate to this address in C drive:

XAMPP Locations: WordPress Local Folder: C:\xampp\htdocs

Create XAMPP Database: http://locahost/phpmyadmin/

WAMP Locations: Left click on the WAMP icon

Edit Config File

Try and use the same database name, username and password you used on your live server when creating a new database on WAMP otherwise you will have to edit the wp-config.php filewith your new database details.

Open wp-config and change the database name, username and password. Save changes

Edit PhpMyAdmin wp_options Table

PhpMyAdmin wp_options table

Here you’ll need to change 3 settings.

Site  URL – Change To http://localhost/wordpress/

Home URL  – Change To http://localhost/wordpress/

File upload_url Change to  http://localhost/wordpress/wp-content/images

Tip: Try the Search facility in PhpMyAdmin as you may have too many tables to find your File Upload_url settings


how to restore wordpress website backup local server using wamp codetherush php my admin


You May Also Like

About the Author: Ritesh Kumar

A web developer & the founder of CodeTheRush. You can follow me on the social media or subscribe the email newsletter for latest updates. I talk about Computer security and mostly publishes news articles about blogging tips, SEO, making money online , affiliate marketing & reviews.

Leave a Reply

Try below Search Bar to Search the best keyword.