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
(The example in this article is implemented based on FreeBSD/Linux, and you need to modify it on your own in the Windows environment)An important mission of configuration management is to ensure data security and prevent the catastrophic consequences of the failure to recover data due to disk damage or misoperations on the server. Therefore, it is very important to develop a complete backup policy.
Generall
Backup essentials:Considerations for backing up data:
Which files to back up:what data is important to the system or user? That data is the data worth backing up! such as /etc/* and /home/* .
What backup media to choose:is it a read-write disc, another hard drive, a different partition on the same drive , or a network redundancy system? Which one is the fastest, cheapest, and can keep the data for th
Source: Network/Editor: getting started with programming Author: E Jian
The goal of this article is to execute a shell script to complete the entire process of automatic Oracle database backup, and to generate compressed files in the current directory. The specific implementation steps are as follows:
1. log on to Linux as an oracle user.
2. Create a database. srcept file to generate some pa
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 backup products are constantly
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 backup, then B is the cli
/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_file_per_table and Innodb_expand_import options
Export table
Innobackupex--apply-log--export
Many Linux data backup products are constantly adding new features and starting to become more mainstream in the enterprise. Currently, most major storage management vendors (such as HP and Symantec) have managed their storage
Many Linux data backup products are constantly adding new features and starting to become mor
For the system, we can have a lot of ways to back up (restore) the system or file, the reason is to do the backup, is to be in the system or file damage, the timely recovery, reduce the loss to a minimum. Of course, the importance of backup is important for enterprise servers. Let's discuss in detail today how to use dump and restore for backup and restoration in
Backup is very important. Backup can minimize the loss. However, the backup in Linux makes a beginner feel that it is not as simple as in Windows. In fact, once you go deep, you will find that the backup in Linux is quite flexible
frequently updated:# # Mysqldump sample_db Articles comments Links >/usr/backups/mysql/sample_db.art_comm_lin.2008-1-6.sqlThe above command backs up the articles, comments, and links three tables.To recover data using commands:#mysql –u-p db_backup Note You must ensure that the database is running when you use this command.2 Using the SOURCE syntaxIn fact, this is not the standard SQL syntax, but the functionality provided by the MySQL client, such as:# source/tmp/db_name.sql;The absolute path
Preface: The previous article briefly introduces the concepts of backup and recovery for Linux systems, followed by a previous article on two commonly used backup and restore commands.1 Common Backup commandsBefore you introduce the backup RESTORE command below, let's briefl
Article Title: several common backup methods in 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.
System backup is a very important
1.RsyncThis is a popular command-line Backup tool among Linux users and is especially popular with system administrators. It has a wealth of features, including incremental backups, updating the entire directory tree and file system, local and remote backups, and preserving file permissions, ownership, links, and more.It also has a graphical user interface called Grsync, but one advantage of rsync is that e
Rsync is a data image backup tool in Linux. It can be seen from the software name-remotesync. Rsync supports most Unix-like systems, including Linux, Solaris, and BSD.
I. rsync
CommandIntroduction
Rsync is a command for Synchronizing files to a Linux system. It can synchronize two computers to files and directories, an
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 Server
192.168.10.20
backup
Nginx Command parameters:Such as:NGINX-T: Test configuration is correct:This indicates that the configuration file has any problems with the wood.Nginx-s Reload: Action Load Latest configurationThe main function of this command is to do the process without interruption.Nginx-s Stop: Stop NowThis is no matter 3,721 straight stop off.Nginx-s quit gracefully StopThis is done when you perform the request before the stop is given.Nginx-s Reopen reopen LogGeneral Small Site No one cares what day, but
Article Title: A simple Linux data backup solution. Linux is a technology channel of the IT lab in China. Linux data backup, including desktop applications, Linux system management, kernel research, embedded systems, open source,
Article Title: Application of Backup Recovery Technology in 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.
This article describes how to use
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.