[CentOS] Question about dump on MySQL

[Todor Petkov]

On 11/08/2014 11:10 PM, Rodrigo Pichiñual Norin wrote:
> I need export an registers of a data base from command line.
> 
> It is possible with mysqldump?
> 
> for example:
> 
> mysqldump -u user -ppass db "select *from users where id=20" ???
> 
> 
> thank


Hi,

as I understand, you need to apply a 'WHERE' clause? It can be done like 
this:

mysqldump database table_bame --where="date_column BETWEEN '2012-07-01 
00:00:00' and '2012-12-01 00:00:00'"



Keep in mind, that this clause is valid only for table. I am not sure if 
you can use JOIN.


Regards,