linux server backup best practices

rsync Simple The role of rsync is like the general Linux CP and SCP directive, which can be copied from the source location to the destination location, however, rsync is more efficient than CP and SCP in a copy of the file, and supports both the connection and the devices, as well as the retention of the file's owner, group Group and permissions, In the first copy of the case, rsync will copy the full file, and then again, the Delta transfer algorit

The following command backs up your entire Linux system to the ''/archive/'' file system, except for the ''/proc/'' disguised file system, ''/mnt/'', ''/archive/'' File System (there is no need to back up our backup file !), There is also a large Squid cache file (yes, in my opinion, it is a waste of backup media and does not need to be backed up) of any mounted

Out_sql= "$DATE. SQL" #备份数据库的文件名 Tar_sql= "Mysqldata_bak_$date.tar.gz" #最终保存的数据库备份文件名 $DUMP-u$db_user-p$db_pass $DB _name--default-character-set=utf8--opt-q-R--skip-lock-tables> $OUT _sql #备份 TAR-CZF $TAR _sql./$OUT _sql #压缩为. tar.gz format RM $OUT _sql #删除. SQL Format Backup files Chown $LINUX _user: $LINUX _user $OUT _dir/$TAR _sql #更改备份数据库文件

Out_sql= "$DATE. SQL" #备份数据库的文件名Tar_sql= "Mysqldata_bak_$date.tar.gz" #最终保存的数据库备份文件名$DUMP-u$db_user-p$db_pass $DB _name--default-character-set=utf8--opt-q-R--skip-lock-tables> $OUT _sql #备份TAR-CZF $TAR _sql./$OUT _sql #压缩为. tar.gz formatRM $OUT _sql #删除. SQL-formatted backup fileChown $LINUX _user: $LINUX _user $OUT _dir/$TAR _sql #更改备份数据库文件的所有者Find $OUT _dir-nam

The following script executes full backup of a database in SQL Server and transfers the backup file to another Server. Backup File naming rules: Database name_timestamp. BAK. Execution Environment windows 2003 server SQL

RHGB Quiet vga=791 the. 3 System Repair Mode//2 did not look seriously, later when used to see again1, single user mode single user mode common bug fixes? Forgot root password? Modify the system default run level2, disc Repair mode important system files are missing, which prevents the system from starting bash-4.1# chroot/mnt/sysimage #改变主目录 Sh-4.1# CD/Root sh-4.1# rpm-qf/etc/Inittab #查询下/etc/which package the Inittab file belongs to. SH-4.1# mkdir/mnt/cdrom #建立挂载点 sh-4.1# mount/dev/sr0/mnt/CD

written during the copying of the database, the data will be inconsistent. This situation is possible in the development environment, but it is difficult to allow backup servers in a production environment. Note: This approach does not apply to tables of the InnoDB storage engine, but is convenient for MyISAM storage engine tables. At the same time, the MySQL version is best when restoring.　　three , use the Mysqlhotcopy tool to quickly back upA look