Re: function for backing up mysql

From:	Burhan Khalid	Date:	Wed, 14 Apr 2004 09:26:52 +0000
Subject:	Re: function for backing up mysql
References:	1 2	Groups:	php.general
Request:	Send a blank email to php-general+get-183295@lists.php.net to get a copy of this message

Victor Spång Arthursson wrote:

    2004-04-14 kl. 09.57 skrev Hawkes, Richard:
PhpMyAdmin (www.phpmyadmin.net) is a great MySQL admin tool, and utilises the MySQL backup functions.
Yes, and it is the same functionability I want. But I want a php-function to implement in various scripts I have, and since I probably aint the first to want this, I thought that there perhaps were some good scripts out there to use.

Just redirect the output from mysqldump. mysqldump -u username -ppassword database > dump.sql and then send that dump.sql file. Or, you can just read the output from the mysqldump command directly, using output buffering to make sure your script doesn't just stall (if its a big database).