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: