name, if not this line, indicates that it is anonymous secretsfile=/etc/backserver.pas # specifying the authentication password file location5. Provide the authentication file, and the permission must be 600# Vim/etc/backserver.pas root:123456# chmod 600/etc/backserver.pas6. Restart the service#/etc/init.d/xinetd Restart7. Synchronizing backups to 192.168.40.162Provide the authentication file, and the permissions must be 600# Vim/etc/backserver.pas 123456# chmod 600/etc/backserver.pas# mkdir-p/
name, if not this line, indicates that it is anonymous secretsfile=/etc/backserver.pas # specifying the authentication password file location5. Provide the authentication file, and the permission must be 600# Vim/etc/backserver.pas root:123456# chmod 600/etc/backserver.pas6. Restart the service#/etc/init.d/xinetd Restart7. Synchronizing backups to 192.168.40.162Provide the authentication file, and the permissions must be 600# Vim/etc/backserver.pas 123456# chmod 600/etc/backserver.pas# mkdir-p/
name, if not this line, indicates that it is anonymous secretsfile=/etc/backserver.pas # specifying the authentication password file location5. Provide the authentication file, and the permission must be 600# Vim/etc/backserver.pas root:123456# chmod 600/etc/backserver.pas6. Restart the service#/etc/init.d/xinetd Restart7. Synchronizing backups to 192.168.40.162Provide the authentication file, and the permissions must be 600# Vim/etc/backserver.pas 123456# chmod 600/etc/backserver.pas# mkdir-p/
1. Local BackupTo write an automatic backup script:Vim/var/lib/mysql/autobakThe contents are as follows:
Copy Code code as follows:
Cd/data/home/mysqlbak
rq= ' Date +%y%m%d '
/usr/local/mysql/bin/mysqldump sqldb--flush-logs-uroot-p123456--opt > 777city_$rq.sql
Save exit.
Chmod-777/var/lib/mysql/autobak
Crontab-e* * * */var/lib/mysql/autobakThe Autobak script is automatically executed every evening early in the morning./etc
Tags: remote data type SRC local images data reserved HTTP databaseYou want to restore SQL Server high-backup data to a lower version of SQLSERVER2008R2, but this is not possible to restore the database directly in SQL Server, and can be restored smoothly by the following methods.SQL scripts that are generated by a high version are executed in the lower version, and the data can also be retained.Step: Task-
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
Introduction:
Continuing with my backup articles (part two of my Amanda series coming soon ...), I thought I wowould tell you about how I do my remote backups. the program I use is rdiff-backup, with a Perl script to sort out e-mail Notification and logfile generation. I will take you through my script and show you how to enable SSH passwordless access using publ
Building a high-security e-commerce website (automatic local/remote dual-backup of website files and databases) [connected E-commerce system architecture]Source:Http://jimmyli.blog.51cto.com/I'm standing on the shoulders of giants, Jimmy LiBy Jimmy LiKeywords: website, e-commerce, Shell, automatic backup, remote
CentOS Remote Backup Using rsync
This article provides a quick way to back up the most common things in a typical Web host scenario: website files and database data. We will set up a complete daily backup of the folder of a website and copy the data to a remote server (this can also work on another VPS ). We will also
Because sometimes the computer operating system to reinstall, need to be remote backup down. Or you want to send the remote to another colleague.One, how to backup restore SECURECRT remote1. Open Options-global Options---General---configuration paths locate the profile save path, such as:2, open the C:\Users\NUC\AppDat
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 =**** #备份用户名DB_PASS = "*******" #备份用户名的密
172.00 bytes/sec Total size is
14.33M Speedup is 166,658.15
This usage is appropriate for both the file and the catalogue:
rsync-avh/path/to/myfolder/home/pi/tmp/
rsync Remote Backup
Rsync can also be used for remote backup between different machines, which is similar to the SCP instruction, but rsync is more eff
Export of dataexp qh/[emailprotected] file= ' d:\backup\qh\qh20060526.dmp ' grants=y full=n 1 Fully export the database test, user Name System Password Manager export to D:\DAOCHU.DMP exp system/[emailprotected] File=d:\daochu.dmp Full=y 2 Export the table of system user and SYS user in database exp system/[emailprotected] File=d:\daochu.dmp owner= ( System,sys) 3 The table in the database table1, table2 export exp system/[emailprotected] File=d:\
Remote automatic backup of Oracle Data
Remote automatic backup of Oracle Data
The ORACLE tutorial is: remote automatic backup of Oracle data in the database. In large commercial applications,
you specify a subdirectory, the program will download only the files in the subdirectory, and the next folder does not do any action.
The local directory, please specify an existing directory, including "\", the program will automatically create the same folder on the server
Seven, the log record file directory, also exists.
OK, you can now double-click this batch to perform the operation!
@echo off Echo ********====================================================== Echo ********=======
The ORACLE tutorial is: remote automatic backup of Oracle data in the database. In large commercial applications, Remote Disaster Recovery and backup of data are very important and necessary. Based on my practical experience, I have designed a simple method to implement automatic b
The ORACLE tutorial is: remote automatic backup of Oracle data in the database. In large commercial applications, Remote Disaster Recovery and backup of data are very important and necessary. Based on my practical experience, I have designed a simple method to implement automatic b
Record local and remote oracle backup in linuxClient server environment: rhel-server-5.4-x86_64 + oracle10g remote backup server environment: windows server 2008 network environment: formal server on the internet, remote backup se
In large commercial applications, Remote Disaster Recovery and backup of data are very important and necessary. Based on my practical experience, I have designed a simple method to implement automatic backup of remote data for the reference of database administrators. All the programs in this article have been tested a
Automatic Oracle Remote Data BackupNowadays, it has been widely used in many places. For example, in large commercial applications, Remote Disaster Recovery and backup of data are very important and necessary. Based on my practical experience, I have designed a simple solution to achieve automatic backup of
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.