Cron mysql database backup without mysql_dump
Cron mysql database backup without mysql_dump
I have php mysql website and hosted on shared hosting. I have created a php script to take backup of database and email it via cron job.
But my hosting provider company is not allowing mysql_dump function with using password for security reason.
mysql_dump function
I have search and googled for the solution, But I got almost all searches with system mysql_dump only.
system mysql_dump
Is there any other way to take backup of database and email it to given address and doing this stuff with cron job.. ??
What is your Mysql Server version ? Do you have InnoDB tables in the database as well ? Check dev.mysql.com/doc/refman/5.7/en/backup-methods.html
– Madhur Bhaiya
Sep 7 '18 at 7:27
0
Thanks for contributing an answer to Stack Overflow!
But avoid …
To learn more, see our tips on writing great answers.
Required, but never shown
Required, but never shown
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Can you please give your service provider name?
– Bhavin Solanki
Sep 7 '18 at 6:43