Preparatory work:
Need to advance in the VPS to install good lftp,lftp function more powerful, CentOS Direct execution: Yum install Lftp,debian execution: Apt-get install.
You need to create the/home/backup/directory on the VPS and create the backup directory on FTP.
If the VPS on the database is not much to use GoDaddy free space can (10GB space, 300GB traffi
Preparations: lftp must be installed in VPS in advance. lftp is powerful. CentOS directly executes: yuminstalllftp and Debian execute: apt-getinstalllftp. You need to create the/home/backup/directory on VPS and the backup directory on FTP. If there are not many VPS databases, you can use Godaddy free space (10 GB space, 300
Preparations:
Lftp needs to be installe
FTP (FILETRANSFERPROTOCOL) as a file transfer protocol, is a common way of backup, the benefits of the operation is simple, but FTP also has some insurmountable shortcomings, such as no backup version management, upload the existence of a binary selection problem. In the current development of cloud computing, SaaS app
FTP (FILETRANSFERPROTOCOL) as a file transfer protocol, is a common way of backup, the benefits of the operation is simple, but FTP also has some insurmountable shortcomings, such as no backup version management, upload the existence of a binary selection problem. In the current development of cloud computing, SaaS app
☆☆☆ Daily automatic backup site data and database upload ftp☆☆☆
This way, the main is a script (including compressed site data and database, upload), and then use the cron command every day in a specified period of time to run, see the script code (script information needs to set itself)
The code is as follows
Copy Code
#!/bin/bash
#以下信息请自
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 ********=======
Since the beginning of the use of VPS is particularly important to focus on data security, whether we use the Web panel, or the use of a key to install the package, or even directly compile the environment, we can choose to manually backup on a regular basis, you can also use the Web Panel with the Backup tool. Today, a user mentioned the backup of the LLSMP envi
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
Linux automatic Backup and upload of remote FTP for MySQL scheduled Tasks1 , create the directory where the backup files are saved:/home/mysql_dataCd/homemkdir Mysql_data2. Create backup script file:/home/mysql_data/mysql_databak.shCd/homeCD Mysql_dataTouch mysql_databak.shVim mysql_databak.sh#!/bin/shDump=/usr/bin/my
Sqlserver remote remote backup Problem description the customer's sqlserver database server automatically backs up the T1 database every morning, and now requires that the backup files be automatically uploaded to a storage server (with FTPSERVER) at the same time solution 1. develop a window service program to copy the backu
Tags: height tools space href send address recommended install one keyIf our site update is not very frequent, we can regularly manually make backup site files and MySQL database export. If our site data update frequently, and the data is particularly important, it is recommended to use regular automatic backup, at least the need to backup data, no matter what we
/cron.weekly
4241**rootrun-parts/etc/cron.monthly
017***root /mysql_db_backup/mysql_db_backup_auto_db_filelist.sh
**/1***rootntpdate203.129.68.14hwclock-w
[root@localhost/]#cat/etc/crontab
Step 3: automatically schedule FTP on windows, save the following code as bat, and set the scheduled task
@ Echo off color 1f title automatic FTPMYSQL backup file
Mode con: cols = 60 lines = 10
Echo
Backup | Data storage Backup technology generally includes hardware technology and software technology, hardware technology is mainly tape drive technology, software technology is mainly general-purpose and special backup software technology.
Tape Drive Technology:
Both hard disk technology and optical technolo
RedHat Linux automatic FTP Transfer backup source: it165 [large, medium and small] [print this page] [Close Window]
If you want to transfer the file to another server via FTP after backing up the file in crontab, you can use the following method to compile shell script:
#! /Bin/sh
Ftphost = "ftp. server. Address"
U
Article Title: Redhatlinux automatic FTP Transfer backup. 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.
If you want to transfer the file to another server via FTP after backing up the file in crontab, you can use the follow
operation more use InnoDB, query multi-use MyISAM11.root password problem use MySQL; Find the User table copy the other user table three files to the MySQL directory "MyISAM mode storage"Or in the MYSQLD server program, there is an option "--skip-grant-table" to bypass permission authentication, and then update the user table with update to implement the password update MySQL internal cryptographic function "password ()" CanThe above is the basic kno
#!/bin/sh#数据库备份文件所在路径Db_dir=/backup/oracle/rman/dbfArchive_dir=/backup/oracle/rman/archivelog#临时目录 for uploading the files foundDb_tmp_dir=/backup/oracle/rman/dbftmpArchive_tmp_dir=/backup/oracle/rman/archivelogtmp#找出最新的数据库备份文件df_put_files= ' find/backup/oracle/rman/dbf/*-mt
Share a self-written mysql automatic backup script, timed execution settings, and windows automatic FTP. Please advise. Prerequisites: vsftpd is enabled for the mysql database server and an appropriate account is configured for the Intranet storage server.
Share a self-written mysql automatic backup script, timed exec
Description1, backup directory/home/osyunwei all the following files into the/home/osyunweibak, and save as osyunwei20120701.tar.gz compressed file format (2012_07_01 refers to the date of the day when the backup is executed), Only last 7 days of backup are retained2. Upload the backup file inside the/home/osyunweibak
****************---------------------For testing convenience,Install the vsftp RPM package on the VFTP Server IP address 192.168.159.Install the lftp RPM package on the FTP Client IP address 192.168.1.153.++
On the client host# Vi/etc/lftp_bak.shAdd the following content:
#! /Bin/bash# Specify the IP address of the FTP serverServerip = 192.168.1.159# Specify the FTP
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.