mysqldump help

[srijithc]

Hi all ,

 

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  which is 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