0
0
Mitul Dabhi
answered Nov 30 '-1 00:00
we are running mysql command by php and getting result a file name with "db_backup_2_2_2018.sql"
$result=exec('mysqldump dbname --password=password --user=username --single-transaction >/home/public_html/backup/'.'db_backup_'.date('m_d_y').'.sql',$output);
if you have mysql root acess you can direct run this in command prompt as well
mysqldump dbname --password=password --user=username --single-transaction >/home/public_html/backup/db_backup.sql
hope it work