User:Jukeboksi/BBA studies/User:Jukeboksi/Blog/2013: Difference between revisions
User:Jukeboksi/BBA studies/User:Jukeboksi/Blog/2013 (edit)
Revision as of 11:59, 2 September 2013
, 2 September 2013mentioning mysqldump and how to use it
(tweaking the HOWTO on linux backupping) |
(mentioning mysqldump and how to use it) |
||
| Line 8: | Line 8: | ||
::* ''Usually the full home-directory and a full dump of [[w:database]]s is all you need'' | ::* ''Usually the full home-directory and a full dump of [[w:database]]s is all you need'' | ||
::* ''Use a dedicated backup directory on every machine. '''The main point is that it needs to be somewhere outside the directories you are interested in backupping.''' I call mine <tt>/backupmedia</tt> . | ::* ''Use a dedicated backup directory on every machine. '''The main point is that it needs to be somewhere outside the directories you are interested in backupping.''' I call mine <tt>/backupmedia</tt> . | ||
:::<tt>'tar cvzf /backupmedia/machinename/homedir.tar.gz /home/yourusername' </tt> Will compress your home directory | :::<tt>'tar cvzf /backupmedia/machinename/homedir.tar.gz /home/yourusername' </tt> Will compress your home directory. | ||
:::Use the <tt>'mysqldump'</tt> command with switches <tt>--all-databases</tt>, the mysql root password and user | |||
# ) VERIFY THE BACKUPS TO WORK BY LOADING INTO A REFERENCE SYSTEM ON NON-PRODUCTION CLOSED SERVER INSTANCE. Not verified truly cannot be called backup because if they are found to be faulty shit will ensue. Check that the .tar.gz's unpack and that the database dumps can be read onto MySQL. | # ) VERIFY THE BACKUPS TO WORK BY LOADING INTO A REFERENCE SYSTEM ON NON-PRODUCTION CLOSED SERVER INSTANCE. Not verified truly cannot be called backup because if they are found to be faulty shit will ensue. Check that the .tar.gz's unpack and that the database dumps can be read onto MySQL. | ||
#) Criss-cross-copy from every machine to every machine / distribute the backups to as many servers, laptops and USB sticks as possible. | #) Criss-cross-copy from every machine to every machine / distribute the backups to as many servers, laptops and USB sticks as possible. | ||