Re: backing up a database

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