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.
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.