If you cannot get file system access on the webserver, then you will need to dump the contents of the tables into a text file with the appropriate dump commands.
If the webserver has something like phpMyAdmin, you can use that to easily create a text file that you can then import into your mysql on your windows machine. Easiest, as I've said, ask the company that does the hosting to zip the tables in the data_dir and mail it to you, you would then simply create the DB and user on your machine, and drop the files into you data_dir ( all this assumes mysql ver 3.23.5x or higher and MyISAM tables, else, do the manual dumps) On Fri, 2003-07-11 at 15:36, Paul wrote: > 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 > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
