automation

Auto Backup MySQL Database

Data is important thing in company or organization. People who can’t protect their data is the loser this day. Can you imagine you lost all your data for works? it just like a heaven go away from you he he.. This happen to me yesterday and I lost 1 month production data caused by bad electrical environment. In this short articles I will share a small information how to backup your data periodically. I am using windows server and xampp to run every automation so I will write how to backup MySQL database periodically. First thing you need to know,… Read More »Auto Backup MySQL Database

CRON JOB to Repair and Optimize Database

In this short articles we will learn how to automatically repair and optimize our database using Cron Job. Cron Job is most likely scheduler, mean it will run automatically after we setup it. I believe not many of us know how to using this features, We can use it to run periodically some PHP script we made. Example a sitemap generator script which may consume to many resource if we run it manually, we can set it run in schedule follow settings on Cron Job. In this short articles I will give sample how we can use Cron Job to… Read More »CRON JOB to Repair and Optimize Database