Re: [CentOS] Question about dump on MySQL

great!!

thank for your answers, it is very useful for me

Regards

2014-08-11 17:33 GMT-04:00 Todor Petkov zakk@online.bg:

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,

---

CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos