multi-db backup php cli script. simple

Elite
    • 438 points
    WPMU DEV Expert
    I'm helpful
    jozwikjp

    Member  —  1st December 2010 (1 year ago)         

    This is a quick backup script that you can run at the command line.
    >
    php backupdbs.php USER PASSWORD DATABASEPREFIX
    It will dump all your database into one dump and compress it.
    I use this on slaves. so it turns of the slave so you can get a consistent backup. Then turns it back on.

    Not much to it.


    <?php
    //exit
    $dbuser = $_SERVER['argv'][1];
    $dbpw= $_SERVER['argv'][2];
    $dbprefix= $_SERVER['argv'][3];
    //$dbprefix= $_SERVER['argv'][4];

    $DateTime = date("Ymd");

    $dbconnection = mysql_connect('localhost',$dbuser,$dbpw);
    $PullCustomer="STOP SLAVE";
    $CsResults = mysql_query($PullCustomer,$dbconnection);
    $PullCustomer="SHOW SLAVE STATUS";
    $CsResults = mysql_query($PullCustomer,$dbconnection) or die("$PullCustomer");
    $SlaveStatus=mysql_fetch_assoc($CsResults);

    $Relay_Master_Log_File=$SlaveStatus['Master_Log_File'];
    $Exec_Master_Log_Poss=$SlaveStatus['Read_Master_Log_Pos'];
    $Master_Host=$SlaveStatus['Master_Host'];
    $Master_User=$SlaveStatus['Master_User'];

    $PullCustomer="SHOW DATABASES LIKE 'mysiteinc%'";
    $CsResults = mysql_query($PullCustomer,$dbconnection) or die("$PullCustomer Not valid order number please check your url.");
    while(list($database) = mysql_fetch_row($CsResults)){

    $databases="$databases $database";

    }
    mysql_close($dbconnection);
    //--delete-master-logs --master-data[=value]
    $Command='mysqldump -u'.$dbuser.' -p'.$dbpw.' --databases '.$databases.' --opt | gzip -c > '.date("Y-m-d").'_'.$dbprefix.'.sql.gz';
    $Result=exec($Command);

    $Command='mysql -u'.$dbuser.' -p'.$dbpw.' -e "START SLAVE;";';
    $Result=exec($Command);
    print "backed up";

    exit;
    ?>