yawnmoth wrote:
> I'm trying to write a batch file that'll backup all my databases and
> had a question. I was thinking about executing SHOW Databases to get
> a list of all the databases and then use mysqldump on each one.
[...]

What's the problem with:

mysqldump --all-databases ...

If you want to select a few:

mysqldump -d $(mysql -NBe "show databases like '%pattern%'")


Dimitre