linux server backup best practices

Linux backup policy (version 2)Backup policy backup ideas I. potential threats to the System ? System hardware faults ? Software faults ? Power Supply Fault ? User misoperations ? Man-made destruction ? The content in the cache is not written to the disk in time. ? Natural disasters Ii. Selection of

following command, enter the following command:Dump transaction database name WITH NO_LOGDbcc shrinkfile (Database Log File Name, 1)Enter the name of the database to be maintained in the database name above, and enter the corresponding log file name in the Database Log File Name. Note that it is not the name with a Suffix in the resource manager, but in the Enterprise Manager, the name of the log in the Log tab in the database properties (usually only a suffix ......), Click OK to add a job ste

backup. If a Linux computer has only one user, you can back up the entire system once a week or month. If there are critical files, they should be systematically copied to a removable disk. Before backup, make sure that the backup device is correctly set. Most tape backup s

1. linuxdb2 automatic backup, compression after backup, copy to another server full backup :#! Binsh # ----------------------------------- # db2 automatic backup script # bylushuai # createat2013-08-05 # ------------------------------------ # parameter Basepathhomedb2-

Not long ago, due to the DS issue, many of the previous data were lost. although not very important, I also learned the importance of data backup. As a webmaster, no matter whether it is a virtual host, vps or a single server, it is very important to have good data backup habits. I am also a little white man. After I lost data, I quickly went to the Internet to f

Article Title: Synchronous backup of rsync files from linux to linux. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source. I. EnvironmentServ

preceding method to repeat the operation steps, pay attention to the actions after each step succeeds or fails, and finally select the start step. On the "scheduling" tab, enter the scheduling cycle, that is, the cycle of regular cleaning, similar to the backup maintenance plan. If necessary, you can set the notification item after the job is completed on the "Notification" tab at the end. You need to set the operator and set the corresponding servic

target address to start the backup service task.The second is the operating system and corresponding settings. To ensure security and prevent hackers from exploiting the same system vulnerabilities, it is best to install the third system for the server in addition to timely patching. Generally, the server uses Windows 2000 or

files is allowed. Because the backup takes up some system resources, the user will find the system slow response when running the backup. 　 If a Linux computer has only one user, you can back up the entire system once a week or month. If there are critical files, they should be systematically copied to a removable disk. 　 Before

have permission to read the Datadir/db_name directory. To Restore a database method:Mysqlhotcopy back up is the entire database directory, the use can be copied directly to the mysqld specified directory (in this case,/usr/local/mysql/data/) directory, but also to pay attention to the issue of permissions, In addition, you should first delete the old copy of the database as follows:#/bin/rm-rf/mysql-backup/**//*oldthree steps to turn off MySQL

Let's start with some of the scripts we use to back up and restore Oracle databases directly using commands Oracle Data Backup: Step 1 Back up the user data. 1. Connect the Linux terminal using the database administrator account under Linux system. 2. Execute the following statement to create the "Bak_dir" folder. The code is as follows Copy

I. INTRODUCTION Rsync's common backup tool, which is currently maintained by Rsync.samba.org. Rsync uses the so-called "rsync algorithm" to provide a very fast file transfer method, so that the local and remote two of the host file synchronization between, it is mainly the transmission of the two files, rather than the entire transmission every time, so the speed is very fast. Rsync it can be paired with rsh or SSH, or it can be used as a direct socke

How do small and medium-sized enterprises choose Linux backup tools? -- Linux Enterprise Application-Linux server application information. For details, refer to the following section. Many Linux data

/20170720200333510?watermark/2/text/ ahr0cdovl2jsb2cuy3nkbi5uzxqva2fpcnvpmtiz/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/ Southeast "alt=" here to write a picture describing "title=" "/>Xtrabackup Import and export of tablesWhen you export a table, you need to enable the Innodb_file_per_table option for the server. When you import a table, you need to have the server-enabled innodb_fil

create the backup folder in the VPS home directory. ☆☆☆ II, rsync incremental backup ☆☆☆ Rsync incremental backup, requires 2 VPS, let them do data synchronization between. For example, our site in VPS A, then a is the server side, with another VPS B to do an incremental

Linux configuration file, log file full backup1, respectively set up two host to meet the test requirements Server IP host name nginx-web server 192.168.10.150 NBSP;WEB1 NB Sp Backup

:[[email protected] ~]# tar-jpcvf mysql. ' Date +%y-%m-%d '. Tar.bz2/var/lib/mysqlRestore: Catch the latest Linux distribution, install, the system data (such as account/password and home directory, etc.) with the service data (such as WWW/EMAIL/CRONTAB/FTP, etc.) one of the fill back.3.5, bird Brother's "bird Station" backup strategy:1. Host hardware: Use a separate filesystem to store the

. With the emergence of virtualized applications on various servers (including Linux servers), this capability has exploded over the past two years. Although a virtualized system can use any backup system (including shell scripts) for backup, there are many software that is most suitable for virtualization backup. For

automatically back up data in a timely manner through the network. The following describes a simple method. You only need to set up Ubuntu 10 to turn your computer into a Time Machine backup server. (PS: in theory, all Linux systems can be implemented. Because I use Ubuntu 10.10, I will only introduce how to set this system) 1. Install Netatalk Netatalk is a fr

2 is the location where the backup data is to be stored (that is, the directory address)The third one is: you have to save those tables. The following is the code for automatic scheduled backups in Linux Referring to many tutorials on the Web, plus your own tests, the following scripts are available for testing. The code is as follows Copy Code #!/bin/bash#Shell Command for