My Learnings – Markish Personal Blog

    There have been instances when we need to schedule the backup process of MySQL databases regularly. So I thought of writing batch file that can be added in the Windows scheduler. I used the ‘mysqldump’ utility that comes with the MySQL distributions. It dumps the database definition along with all the data, indexes, triggers and SPs in the form of .sql file. I’ve also made the batch file to compress the output .sql file.

Continue reading Scheduling MySQL Backup..!