How to restore wordpress database from backup?
You can restore a database from backup using phpMyAdmin. After you have logged in, click Databases and select the one you want to import data from. Then choose Import. Then click Browse and locate the backup file. Make sure the SQL radio button is checked and then click Go. It will take a little while to complete.