NYCPHP Meetup

[Dan Cech]

Faber Fedor wrote:
> On 28/10/04 22:57 -0400, Daniel Convissor wrote:
>>Hey Folks:
>>
>>mysqldump -A will export all of the databases.  But, what if I want to 
>>exclude a particular database?  Is it possible?  How, please?
> 
> Is there a way to A) list all the databases (databasi?), B) run the
> output through 'grep -v' and then C) mysqldump the result?

Assuming your db password is mypass, and the database you want to 
exclude is test, the following should do the trick:

mysql --password=mypass -B --skip-column-names -e'SHOW DATABASES' | grep 
-v 'test' | xargs -n 1 "mysqldump" "--password=mypass" > nottest.sql

Dan