dmSqlBackupPlugin

• In a console, from your project root dir, run:

git clone git://github.com/ornicar/dmSqlBackupPlugin.git plugins/dmSqlBackupPlugin  

• In config/ProjectConfiguration.class.php, add dmSqlBackupPlugin to the list of enabled plugins:

class ProjectConfiguration extends dmProjectConfiguration
{  
  public function setup()  
  {  
    parent::setup();  
 
    $this->enablePlugins(array(  
      // your enabled plugins  
      'dmSqlBackupPlugin'  
    ));  

• In a console, from your project root dir, run:

php symfony dm:setup  

Usage

Command line

php symfony dm:sql-backup  

Plan a cron task

For example to run this task all days:
/etc/crontab

@daily www-data /usr/bin/php5 /home/my-project/symfony dm:sql-backup  

Programmatically

$sqlBackup = $this->getService('sql_backup');
$sqlBackup->execute($connection);  

$connection must be an instance of Doctrine_Connection.

Customize

Use the service container configuration file to change sql_backup parameters. It allows to configure the service, add new adapters and override the service class.
config/dm/services.yml

parameters:  
  
  sql_backup.class:       dmSqlBackup  
  sql_backup.adapters:  
    mysql:                dmSqlBackupAdapterMysql  
  sql_backup.options:  
    dir:                  SF_ROOT_DIR/data/dm/backup/sql  
    file_format:          %%db_name%%-%%year%%_%%month%%_%%day%%_%%time%%.sql