There are many ways to import wordpress database in which we can import wordpress database from cpanel by going to phpmyadmin, other way is writing a php code with SQL query to import database. As we are using wordpress we have many facilities in it to import wordpress database. There are many plugins which we can use to import database. But one which i would recommend to use is wordpress importer.
WordPress Importer
Please see installation notes on plugin page, and install into your wordpress then go to plugin page and import your database. Save database to your computer or server for backup or importing to other site.
Why do we import database?
There are many reasons we import database but the most common reasons are.
- To save a backup of our site so we do not lost any data like posts, pages, comments and other information about site.
- To move our site we need to import database from one site to another site that’s why we import from old server and export to new server.
- To send copy of our database someone so they can get help from database structure.
- If we are testing our site or reinstalling wordpress we make a database import to save our database cause we dont want to lost any data of our site.