digitalocean backup

Mongolerman backup script and automatic deletion of duplicate backup files #!/bin/shsource /home/oracle/.bash_profileif [ -z $1 ]then echo "Please Input a number,Usage: 0|1|2" exitelse RMAN_LEVEL=$1fiexport ORACLE_SID=xxxxexport TODAY=`date '+%Y%m%d'`export RMAN_DIR=/backup/archivelog/rman/$ORACLE_SID/$TODAY-$RMAN_LEVELmkdir -p $RMAN_DIRcd $RMAN_DIRLogFile=ora

Share a php MYSQL backup class library and a phpmysql backup class library. Share a php class library for MYSQL backup. the phpmysql backup class library just needs to study how to back up the database and share a php class library for MYSQL backup? Php ****** share a php cl

This article mainly describes the actual steps for starting a backup in the DB2 backup test. If you are interested in the actual steps for starting a backup in the DB2 backup test, you can click to view the following articles. The following is a detailed description of the articles. I hope you can learn from them. DB2,

I used to think that the full backup of SQL Server only backs up the data in the database and does not contain logs. In fact, this is an error. Using RESTOREHEADERONLY can help us verify (msdb. db I used to think that the full backup of SQL Server only backs up the data in the database and does not contain logs. In fact, this is an error. Using RESTOREHEADERONLY can help us verify (msdb. db I used to

after the measurement product deploys the service end, because the service side has each kind of encapsulation encrypted attachment, the file and so on data, in order to safeguard the security of the information, in addition to establish the high availability backup mechanism, we can through the batch script, unifies to the system plan to carry on the local or the offsite backup, takes the capacity situatio

............... wuwu .... all are lost. it is still a problem of your own. If it is not a misoperation, it will not lead to such a result. This kind of thing should not happen at the same time. Let's get started with the question, how to back up data? Let's talk about the classification of important materials (my personal classification)PasswordWebsite PasswordWebsite password, domain name password, space password, server user passwordDocument TypeImportant documents for personal work, su

Share a MySQL database shard backup script (original) and a mysql database shard backup script Share a MySQL database shard backup script (original) Development ideas: 1. path: Specify the backup location and define the path (first determine whether a directory exists and no directory exists). My path:/mysql/

Oracle Rman backup script and automatic deletion of duplicate backup files, mongolerman #!/bin/shsource /home/oracle/.bash_profileif [ -z $1 ]then echo "Please Input a number,Usage: 0|1|2" exitelse RMAN_LEVEL=$1fiexport ORACLE_SID=xxxxexport TODAY=`date '+%Y%m%d'`export RMAN_DIR=/backup/archivelog/rman/$ORACLE_SID/$TODAY-$RMAN_LEVELmkdir -p $RMAN_DIRcd $RMAN_D

Today an accident, I wrote the diary of the big half month the encrypted file is damaged and cannot be recovered. He decided to write a dedicated backup script file. The main idea is to create a folder under current directory backup based on today's date, and then copy the files to that folder. The script files are as follows: Copy Code code as follows: echo off Echo ******** starts backing up

MySQL backup and recovery-percona-xtrabackup incremental backup and recovery bitsCN.com article review In the previous article, we talked about the use of percona-xtrabackup software. This article describes how percona-xtrabackup achieves incremental backup and recovery. 2. incremental backup How to implement incre

We usually create BackupIn SQL Server, We can achieve this through the following method: Steps for automatic backup in SQL Server 2005 database: 1. Open SQL Server Management Studio 2. Start the SQL Server proxy 3. Click job> create job. 4. Enter the job name in "regular" 5. Create a step, select the T-SQL type, and enter the following statement in the following command (the red part should be changed according to your actual situation, D: sql2005ack

Tags: data manipulation mysql location requires MySQL incremental backup output speed ICA technology shareIn a production environment, the security of data is critical, and any loss of data can have serious consequences. So the database needs to be backed up. Here is an example of a new mysql5.7.First, database backup classification: From a physical and logical point of view, backups can be divided

Mysql daily backup and incremental backup script bitsCN.com INTENDED AUDIENCE This article is tested in linux and mysql 4.1.14. after modification, it may be applicable to mysql 4.0, 5.0 and other versions. This article is applicable to mysql that does not enable replication. If replication is started, you may not need to adopt this backup policy or modify releva

Oracle cold backup and Hot Backup scripts cold backup scripts: set feedback offset heading offset verify offset trimspool offset echo offset time offset timing offset pagesize 0set linesize 200define dir='/backup/cold/mike';define diroutmike='/u01/scripts/coldscr/mikecoldout.sql';spool diroutmikeselect '!cp '||name||'

1. Back up a database ######################################## ########################### Back up a database ########## ######################################## ################# root user, create the Backup Directory mkdir-p/usr/local/cncounter/mysql_dumpcd/usr/local/cncounter/mysql_dump # export the database, Hot Backup mysqldump-u root-pmypasssecret cncounter> counters 2. Restore A Database ############

MySql backup and recovery, MySql backup and recovery 1. mysql backup: Query the database to be backed up: 1: mysql -u root -psywu 2: 3: mysql> show databases; 4: +--------------------+ 5: | Database | 6: +--------------------+ 7: | information_schema | 8: | cdcol | 9: | mysql | 10: | performance_schema | 11: | phpm

This article mainly introduces how to use cold backup in the real environment of MySQL backup and recovery. if you need it, refer to the previous article (cold backup of MySQL backup and recovery. However, there is a problem. The data files we store are stored on the current local disk. if this disk fails, the data we

This script implements the following functions: 1. Backing up mysql databases online; 2. Saving backup logs to log files; 3. compressing data backup files; 4. Remotely ftp the compressed file to the backup server; 5. deleting data that has been backed up locally for more than seven days is mainly to prevent the abnormal growth of the disk space of the production

We can use the following method to set the fingerprint backup password:1. Click set in.2. Click lock screen and fingerprint in settings.3. Then we can find the unlock type on the page ].4. Enter the backup password of the fingerprint lock to verify your identity. The backup password of the fingerprint lock here is "hybrid password", so you need to enter

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 applications based on data backup are increasing