Re: Database dumps - Mark Matthews - com.mysql.lists.java

9 messages in com.mysql.lists.javaRe: Database dumps

From	Sent On	Attachments
Morten Norby Larsen	15 Dec 2002 11:41
Mark Matthews	15 Dec 2002 11:59
Udkik	15 Dec 2002 13:27
Mark Matthews	15 Dec 2002 13:59
Udkik	15 Dec 2002 14:17
Mark Matthews	15 Dec 2002 14:24
Udkik	15 Dec 2002 14:35
Morten Norby Larsen	16 Dec 2002 11:21
Jeff Kilbride	16 Dec 2002 15:38

Subject:	Re: Database dumps
From:	Mark Matthews (ma...@mysql.com)
Date:	12/15/2002 02:24:26 PM
List:	com.mysql.lists.java

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Udkik wrote:

-----Original Message----- From: Mark Matthews [mailto:ma...@mysql.com]

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Udkik wrote:

Dear Mark,

I could use a UNLOAD DATA OUTFILE table 'dump' over the network too.

Kind Regards, Allan Unnerup

There isn't a command 'UNLOAD DATA' in MySQL. If you're referring to 'SELECT INTO OUTFILE', 'OUTFILE' ends up on the server, it doesn't travel over the network. See:

http://www.mysql.com/doc/en/SELECT.html

No, it doesn't travel over the network.

What I need is the opposite functionality of 'LOAD DATA INFILE', which *should* travel over the network.

Which doesn't exist, at least currently. However, it would be trivial to develop for any client (JDBC/libmysql/ODBC, etc), and in fact 'mysqldump' is a good example, if you disregard all of the options it can use. Is there a reason you just can't use 'mysqldump'?

-Mark

- -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

iD8DBQE9/QE6tvXNTca6JD8RAqz6AJ4ogvBdVXaCxeJzlgivTmKiYnuHwACcDWgA zo+GZlGJaNXfmjqxNhJ9XrE= =Wbvq -----END PGP SIGNATURE-----