> -Original Message-
> From: James Tu [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 28, 2006 5:03 PM
> To: PHP General List
> Subject: Re: [PHP] backing up a database
>
> Thanks Brad:
>
> I'm just surprised that when people mention mysqldump, mo
ssage-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 28, 2006 2:50 PM
To: James Tu
Cc: PHP General List
Subject: Re: [PHP] backing up a database
James Tu wrote:
> Thanks Brad:
>
> I'm just surprised that when people mention mysqldump, most of the
time
> they do
James Tu wrote:
Thanks Brad:
I'm just surprised that when people mention mysqldump, most of the time
they don't talk about locking the tables at all.
I'm curious why this is the case.
Because you don't need to. More of a mysql-mailing list question to be
honest.
--
Postgresql & php tutori
Thanks Brad:
I'm just surprised that when people mention mysqldump, most of the
time they don't talk about locking the tables at all.
I'm curious why this is the case.
-James
Does one need to lock(?) MySQL before running mysqldump?
Or will the mysqldump command wait for any pending operat
> -Original Message-
> From: James Tu [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 28, 2006 1:21 PM
> To: PHP General List
> Subject: Re: [PHP] backing up a database
>
> Does one need to lock(?) MySQL before running mysqldump?
> Or will the mysqldump comm
Does one need to lock(?) MySQL before running mysqldump?
Or will the mysqldump command wait for any pending operations to
finish, lock the tables for dumping and once finished release the lock?
-James
On Nov 27, 2006, at 2:21 AM, David Robley wrote:
Sumeet wrote:
Brad Fuller wrote:
$com
Sumeet wrote:
> Brad Fuller wrote:
>
>> $command = "mysqldump -u $dbuser -p$dbpass $dbname | gzip >
>> $backupFile";
>>
>> system($command);
>>
>>
>
> what if system() has been disabled on the server?
>
SELECT INTO OUTFILE 'file_name' export_options seems a useful
alternative.
Cheer
Brad Fuller wrote:
$command = "mysqldump -u $dbuser -p$dbpass $dbname | gzip >
$backupFile";
system($command);
what if system() has been disabled on the server?
--
Thanking You
Sumeet Shroff
http://www.prateeksha.com
Web Designers and PHP / Mysql Ecommerce Developm
On Wed, November 22, 2006 3:53 am, Ross wrote:
> I have a database and it needs to get backed up on a daily basis. Is
> there a
> class that allows me to create a backup and then save it as a .sql or
> excel
> or both to a folder of her choice?
I personally would not involve PHP in this process, i
t; -Original Message-
> > From: Brad Fuller [mailto:[EMAIL PROTECTED]
> > Sent: 22 November 2006 14:28
> > To: 'PHP General List'
> > Subject: RE: [PHP] backing up a database
> >
> >
> >
> > Here is a script that I found that has been
wouldn't offer any more protection than just saving it
locally. (My remote FTP location is in a different continent!)
Edward
> -Original Message-
> From: Brad Fuller [mailto:[EMAIL PROTECTED]
> Sent: 22 November 2006 14:28
> To: 'PHP General List'
> Subject: R
$ok = @mail($email_to, $email_subject, $email_message, $headers);
if($ok) {
echo date("Y-m-d H:i:s") . " Operation completed.\n";
} else {
die(date("Y-m-d H:i:s") . " Operation failed - The e-mail
If you're using MySQL, set up a cron job/scheduled task to call mysqldump
and save the output somewhere. Other DBMSs will likely have similar tools.
Edward
> -Original Message-
> From: Ross [mailto:[EMAIL PROTECTED]
> Sent: 22 November 2006 09:54
> To: php-general@lists.php.net
> Subject:
Ross wrote:
> I have a database and it needs to get backed up on a daily basis. Is there a
> class that allows me to create a backup and then save it as a .sql or excel
> or both to a folder of her choice?
I'm only helping cos there's a chick involved. ;-)
the easiest solution would be to use a
Ross wrote:
I have a database and it needs to get backed up on a daily basis. Is there a
class that allows me to create a backup and then save it as a .sql or excel
or both to a folder of her choice?
cron and mysqldump or pg_dump
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe
15 matches
Mail list logo
