Re: getting a list of all databases in a comma delineated format? On Nov 5, 1:55 pm, "Radoulov, Dimitre" <cichomit...@gmail.com> wrote:
> 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
I didn't know about that, heh. Thanks! |