How to copy MySQL database from provider?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Netman
Forum Newbie
Posts: 2
Joined: Mon Mar 24, 2008 7:10 pm

How to copy MySQL database from provider?

Post 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?
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: How to copy MySQL database from provider?

Post by Christopher »

SELECT INTO OUTFILE and then LOAD DATA INFILE. Check the manual for the syntax.
(#10850)
Netman
Forum Newbie
Posts: 2
Joined: Mon Mar 24, 2008 7:10 pm

Re: How to copy MySQL database from provider?

Post by Netman »

Hello again. Thanx to all!
Finally I found a solution:
http://www.web-console.org/upload_downl ... eb_server/
calfellows
Forum Newbie
Posts: 10
Joined: Mon Apr 07, 2008 3:10 am

Re: How to copy MySQL database from provider?

Post by calfellows »

Download a free program called "Mysql Administrator",
runs from your pc, does auto backups and restores,
queries, the whole nine yards.
Cal
Post Reply