MySQL database backup from the client

[Madison Kelly]

   The reason is that the dump needs to be performed by an install 
script (if a database exists I want to dump it before loading the new 
one, "just in case"). So I need some way to automate things. Thanks for 
the recommendation though!

Madison


jay-ZPnsNkHkFjk at public.gmane.org wrote:
> 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