Dumping remote DB

2003-01-10 Thread Cesar Aracena
Hi all,

I use MyCC 0.8.6 to work around remote data bases, and I need to dump
the structures of all of them (also their contents). Can it be done?
What SQL query should I use?

Thanks in advance,

Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Dumping remote DB

2003-01-10 Thread Paul DuBois
At 13:53 -0300 1/10/03, Cesar Aracena wrote:

Hi all,

I use MyCC 0.8.6 to work around remote data bases, and I need to dump
the structures of all of them (also their contents). Can it be done?
What SQL query should I use?


Why not use mysqldump?  That's what it's for?



Thanks in advance,

Cesar L. Aracena
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(0299) 156-356688
Neuquén (8300) Capital
Argentina


sql, query

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Dumping remote DB

2003-01-10 Thread Zak Greant
On Fri, Jan 10, 2003 at 01:53:55PM -0300, Cesar Aracena wrote:
 Hi all,
 
 I use MyCC 0.8.6 to work around remote data bases, and I need to dump
 the structures of all of them (also their contents). Can it be done?
 What SQL query should I use?

  Hello Cesar,

  Use the mysqldump utility.

  % mysqldump --host mysql.example.com

  For more information, see: http://www.mysql.com/doc/en/mysqldump.html


  Cheers!
-- 
 Zak Greant [EMAIL PROTECTED] | MySQL Advocate |  http://zak.fooassociates.com

MySQL User Conference and Expo
  April 10-12, 2003, San Jose, California
  Visit http://mysql.com/training for more information

Public Service Announcement:  Open Source Initiative (http://www.opensource.org)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php