Magento create database backup from PHP code
In this article we will provide you with a simple code example of how you can backup your Magento database programmatically. Backup your code from a simple PHP file. This file can be executed via URL, cron or elsewise programatically.
You can reuse and modify the code example below to create your own database backup script.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
/* * Database backup script * Author: Emvee Solutions * Backup can be found in var/backups */ //increase execution time ini_set('max_execution_time', 900); //900 seconds = 15 minutes //require Magento require_once 'app/Mage.php'; $app = Mage::app('admin'); umask(0); //set error reporting error_reporting(E_ALL & ~E_NOTICE); Mage::setIsDeveloperMode(true); //do backup try { $backupDbHelper = Mage::getModel('backup/db'); //create backup instance, set certain options $backup = Mage::getModel('backup/backup') ->setTime(time()) ->setType('db') ->setPath(Mage::getBaseDir("var") . DS . "backups"); //do actual backup $backupDbHelper->createBackup($backup); //return success print 'Backup successfully created'; } catch (Exception $e) { //log exception magento and print to screen Mage::logException($e->getMessage()); print 'Error while creating backup: ' . $e->getMessage(); } |
/*
* Database backup script
* Author: Emvee Solutions
* Backup can be found in var/backups
*/
//increase execution time
ini_set('max_execution_time', 900); //900 seconds = 15 minutes
//require Magento
require_once 'app/Mage.php';
$app = Mage::app('admin');
umask(0);
//set error reporting
error_reporting(E_ALL & ~E_NOTICE);
Mage::setIsDeveloperMode(true);
//do backup
try {
$backupDbHelper = Mage::getModel('backup/db');
//create backup instance, set certain options
$backup = Mage::getModel('backup/backup')
->setTime(time())
->setType('db')
->setPath(Mage::getBaseDir("var") . DS . "backups");
//do actual backup
$backupDbHelper->createBackup($backup);
//return success
print 'Backup successfully created';
} catch (Exception $e) {
//log exception magento and print to screen
Mage::logException($e->getMessage());
print 'Error while creating backup: ' . $e->getMessage();
}
Perfect! working fine
Glad to help!