Nov 232014

Test Your WordPress Site Locally Import Database tutorial will show you how to import your database using phpMyAdmin and more.

Last Updated: August 17, 2017

Latest News: I have corrected a typo error in Step 3 ) below thanks to Artus for spotting this. I changed the wording to wp-config.php file.

Important Information: These steps can be applied to just about any WordPress backup plugin as long as the backup is a full backup which includes all the files, folders and the database.

Test Your WordPress Site Locally Import Database Steps

Step 1 ) This is the database file I am going to import, yours will look something similar. Remember that BackWPup always adds the database file to the root of your WordPress website when you create a backup. See image below.


Step 2 ) You can see the file path entered here. Click on Go to import the database. See image below.


Step 3 ) If everything goes well, you should see a message like this. Notice the prefix ‘k4oqobp_‘. I need to add this to the wp-config.php file later on.

Note: You probably will have a different prefix to add to your wp-config.php file.


Step 4 ) There are some changes that need to modified before you try to log in or run your website locally. In my installation I selected the following table k40q0bp_options for editing, you will have to do the same. See image below.


Step 5 ) The following image shows you the new path, http://localhost/wordpress/.

(Note: Your home path will be different, please check the following URL Install WordPress Locally Using Xampp and read Step 6 to learn more).

Note: http://localhost is the root of Xampp server. 


Step 6 ) I am also going to change the home path Click on number 2 to view more options on this table. See image below.


Step 7 ) Make the same changes to this field as you did previously. Change the path to the following: http://localhost/wordpress/. See image below.


Click on the following URL Edit WP Config File to continue with the set up.

If you have any question please let me know. I will be updating this tutorial from time to time so come back for the latest.

I hope this tutorial helps you.


Xampp Tutorial List:

Manuel Ballesta RuizManuel Ballesta Ruiz is a web developer, Blogger and WordPress Enthusiast.

  2 Responses to “Test Your WordPress Site Locally Import Database”

  1. Shouldn’t you change the database prefix in wp-config.php instead of wp-admin.php like you said above?

    • Hi Artus, thank you for spotting that typo error. Yes you are correct you add the database prefix in wp-config.php file.

      Kind regards

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>