MySql Backup - Tutorials - Infos - Anleitungen

<?php

                        $username = '';#user

                        $passwort =
                        '';#passort

                        $db_name =
                        '';#Name
                        der Dantenbank

                        $filename =
                        date(d.'.'.m.'.'.Y);

                        $mail =
                        '';#deine
                        Email Adresse

                        $Betreff =
                        "Backup der Datenbank
                        $db_name vom $filename";

                        

                        system('/usr/bin/mysqldump
                        -u'.$username.'
                        -p'.$passwort.'
                        -h localhost '.$db_name.'
                        | /bin/gzip > '.$filename.'.sql.gz',
                        $fp);

                        if ($fp==0)
                        echo '';
                        else echo 'Es ist ein
                        Fehler aufgetreten';

                        $filename_n =
                        $filename.'.sql.gz';

                        $Header =
                        "From: Backup System
                        <$mail>";

                        $Trenner =
                        md5(uniqid(time()));

                        $Header .=
                        "\n";

                        $Header .=
                        "MIME-Version:
                        1.0";

                        $Header .=
                        "\n";

                        $Header .=
                        "Content-Type:
                        multipart/mixed; boundary=$Trenner";

                        $Header .=
                        "\n\n";

                        $Header .=
                        "This is a multi-part
                        message in MIME format";

                        $Header .=
                        "\n";

                        $Header .=
                        "--$Trenner";

                        $Header .=
                        "\n";

                        $Header .=
                        "Content-Type: text/plain";

                        $Header .=
                        "\n";

                        $Header .=
                        "Content-Transfer-Encoding:
                        8bit";

                        $Header .=
                        "\n\n";

                        $Header .=
                        "Backup der Datenbank
                        $db_name vom $filename";

                        $Header .=
                        "\n";

                        $Header .=
                        "--$Trenner";

                        $Header .=
                        "\n";

                        $Header .=
                        "Content-Type:
                        application/x-gzip; name=$filename_n";

                        $Header .=
                        "\n";

                        $Header .=
                        "Content-Transfer-Encoding:
                        base64";

                        $Header .=
                        "\n";

                        $Header .=
                        "Content-Disposition:
                        attachment; filename=$filename_n";

                        $Header .=
                        "\n\n";

                        $Dateiinhalt .=
                        fread(fopen($filename_n,
                        "r"),
                        filesize($filename_n));

                        $Header .=
                        chunk_split(base64_encode($Dateiinhalt));

                        $Header .=
                        "\n";

                        $Header .=
                        "--$Trenner--";

                        mail($mail,
                        $Betreff,
                        "",
                        $Header);

                        ?>