WampServer

Hi all,

Thanks for reading this. I have got a bit of a strange problem. My WAMPsever was not starting (stayed orange and did not go to green), so being grown up in a windows world I just uninstall the softward and reinstalled it. Of course it not helo and I finally found out that that the famous port 80 was busy.
So I finally got ti to green now my Wordpress website are giving the “database connection error”. I checked myphp admin and it shows that all my database are gone. Howver I found them somewhere and I tried importing them. This is what I am not able to do. How do I import existing databases for my wordpress website into myphp?

My thanks,
Nav

Go to your live site and EXPORT the dayabase in SQL format you should receive the backup as a download.

Save that file on your disk

Run phpMyAdmin
1. create the database with the same name as live site
2. create the user account and give it the same name and password as live site
3. give the user account privilages on the newly created database
4. IMPORT the downloaded EXPORT

If the file is to large for phpMyAdmin to handle ( it happens often )

Use the wampmanager->MySQL->MySQL Console

Then run the IMPORT using these statements

>use [your database name]
>source c:\folder\your\backup\is\in.sql

The source command loads and executes the file.