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.

data_loss

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, you have to be creative as possible, I will only tell you the technique not in advanced details. First created a batch file and named it anything you like.. Your batch file content should be like this..

<YOUR PATH TO>\mysqldump -u[username] -p[password] –result-file=”<YOUR PATH TO>\Backup-%DATE:~0,3%.sql” TABLENAME

When you run your batch file it will generate a dumping SQL file. Next the creative part, you can run this batch hourly daily or anytime you need. Be creative by create your own running programs it can be easily programmed through any development tools. Next You can also FTP or Mailed this backup file to make sure you won’t loose it.

That’s a sample on windows, in linux it should be not to much difference, all you need is understand the technique and all can be done via utility every operating system have.

That’s share for today pretty short articles, Have a nice day 😀

Similar Posts:

Related Search Terms:

    Digg Del.icio.us StumbleUpon Reddit Twitter RSS

If you're new here, you may want to subscribe to my RSS feed. You may copy or publish this article to your blog or other site as long you give credit link back to this site article. Thanks for visiting my blog!