View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 11:29 AM
yawnmoth
 
Posts: n/a
Default 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!

Reply With Quote