[CentOS] Question about dump on MySQL

2014-08-11 Thread Rodrigo Pichiñual Norin
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 ___ CentOS mailing list CentOS@centos.org

Re: [CentOS] Question about dump on MySQL

2014-08-11 Thread Alan McRae
echo select * from users where id=20; | mysql -u user -ppass -Ddb Alan McRae On 12/08/2014 08:10, 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

Re: [CentOS] Question about dump on MySQL

2014-08-11 Thread Marc Deop Argemí
On Tuesday 12 August 2014 08:15:16 Alan McRae wrote: echo select * from users where id=20; | mysql -u user -ppass -Ddb Alan McRae On 12/08/2014 08:10, Rodrigo Pichiñual Norin wrote: I need export an registers of a data base from command line. It is possible with mysqldump? for

Re: [CentOS] Question about dump on MySQL

2014-08-11 Thread 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'

Re: [CentOS] Question about dump on MySQL

2014-08-11 Thread Rodrigo Pichiñual Norin
great!! thank for your answers, it is very useful for me Regards 2014-08-11 17:33 GMT-04:00 Todor Petkov z...@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: