PHP: Database FTP Backup

PHP: Database FTP Backup.php

<?
    $dbhost = 'localhost'; 
    $dbuser = 'db_user';
    $dbpass = 'db_pass';
    $dbname = 'db_name';

    $ftphost = 'ftp_host';
    $ftpuser = 'ftp_user';
    $ftppass = 'ftp_pass';

    date_default_timezone_set('US/Eastern');
    $dbfile = 'dumps/backup-' . date('Y-m-d-g-i') . '.sql';
    $dbzip = 'dumps/backup-' . date('Y-m-d-g-i') . '.zip';
    
    $ftpfile = 'backup-' . date('Y-m-d-g-i') . '.zip';

    if ( file_exists($dbfile) ) {
        die('<p>File Exists.</p>');
    } else {

        $link = mysql_connect($dbhost,$dbuser,$dbpass);

        if (!$link) {
            die('<p>Could not connect to database: ' . mysql_error() . '</p>');
        } else {
            echo '<p>Database connection OK.</p>'; mysql_close($link);
            system("mysqldump -h $dbhost -u $dbuser -p$dbpass $dbname > $dbfile");
            echo '<p>Database has been backed up locally.</p>';

            $zip = new ZipArchive;
            $res = $zip->open($dbzip, ZipArchive::CREATE);
            $zip->addFile($dbfile);
            $zip->close();

            $connection = ftp_connect($ftphost);
            $login = ftp_login($connection, $ftpuser, $ftppass);

            if (!$connection || !$login) {
                die('FTP connection failed.');
            }

            $upload = ftp_put($connection, $ftpfile, $dbzip, FTP_ASCII);

            if (!$upload) {
                die('FTP upload failed');
            } else {
                echo '<p>Database has been backed up to FTP.</p>';
                $delete = unlink($dbfile);
                $deletezip = unlink($dbzip);
                if ($delete && $deletezip) {
                    echo '<p>Local files deleted.</p>';
                }
            }

            ftp_close($connection); 
        }
    }
?>