Hai can anyone tell me how to restore wordpress dB? I just star my new personal blog and i want to restore the data from the previous blog THankx
Just login to MySQL and delete all the tables of the new wordpress db and then click Import. Then click the browse button and select the .sql file from your previous blog. Then, the data from your previous blog will be uploaded. If your new blog has a different URL, go to the options table and one page 1 and page 2 you will see the old URL. Click edit and replace the old URL with your new URL. This may help you a little bit: http://www.jwrmedia.com/how-to/how-to-backup-your-sql-database.html Its a tutorial about how to backup your database, but you can just read the steps and reverse them. Hope this helps.
There's two ways you can try; Restore with CPanel through the Cpanel - Backup icon. There is a browse button, you find your database and click restore. Or try phpMyadmin, there is an import button that will dump the tables into the new database.
Here. I just posted a new article. It will take you step-by-step and I've included a ton of screenshots: How To Move Wordpress To A New Server Or Host