"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
--
For technical support contracts, goto
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 data by re
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.
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
I think you need the -T option, which will break out table data to
separate files. Here's a description from the manual:
-T, --tab=path-to-some-directory
Creates a table_name.sql file, that contains the SQL CREATE commands,
and a table_name.txt file, that contains the data, for each give table.
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
