Re: question about mysql backups

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jake --

...and then Jake Malone said...
% 
% hi,

Hi!


% 
% i have a script (run from cron) which backs up all files in a given
% directory and outputs a zip file. what i want to do is backup the database

Good enough.


% in the same process and add it to the same zip file. i really like

You can either make the mysql dump file first and include it or add it to
the existing zip file, as you prefer.


% phpmyadmin's way of backing up the DB, and was wondering if there was an
% easy way to do essentially the same thing outside of phpmyadmin (i just need
% to save the db structure, tables, and data into a single .sql file). thanks
% in advance.

Yep.  For mysql dump needs, there's nothing like mysqldump -- see the man
page (as well as, perhaps, the mysql general liist archives).


% 
% -jake


HTH & HAND

:-D
-- 
David T-G                      * There is too much animal courage in 
(play) davidtg@justpickone.org * society and not sufficient moral courage.
(work) davidtgwork@justpickone.org  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

Attachment: pgp00052.pgp
Description: PGP signature


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux