How to restore Wordpress Database I changed my hosting a/c

Hello friends..

How do i restore my old database for my Wordpress blog ?? I downloaded the database from old host & uploaded in new host & tried to install WP manually did everything right including editing wp-config.php but when i start the installer it says

"Already Installed

You appear to have already installed WordPress. To reinstall please clear your old database tables first."

Solutions will be highly appreciated

Regards

Abhishek Daaga

 

You need to import the .sql file into the database that is pointing in your wp-config.php (assuming you have one pointing there). Once that is done your wordpress install should show up and there is no need to run an installer or anything like that.

 

Yea! InFloW is right.. should not have to run any installer, if your wp-config.php file is already pointed to the database.. It should come on live..

Or, It sounds like you may have done the procedure in reverse.. Tried to install wordpress over an existing database? What you can do is try this in the other direction.. Install a fresh new Worpress install.. than go in database and drop all the tables in that database.. Than import your old WP .sql file into the new database to make all the tables and populate them with the ones from your old Wordpress site.

Boulder

 

Install the wordpress first with new database name and user..
Go to phpmyadmin, click your wp database and then upload the old sql file.
Hope that helps

 

Thanks for this... I got the procedure... But now i m stuck with another problem.. My site www.abhishekspeaks.com is stuck with the hosting parking page... how to remove from it ??? i have deleted the index.html which contained that page then also the same page appearing.. even after i install WP through Fantastico the same hosting parking page is coming

 

You have no physical files in your root folder. You said you uploaded it, check you uploaded it to the correct folder. Like www, public_html etc.

And this is you have to do.....
MeetHere

 

actually i have deleted all the WP files... as after installation also.. it was showing the host parking page.. how to remove that page ??? i deleted the index.html page which contained the same page it is showing now

 

Try to upload a blank page named index.html

 

Did this... now i find blank page.. but will it work now if i install WP now ?

 

You have to upload the wordpress files. You can download it from www.wordpress.org/download/ . Then unzip wordpress zip file to computer and start uploading using FTP. Before uploading delete the just uploaded index.html file and postinfo file. I think you dont need to delete other files in the server root folder. For a backup, download all other files from your server root folder to your computer. In the wordpress zip file, you can find a readme file says about the installation procedure.

I think Fantastico did not installed wordpress...

 

Seems working: http://www.abhishekspeaks.com/

 

I deleted the index & postinfo file & installed WP & to see just the same page again that is saying site under construction how to remove that ????

 

Abhishek, I can see wordpress default site here. You have successfully installed it.... Try to check with any proxy site....

Here is your description that I found on your site : Abhishek Daaga Speaks what u like..

 

Wow... I think it takes some time to update... i did this same before posting on DP may be 10 times.... Atlast i did it Thanks to u.. ur good name plz..
REP added

 

Thanks for the rep. I am Sree Prakash. Same country....See my place.....

 

wordpress has explained it very simply
http://wordpress.org/support/topic/290774

 

You might need first to open the sql file using notepad and replace all instances of all domain with the new domain using CTRL + H.

 

Friends..........,
for you alllllllllllllll this will 99% help full to you......,

http://www.str-graphics.com/index.p...ackup-mysql-phpmyadmin-backup-mysql-database/