> -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
php.net
> Subject: [PHP] backing up a database
>
>
> 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?
>
>
> R.
>
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
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?
R.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.ph
This is what you'll want to do:
0 0 * * * /path/to/mysqldump -u[username] -p[username] [database] > /path/to/backup.sql
Put that above in your crontab (you might want to tar/gzip it too if it's big)
then download it via cron to your local box.
You could also look into rsync.
--Joe
On Sat, Nov
mysqldump
check it out, either man or google
then ftp that file down, load it wherever, and mysql database < dump.sql
jack
-Original Message-
From: cosmin laslau [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 17, 2001 5:25 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP Backing u
Hi,
Say I'm not really confident in the prowess of my server, and I want to
download my database onto my computer. Can that be done? What can I look
(FTP access) in the directory structure. I guess, where is it usually
located?
Thanks.
Cosmin Laslau
_
19 matches
Mail list logo
