RE: Remotely dumping data to a file

Can you use the -w/--where option in mysqldump to dump only the records you want? -Original Message- From: Tucker, Gabriel To: Mysql General (E-mail) Sent: 8/20/04 8:07 AM Subject: Remotely dumping data to a file Hi All I would like to dump certain data remotely from a table. I am

Remotely dumping data to a file

Hi All I would like to dump certain data remotely from a table. I am unable to use mysqldump because I do not want to dump the entire table. The "select into outfile" will not work when the connection is remote. I saw in the manual that "mysql -e" would do what I want. However, that is not true.

Re: Dumping data per request

"Teguh Kurniawan " <[EMAIL PROTECTED]> wrote: > Hi... > It's possible to dumping data by request. I mean it can limiting data dumping with > some condition. What about using --where option of mysqldump? http://dev.mysql.com/doc/mysql/en/mysqldump.html -- F

RE: Dumping data per request

If you use mysql dump you can use the --where= switch. Or you can use select into outfile syntax from within the mysql monitor. -Original Message- From: Teguh Kurniawan To: [EMAIL PROTECTED] Sent: 4/27/04 7:45 AM Subject: Dumping data per request Hi... It's possible to dumping da

Dumping data per request

Hi... It's possible to dumping data by request. I mean it can limiting data dumping with some condition. Thank's Teguh Lycos Email has 10 MB of FREE storage space. http://mail.lycos.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Connection Lost Dumping Data & Unexplained Pauses

Kind MySQL List, I need your help. I have an installation of replicated MySQL servers. I am migrating to new servers and upgraded MySQL software. My previous servers were RH8, MySQL 4.0.14. (A, B) My new servers are Fedora, MySQL 4.0.17. (C, D) Most of my critical data is built using INNODB tables.

Re: Dumping data

Hi Rob, I think there was a similar question today. Is "mysqldump -T" perhaps doing what you are looking for ? Best regards Nils Valentin Tokyo/Japan 2003年 6月 26日 木曜日 17:[EMAIL PROTECTED] さんは書きました: > Text1 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.

Dumping data

Text1Hi all, Is there any way to do a mysql dump in which each table is dumped into a separate file. I know I can use the --tables option to specify a table, but this means I have to type out each table name (and there are a lot of them). Is there any way to get mysql to automatically iterate th

Re: Dumping data

On 25-Jun-2003 Rob wrote: > Hi all, > > Is there any way to do a mysql dump in which each table is dumped into a > separate file. I know I can use the --tables option to specify a table, > but this means I have to type out each table name (and there are a lot > of them). Is there any way to get

RE: Dumping data

to create/write a file at the location you specify. You will also want to look at http://www.mysql.com/doc/en/mysqldump.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Rob [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 1:57 AM > To: My

Re: Dumping data

Hi, Try mysqldump -T: -T| --tab=... Creates tab separated textfile for each table to given path. (creates .sql and .txt files). NOTE: This only works if mysql‐ dump is run on the same machine as the mysqld daemon. This was taken from the man page. On Wed, 2003-06-25 at 08:56, Rob

Dumping data

Hi all, Is there any way to do a mysql dump in which each table is dumped into a separate file. I know I can use the --tables option to specify a table, but this means I have to type out each table name (and there are a lot of them). Is there any way to get mysql to automatically iterate through