Question About Dump On MySQL

Home » CentOS » Question About Dump On MySQL
CentOS 4 Comments

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 ” ???

thank

4 thoughts on - Question About Dump On MySQL

  • No need for the pipe:

    mysql -u user -p $DATABASE -e “select * from users where id=20”

    NOTE: I did *not* type the password, the very fact that you can actually type the password in the command should be abolished from mysql cli

    Regards

  • 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,