CSC220 Lab 9: Automatic MySql Database Backup

From dftwiki3
Revision as of 11:32, 21 November 2010 by Thiebaut (talk | contribs)
Jump to: navigation, search

--D. Thiebaut 14:22, 21 November 2010 (UTC)

The goal of this lab is to setup a simple cron-based scheme to automatically backup your database every 24 hours. It requires the use of mysqldump which is standard on most linux system


Where should you login?

  • The computer you are going to login to will be the one that will be doing the automatic backup. Because the setup will be saved on that server, it is important to pick one that is reliable and won't be restarted in Windows mode by somebody else (which could be the case with any of the hadoop1xx machines).
  • So pick grendel or beowulf as the server you are going to use for the backup.

MySqlDump

  • Login to your 220a-xx account on beowulf or grendel.








Retrieved from "http://dominiquethiebaut.com/dftwiki3/index.php?title=CSC220_Lab_9:_Automatic_MySql_Database_Backup&oldid=9469"