I have the following problem :

I have been asked to redevelop a clients website which is written in PHP and uses MySQL as the backend. This site is on a remote server so there is only so much I can do with it.
They want me to move it to a Windows box in our office and convert the pages to asp but retain the backend.

I have installed a copy of MySQL on our windows box (SQL Yog front end) and have downloaded the pages.

The problem I have is getting to the data.

How can I extract the database from the remote server and set it up on my local Windows version of MySQL ?

I am fairly new to MySQL and would appreciate any tips any of you can give me.

Thanks in Advance