i found a new script thanks to google ....
<?php// Create the mysql backup file// edit this section$dbhost = "yourhost"; // usually localhost$dbuser = "yourusername";$dbpass = "yourpassword";$dbname = "yourdb";$sendto = "Webmaster <webmaster@yourdomain.com>";$sendfrom = "Automated Backup <backup@yourdomain.com>";$sendsubject = "Daily Mysql Backup";$bodyofemail = "Here is the daily backup.";// don't need to edit below this section$backupfile = $dbname . date("Y-m-d") . '.sql';system("mysqldump -h $dbhost -u $dbuser -p$dbpass $dbname > $backupfile");// Mail the file include('Mail.php'); include('Mail/mime.php');$message = new Mail_mime();$text = "$bodyofemail";$message->setTXTBody($text);$message->AddAttachment($backupfile); $body = $message->get(); $extraheaders = array("From"=>"$sendfrom", "Subject"=>"$sendsubject"); $headers = $message->headers($extraheaders); $mail = Mail::factory("mail"); $mail->send("$sendto", $headers, $body);// Delete the file from your serverunlink($backupfile);?>
will this work to send the DB in an email?not tested by me yet it dose not look like php5 but i could be wrong