mysqldump with -where statement for windows (ver 3)

[bobb]

Here's the syntax, I've never been able to do this. I'm SURE it'll
help someone.!!!
mysqldump -hhost -uuser -ppassword -c -t -wfield=value (don't forget
quotes if string) database table > optionaltextfile.sql

bobb

[bobb]

Seems like I had always been (taught) able to put the -w AFTER the db
and table name in *nix...
This doesn't work in windows. That was always the problem.
could never find it anywhere.
Thanks.
Aggro <sp**********@yahoo.com> wrote in message news:<Uj**************@read3.inet.fi>...

bobb wrote:

Here's the syntax, I've never been able to do this. I'm SURE it'll
help someone.!!!
mysqldump -hhost -uuser -ppassword -c -t -wfield=value (don't forget
quotes if string) database table > optionaltextfile.sql

mysql> use test;
Database changed
mysql> select * from country;
+------+---------+
| id | name |
+------+---------+
| 1 | Finland |
| 2 | Sweden |
+------+---------+
2 rows in set (0.01 sec)
mysqldump -h localhost -u root -c -t -p -w'id=1' test country > res.sql
Enter password:

mysqldump -h localhost -u root -c -t -p -w'name="Finland"' test country

> res.sql

Both of these worked for me. Using version 3 also.

[Aggro]

bobb wrote:

Here's the syntax, I've never been able to do this. I'm SURE it'll
help someone.!!!
mysqldump -hhost -uuser -ppassword -c -t -wfield=value (don't forget
quotes if string) database table > optionaltextfile.sql
mysql> use test;
Database changed
mysql> select * from country;
+------+---------+
| id | name |
+------+---------+
| 1 | Finland |
| 2 | Sweden |
+------+---------+
2 rows in set (0.01 sec)
mysqldump -h localhost -u root -c -t -p -w'id=1' test country > res.sql
Enter password:

mysqldump -h localhost -u root -c -t -p -w'name="Finland"' test country res.sql

Both of these worked for me. Using version 3 also.

[bobb]

Seems like I had always been (taught) able to put the -w AFTER the db
and table name in *nix...
This doesn't work in windows. That was always the problem.
could never find it anywhere.
Thanks.
Aggro <sp**********@yahoo.com> wrote in message news:<Uj**************@read3.inet.fi>...

bobb wrote:

Here's the syntax, I've never been able to do this. I'm SURE it'll
help someone.!!!
mysqldump -hhost -uuser -ppassword -c -t -wfield=value (don't forget
quotes if string) database table > optionaltextfile.sql

mysql> use test;
Database changed
mysql> select * from country;
+------+---------+
| id | name |
+------+---------+
| 1 | Finland |
| 2 | Sweden |
+------+---------+
2 rows in set (0.01 sec)
mysqldump -h localhost -u root -c -t -p -w'id=1' test country > res.sql
Enter password:

mysqldump -h localhost -u root -c -t -p -w'name="Finland"' test country

> res.sql

Both of these worked for me. Using version 3 also.