Bad News: Although it has been about 10 years ago, I have purchased a "Sold and Shipped by Amazon" SanDisk USB drive that was counterfeit. They exchanged it no problem.
Use the utility Jim K referenced above and you will know for sure if something is not legit.
Question
mikeaag
Hey all,
Wondering if someone can help me.
I need to setup a cron job that backs up a mysql database, but im not too familiar with cron jobs.
The code i have at the moment is:
and the php file is:
<?php $host = "localhost"; $username = "root"; $password = ""; $database = "database"; mysql_connect($host, $username, $password); mysql_select_db($database); $query = "SELECT * INTO OUTFILE 'path/to/backup/file.sql' FROM TABLENAME"; $result = mysql_query($query); mysql_close(); ?>
Im pretty sure the PHP code will work fine, its more the Cron job im worried about.
I need it to run every week, at midnight on sunday, and i want it to output its results to a log file as well.
Can anyone tell me if this will work before i test it on the server, as its not my server and i dont want to break it :D
Thanks in advance
Link to comment
https://www.neowin.net/forum/topic/882910-mysql-cron-job-backup-mysql-database-with-cron-job/Share on other sites
3 answers to this question
Recommended Posts