Difference between revisions of "CSC220 Lab 9: Automatic MySql Database Backup"
(Created page with '--~~~~ ---- <br /> <br /> <br /> <br /> <br /> <br /> <br /> Category:CSC220Category:MySqlCategory:Bash') |
|||
| Line 2: | Line 2: | ||
---- | ---- | ||
| + | <bluebox> | ||
| + | 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 | ||
| + | </bluebox> | ||
| + | |||
| + | |||
| + | =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. | ||
| + | * | ||
<br /> | <br /> | ||
Revision as of 11:32, 21 November 2010
--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.
