Re: backing up databases
| From: | David T-G | Date: | Tue, 28 Jan 2003 02:04:20 +0000 |
| Subject: | Re: backing up databases | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25187@lists.php.net to get a copy of this message | ||
Chris --
..and then Chris Payne said...
%
% Hi there everyone,
Hi!
%
% I have way too many databases to backup manually or with PHPMyADMIN, how, using PHP with MySQL
could I backup multiple databases easily?
1) What level of 'manual' is too much?
2) Are all of the databases on the server yours to back up, or only some
of them?
3) Do you have access to the command line through your php script as
might be expected, or are you somehow limited?
4) Do you have a user/password who can dump your databases?
5) Can you use cron to run jobs repeatedly?
I'd write a script (php CLI, perl, shell, whatever) to do the dump and
then just call it from your web click or, better yet, from a crontab.
%
% Any examples would be really appreciated :-)
Answers first, grasshopper :-)
%
% Thank you.
%
% Regards
%
% Chris
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!