How about this? *mysqlhotcopy db_name /path/to/some/dir* I think you are also looking for HERE documents. Try pasting this at your unix command prompt:
*mysql > a.txt << EOF* *help* *EOF* knk On 8/8/08, Francisco Antonio Trujilho Filho <[EMAIL PROTECTED]> wrote: > > Hi to all. > > I need to do the backup of my MySQL's databases so I want do each > database in a separated file. > > I don't know how I can execute the commands: "show databases;" from > shell script. > > Does anyone know how I can get the database's names? > > Thank you, > Francisco Trujillho > > > > > -- knk
