Linux c Database Backup Version 1 and Database Backup Version 1
Mysql Database Backup Using linuxCObjective: To regularly back up the database through the alarm signalNote: It is currently the first version. You can use linux automation to implement regular
1, from MySQL official download mysql version of the source code "must be the source version"
2, the following code type Linux command line
Copy Code code as follows:
[note] Add MySQL group and user
#groupadd MySQL
#useradd-G MySQL MySQL
[note] Unpack to/usr/local
# TAR-XZF Mysql-standard-4.1.9-pc-linux-gnu-i686.tar.gz-c/usr/local
[note] Establish a soft link to facilitate the operation (t
First, the introduction of rsync
Rsync is a data mirroring Backup tool under the Linux system that enables you to back up local system data over the network to any remote host, and Rsync has the following characteristics:
Can be mirrored to save the entire directory tree and file system
Data can be incrementally synchronized, file transfer efficiency is high, so synchronization time is very short.
You c
and taken out. Almost all media can be used, because the core device driver handles low-level device operations, it seems that all devices are similar to user-level programs. There may be problems with writing tar and cpio for non-common files (symbolic connections, device files, files with extremely long path names, etc.) in UNIX versions, but Linux can correctly process all files.
Different from dump, dump directly reads the file system instead o
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
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
Quick Guide to Linux backup and recovery
Level: Entry
Chris Walden (cmwalden-at-us.ibm.com)E-commerce architect, IBM developer relationsJanuary 2004
IBM e-commerce architect Chris Walden willDeveloperWorksThe nine articles published in this article will guide you how to use your Windows Operating Skills in Linux. This section describes the content
[Linux] PHP programmers play with Linux series-backup and restoration of MySQL and linuxmysql
1. PHP programmers turn to the Linux series-how to install and use CentOS
2. PHP programmers play with Linux series-lnmp Environment Construction
3. PHP programmers play with the
Linux is a stable and reliable environment. However, any computing system has unexpected events, such as hardware faults. Reliable backup of critical configuration information is part of any responsible management plan. In Linux, you can perform backup in various ways. The technology involved ranges from very simple sc
Installation Environment: CentOS 6,mysql5.5I. BACKGROUNDrecently, the company to strengthen the database data security, automatic database backup, this article will be used under Linux crontab automatic backup and FTP upload database. Second, the implementation of the scriptCreate Script dbbackup.sh#!/bin/bashdate= ' date+%y%m%d%h%m ' database=**** #备份数据库DB_USER
(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
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
Linux backup policy (version 2), version 2Backup Policy
Backup ideas
I. potential threats to the System
System hardware faults
Software faults
Power supply faults
User misoperation
Man-made destruction
The content in the cache is not written to the disk in time.
Ø natural disasters
Ii. Selection of backup media
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
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
Article Title: backup and recovery on Linux servers. Linux is a technology channel of the IT lab in China. Including desktop applications, Linux system management, kernel research, embedded systems, open source and other basic categories for general backup should be the high
monitoring scripts#vi/srv/rsync.shRsync.sh contents are as follows:#!/bin/bashsrc=/srv/test/#监视改文件路径, folder content changes trigger server data synchronizationDes=backup #客服端配置的模块 (customer service side will introduce)Host= "192.168.10.6" #同步到的IP地址, if multiple spaces are separated. For example: host= "192.168.10.6 192.168.10.7"/usr/local/bin/inotifywait-mrq--timefmt '%d/%m/%y%h:%m '--format '%T%w%f '-e modify,delete,create,attrib $SRC | While read
5 to Linux-compression and backup, 5 to linux
I. Common compressed files in Linux
*. Z compress compressed files (not popular now, and can be decompressed using gzip );
*. Files compressed by the gz gzip program;
*. Bz2 bzip2 compressed files;
* The data packaged by the. tar program has not been compressed;
* .Tar.gz t
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.