Using following PHP code, you can get dump (backup) of your MySql data
<?php
date_default_timezone_set('Asia/Calcutta'); // set your timezone (Optional)
$db_server = '****'; // Database server, usually "localhost"
$db_name = '****'; // Database name, leave empty for 'all databases'
$db_user = '****'; // Database username
$db_pass = '****'; // Database password
$date_stamp = date('Y-m-d-H-i-s');
$backup_filename = ($db_name == '' ? 'all_databases' : $db_name) . '_' . $date_stamp . '.sql.gz';
$cmd = 'mysqldump -u ' . $db_user . ' -h ' . $db_server . ' --password=' . $db_pass . ' ' . ($db_name == '' ? '--all-databases' : $db_name) . ' | gzip > ' . $backup_filename;
$dump_status = (passthru($cmd) === false) ? 'No' : 'Yes';
?>
