Outputting name of db's to text file

[ryankbrown@gmail.com]

I am looking for a way to output the results of the mysqlshow command
to a text file. I can probably manage this with Perl but was wondering
if there was an easier way to achieve it. Does anybody know of any
built-in functions that will do this or any free tools or code
examples?

Thank you in advance.

rbr

[Bill Karwin]

[email]ryankbrown@gmail.com[/email] wrote:

> I am looking for a way to output the results of the mysqlshow command
> to a text file.

"mysqlshow > textfile" doesn't work for you?

Regards,
Bill K.

[ryankbrown@gmail.com]

That works great except for the fact that I cannot have the extra
characters ("---+", etc.) that it creates.

Thank you for the suggestion.

rbr

Bill Karwin wrote:

> [email]ryankbrown@gmail.com[/email] wrote:

> > I am looking for a way to output the results of the mysqlshow command
> > to a text file.

>
> "mysqlshow > textfile" doesn't work for you?
>
> Regards,
> Bill K.

[Bill Karwin]

[email]ryankbrown@gmail.com[/email] wrote:

> That works great except for the fact that I cannot have the extra
> characters ("---+", etc.) that it creates.

Aha. That was not part of your original question.

I would do this:

mysql -uuser -ppassword --batch -e "show tables" database > textfile

The "--batch" (or -B) option suppresses all the pipes and such, but
unfortunately it is not available in the mysqlshow command.

Regards,
Bill K.

[Radoulov, Dimitre]

> That works great except for the fact that I cannot have the extra

> characters ("---+", etc.) that it creates.

mysqlshow | tr -d "|+-" > textfile


Regards
Dimitre

[ryankbrown@gmail.com]

Sorry I didn't mention that earlier.

This seems to work great however, will this work for databases or just
tables?

Thanks again,

Ryan

Bill Karwin wrote:

> [email]ryankbrown@gmail.com[/email] wrote:

> > That works great except for the fact that I cannot have the extra
> > characters ("---+", etc.) that it creates.

>
> Aha. That was not part of your original question.
>
> I would do this:
>
> mysql -uuser -ppassword --batch -e "show tables" database > textfile
>
> The "--batch" (or -B) option suppresses all the pipes and such, but
> unfortunately it is not available in the mysqlshow command.
>
> Regards,
> Bill K.

[Bill Karwin]

[email]ryankbrown@gmail.com[/email] wrote:

> This seems to work great however, will this work for databases or just
> tables?

There are other "show" commands you can use with this method.

See [url]http://dev.mysql.com/doc/refman/5.0/en/show.html[/url] for a list.

Regards,
Bill K.

[ryankbrown@gmail.com]

mysql -uusername -ppassword --batch -e "show dat
abases" > dbs.txt

Works like a charm.

Thank you,

rbr


Bill Karwin wrote:

> [email]ryankbrown@gmail.com[/email] wrote:

> > This seems to work great however, will this work for databases or just
> > tables?

>
> There are other "show" commands you can use with this method.
>
> See [url]http://dev.mysql.com/doc/refman/5.0/en/show.html[/url] for a list.
>
> Regards,
> Bill K.