Re: backing up a database

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

 



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:

$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.



Cheers
--
David Robley

"I haven't caught a fish all day!" Tom said, without debate.
Today is Sweetmorn, the 39th day of The Aftermath in the YOLD 3172.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux