MySQL database backup from the client

[jay-ZPnsNkHkFjk at public.gmane.org]

Why not use phpmyadmin http://www.phpmyadmin.net/home_page/index.php

> Hi,
>
>    I have been all over the MySQL (4.1) docs trying to find a way to
> dump a database from within MySQL (through perl). I know I can make a
> sysem call to 'mysqldump' but then I would have to pass the password
> essentially over the commnd line which expses it (even if for just a
> moment).
>
>    I know you can use 'SHOW CREATE TABLE xyz' to get the table schema
> then 'BACKUP TABLE...' or 'SELECT INTO ... OUTFILE' to get the data but
> this would e, to say the least, combersome. Is there something like
> 'BACKUP DATABASE foo OUTFILE ...'?
>
>    There is no concern in my case about the database being accessed
> while I do the dump.
>
> Thanks!
>
> Madison
>
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>            Madison Kelly (Digimer)
>     TLE-BU; The Linux Experience, Back Up
> Main Project Page:  http://tle-bu.org
> Community Forum:    http://forum.tle-bu.org
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> --
> The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml
>


--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml