Trying to Migrate PHP and My SQL Website.

[Spooter]

Hi all,

I am trying to migrate a PHP website onto a new server, in a new domain. I have installed the same version of EasyPHP and copied the files from old server onto the new one.

I am able to browse the old site but if I try and access any page that pulls data from the My SQL database I get access denied. I think this makes sense as I will be using different credentials now. My question is how do I manage My SQL and the permissions used to access it? I have never used My SQL before.

If I browse into the EasyPHP folder there is a My SQL folder and the below subfolders. I presume this is the database!!?

Structure

My SQL
Bin
data
docs
share

Inside the data folder there is a number of MYD, FRM, and MYI files.

Is there away I can install Adminer and gain access to the database and manage it this way.

As you can probably tell im stuck and lack experience in the database area.

Any questions let me know.

 

[zetec452]

How did you migrate the data from MySQL? Backup and restore or did you just copy the DB files over?

 

[Spooter]

They were provided to me by data drive so I believe they were just copied.

 

[accod]

Those files are your database. Take a second copy of them before you muck about getting them to work. See http://lists.mysql.com/mysql/197031 for how to import them. Is this a dedicated server with you as root? Have you installed mysql?

 

[daz]

Use PHP MyAdmin to export your SQL data from your current MySQL instance, and then use PHP MyAdmin to import on to your new instance.

 

[Spooter]

Thanks for the replies gents. Ive had some good luck with this and got the database stuff sorted. Ill post up my steps tomorrow.