RE: [PHP] Backup of a MySQL database.
| From: | Chris W. Parker | Date: | Tue, 23 Mar 2004 00:10:29 +0000 |
| Subject: | RE: [PHP] Backup of a MySQL database. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-181191@lists.php.net to get a copy of this message | ||
Elliot J. Balanza <mailto:webmaster@mbtradingco.com>
on Monday, March 22, 2004 3:05 PM said:
> I was looking something more like a MySQL dump class or function...
this may not be as robust a solution as you require but can you not
simply backtick the mysqldump command from within php?
<?php
$date = date();
$output = `mysqldump --opt --quote-names -u root --password=daword
database > file_$date.dump`;
?>
or even create a shell script that does all the dumping and handling of
dump files and then just execute that.
hth,
chris.