Import into MySQL

[venerable bede]

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

[mendhak]

Consult a doctor.

[mendhak]

OK, you'll probably have a backup feature in your phpmyadmin (or whatever the front end is). It creates a .SQL file which consists of, basically, a bunch of SQL statements that would be used to regenerate the database, all permissions, and all the data in there.

So, once you make a backup (look for the feature! a link, a button... something!), bring it over to your Windows box, and if you've got phpmyadmin running, use it to restore the databsare, or if you're using the command line interface, use mysqldump command.

What is your interface on the server, btw?

[mendhak]

If you have PHP and mySQL, I am assuming your interface is CPANEL and you most likely have phpMyAdmin.

In phpMyadmin, click on your database in the left column.
In the page that comes, click on "Export"

Choose "Structure and Data" "Save as File" "Complete Inserts" and click "GO".