Mysqldump help

[srijith c]

Hi all,
In mysqldump command is it possible to insert "sql conditions"?

So that i can dump the database which contains the data what i need.

Please help.....

Thanks

[Piyush Gupta]

-w, --where='where-condition' #Dump on selected records .

Regards,
Piyush Gupta
s : mba.piyushgupta
w: blog.thebrainpoint.com

[Subbu]

You can use --where option as Piyush suggested. Check out mysqldump documentation as well. It has quite a few options. http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

[srijith c]

Hi,
Thanks for quick help,

MySQLDump works great for the single table:
Ex:
mysqldump "--where=name='project1" " database1 projects  > backup.sql

But it is throwing error when i include another table  whichis having foreign key relation with the first table:
Ex:
mysqldump "--where=projects.name='project1'" "--where=sub_projects.foreignKey=projects.primaryKey" cap_db projects sub_projects > backup.sql

Error Trace:

mysqldump: mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `sub_projects` WHERE sub_projects.foreignKey=projects.primaryKey': Unknown column 'sub_projects.foreignKey' in 'where clause' (1054)
mysqldump: Got error: 1054: Unknown column 'sub_projects.foreignKey' in 'where clause' when retrieving data from server

Is it possible to include two tables which have a foreignkey relation in mysqldump?

Thanks

[Subbu]

Why not execute your query within mysql shell and the output the query results to an external file? This way you don't have to use mysqldump.