Help with auto backup

[Gempis]

I have this script that makes an auto backup of the database, but it will just save it in the server...

Can anyone modify it so that it uploads it to rapidshare or w/e, o reven better to email me the back up?

<?php
/**
*
* @package Auto Database Backup
* @copyright (c) 2008 EXreaction
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

if (!defined('IN_PHPBB'))
{
    // Stuff required to work with phpBB3
    define('IN_PHPBB', true);
    $phpbb_root_path = './';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);

    // Start session management
    $user->session_begin();
    $auth->acl($user->data);
    $user->setup('acp/database');

    if (!backup_db())
    {
        trigger_error('The database has already been backed up today.');
    }

    trigger_error('BACKUP_SUCCESS');
}

function backup_db()
{
    global $db, $phpbb_root_path, $phpEx, $table_prefix;

    $name = 'auto_backup/db_backup_' . date('Y-m-d');

    //Make sure this script can only be ran once per day
    if (file_exists($phpbb_root_path . 'store/' . $name . '.sql.gz'))
    {
        return false;
    }

    include($phpbb_root_path . 'includes/functions_install.' . $phpEx);
    include($phpbb_root_path . 'includes/acp/acp_database.' . $phpEx);

    @set_time_limit(1200);
    @set_time_limit(0);

    switch ($db->sql_layer)
    {
        case 'mysqli':
        case 'mysql4':
        case 'mysql':
            $extractor = new mysql_extractor(false, true, 'gzip', $name, time());
        break;

        case 'sqlite':
            $extractor = new sqlite_extractor(false, true, 'gzip', $name, time());
        break;

        case 'postgres':
            $extractor = new postgres_extractor(false, true, 'gzip', $name, time());
        break;

        case 'oracle':
            $extractor = new oracle_extractor(false, true, 'gzip', $name, time());
        break;

        case 'mssql':
        case 'mssql_odbc':
            $extractor = new mssql_extractor(false, true, 'gzip', $name, time());
        break;

        case 'firebird':
            $extractor = new firebird_extractor(false, true, 'gzip', $name, time());
        break;
    }

    $extractor->write_start($table_prefix);

    foreach (get_tables($db) as $table_name)
    {
        // Get the table structure
        $extractor->write_table($table_name);

        // Data
        $extractor->write_data($table_name);
    }

    $extractor->write_end();

    add_log('admin', 'LOG_DB_BACKUP');

    set_config('backup_last_gc', time(), true);

    return true;
}

?>

Gempis Reviewed by Gempis on 31st May 2010. Help with auto backup I have this script that makes an auto backup of the database, but it will just save it in the server... Can anyone modify it so that it uploads it to rapidshare or w/e, o reven better to email me the back up? <?php /** * * @package Auto Database Backup * @copyright (c) 2008 EXreaction * @license http://opensource.org/licenses/gpl-license.php GNU Public License Rating: 5

[Snell]

if your host has not disabled exec command and have perl then my post is useful

upload rsapiresume.pl in the directory where the backup file is found

<?php 
echo exec("perl rsapi.pl backup.tgz col Username password")
?>

you'll get the link into rsapiuploads.txt
change col to prem if you got a premium RS acc

~~~~~

using cUrl to upload to HF by

$ch = curl_init();
$localfile = 'backup.tgz';
$fp = fopen($localfile, 'r');
curl_setopt($ch, CURLOPT_URL, 'ftp://username:password@ftp.hotfile.com/'.$localfile);
curl_setopt($ch, CURLOPT_UPLOAD, 1);
curl_setopt($ch, CURLOPT_INFILE, $fp);
curl_setopt($ch, CURLOPT_INFILESIZE, filesize($localfile));
curl_exec ($ch);
curl_close ($ch); 

Don't know if it's useful, am just trying to help you out