Linux update HOWTO

• Backup /etc:
• tar cvzf /home/export/backup/etc_yyyymmdd.tgz /etc
• drakbackup
• /etc/drakxtools/drakbackup/
• Backup mysql databases: /var/lib/mysql
• tar cvzf /home/export/backup/mysql_yyyymmdd.tgz /var/lib/mysql
• mysqldump
• mysqldump -u root -p --all-databases > mysql_yyyymmdd.sql
• mysqldump -u root -p --all-databases --xml > mysql_yyyymmdd.xml
• mysql-administrator
• tar cvzf /home/export/backup/mysqlgui_yyyymmdd.tgz /root/.mysqlgui
• backup profiles: /root/.mysqlgui/backup_profiles
• backup_timetracker
• backup_bugzilla
• backup_wiki
  
• Tools / Preferences 
• General Options: Store connection passwords (Obscured) (solves "Backup error: Cannot set ANSI quotes")
  
• Connections: write password
• connections: /root/.mysqlgui/mysqlx_user_connections.xml
• mysql-workbench
• ...
  
• Backup http server: /var/www
• tar cvzf /home/export/backup/www_yyyymmdd.tgz /var/www
• mediawiki
• Back up existing files and the database
• /var/www
• MySQL
  
• Samba
• tdbbackup (TDB Database File Information)
  
• bugzilla
• /var/lib/bugzilla
• backup
• VDR
• /var/lib/vdr
• MythTV
• backup
• cron
  
• tar cvzf /home/export/backup/cron_yyyymmdd.tgz /var/spool/cron
  

• network
• IP address
• computer name
• /etc/sysconfig/network
• HOSTNAME=pctoto
  
• NTP
  

• Configure /etc/hosts
• 127.0.0.1 pctoto localhost
  
• Restore /etc
• tar -C /tmp -xvzf /home/export/backup/etc_yyyymmdd.tgz
• Restore users (*)
• cp /tmp/etc/passwd /etc/passwd
• cp /tmp/etc/shadow /etc/shadow
• Restore groups
• cp /tmp/etc/group /etc/group
• Restore drakbackup profiles
• cp -pr /tmp/etc/drakxtools/drakbackup/ /etc/drakxtools/
• Restore credentials for fstab
• cp /tmp/etc/samba/auth* /etc/samba
  
• Restore /etc/fstab
  
• Configure Firewall
• allow
• SSH
• Web server
• SMB
• ping
• (cvs server): 2401/tcp
• (svn server)
• (nfs)
• wiki:
  
• Collection extension: 8899/tcp
  
• Configure security (mcc)
• security level: high
• Adjust system permissions
• Add new rule
• /home/export -> 755
• Configure Samba
• /etc/samba/smb.conf
• workgroup=DTM
• check
• testparm
• smbclient -L localhost -U%
• Configure Apache
• /etc/httpd/conf/httpd.conf
  
• Listen 172.16.11.5:80
• ServerName pctoto
  
• Restore MySQL
• mysql -u root -p < mysql_yyyymmdd.sql
• tar -C / -xvzf /home/export/backup/mysql_backup_yyyymmdd.tgz
  
• Tools / Preferences 
• General Options: Store connection passwords (Obscured) (solves "Backup error: Cannot set ANSI quotes")
  
• Connections: write password
• Introduce password for the used connection
  
• Configure cron
• export EDITOR=emacs; crontab -e
  
• /var/spool/cron
• 0 23 * * * /root/backup_base_dades.sh
0 22 1 * * export USER=usuari; /usr/sbin/drakbackup --profile servidor_cvs_full.conf --daemon > /dev/null 2>&1
0 22 * * 6 export USER=usuari; /usr/sbin/drakbackup --profile servidor_cvs_differential.conf --daemon > /dev/null 2>&1
0 22 * * * export USER=usuari; /usr/sbin/drakbackup --profile servidor_cvs_incremental.conf --daemon > /dev/null 2>&1
0 23 1 * * export USER=usuari; /usr/sbin/drakbackup --profile servidor_export_cvs_full.conf --daemon > /dev/null 2>&1
0 23 * * 6 export USER=usuari; /usr/sbin/drakbackup --profile servidor_export_cvs_differential.conf --daemon > /dev/null 2>&1
0 23 * * * export USER=usuari; /usr/sbin/drakbackup --profile servidor_export_cvs_incremental.conf --daemon > /dev/null 2>&1
0 04 * * * /bin/find /var/export/backup/ -mtime -1 -type f -exec cp -pf '{}' /mnt/external_dir/copia_seguretat \; > /dev/null 2>&1
• /root/backup_base_dades.sh
• #!/bin/bash
export DB_BACKUP_DIR="/var/export/backup"
export DB_USER="root"
export DB_PASSWD="******"
export DATE="`date '+%Y%m%d_%H%M'`"
mysqldump -u$DB_USER -p$DB_PASSWD timetracker > $DB_BACKUP_DIR/backup_timetracker_$DATE.sql
mysqldump -u$DB_USER -p$DB_PASSWD wikidb > $DB_BACKUP_DIR/backup_wikidb_$DATE.sql
  
• Configure Mediawiki
• Moving a wiki
  
• using mysql-administrator, retype passwords for user:
  
• wikiuser
• restore config files:
• cp /tmp/var/www/mediawiki/LocalSettings.php /var/www/mediawiki/LocalSettings.php
• cp /tmp/var/www/mediawiki/AdminSettings.php
  
• cp -pr /tmp/var/www/mediawiki/extensions/ /var/www/mediawiki/
• cp -pr /tmp/var/www/mediawiki/images/ /var/www/mediawiki/
• cp -pr /tmp/var/www/mediawiki/papers/ /var/www/mediawiki/
• Configure WRTimetracker
  

http://www.francescpinyol.cat/linux_update.html
Primera versió: / First version: 20.III.2008
Darrera modificació: 13 de setembre de 2011 / Last update: 13th September 2011