Page 1 of 1

How to copy MySQL database from provider?

Posted: Tue Mar 25, 2008 1:47 pm
by Netman
Hello, I have huge database on web hosting provider server. I need copy that real database from provider to my local computer.
How can I copy database from provider to my local computer?

Re: How to copy MySQL database from provider?

Posted: Tue Mar 25, 2008 3:10 pm
by Christopher
SELECT INTO OUTFILE and then LOAD DATA INFILE. Check the manual for the syntax.

Re: How to copy MySQL database from provider?

Posted: Tue Mar 25, 2008 3:20 pm
by Netman
Hello again. Thanx to all!
Finally I found a solution:
http://www.web-console.org/upload_downl ... eb_server/

Re: How to copy MySQL database from provider?

Posted: Fri Apr 11, 2008 11:15 am
by calfellows
Download a free program called "Mysql Administrator",
runs from your pc, does auto backups and restores,
queries, the whole nine yards.
Cal