proxmox backup

Percona xtrabackup ( PXB) is a backup tool developed by Percona Company for the physical hot standby of MySQL database, supporting MySQL (Oracle), Percona Server and MariaDB, and all open source, is the industry's conscience. Tool SetAfter the package is installed, there are 4 executable files, as follows:usr├── bin│ ├── innobackupex│ ├── xbcrypt│ ├── xbstream│ └── xtrabackupThe most important is the innobackupex and xtrabackup , the former is

When SQL injection is used to obtain the database permission, you can do a lot of work next, such as looking for the administrator password and background management, to help you get WEBSHELL, but this article is about log backup, the pony backed up by LOG is small in size and the backup is successful. Therefore, it is my first test method for database permissions.However, in LOG

mysql> select * from mm;+------+| a |+------+| 1 || 2 || 3 || 4 |+------+4 rows in set (0.00 sec)mysql> show tables;+----------------+| Tables_in_inno |+----------------+| mm || t |+----------------+2 rows in set (0.01 sec)mysql> insert into mm select 9999;Query OK, 1 row affected (0.01 sec)Records: 1 Duplicates: 0 Warnings: 0mysql> insert into t select 9999;Query OK, 1 row affected (0.16 sec)Records: 1 Duplicates: 0 Warnings: 0mysql>mysql> select * fr

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

ZZ http://www.cnblogs.com/coffee_cn/archive/2010/03/26/1697038.html Set in Cron, perform every Monday 2 o'clock in the morning (full backup every Monday, incremental backup for the rest of the time) #vi backup.sh #!/bin/bash # define dayofweek= ' date ' +%u ' today= ' date ' +%y%m%d ' source=/data/　　　　backup/ # action CD $

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

A -- Full backup Declare @ Filename Varchar ( 100 ) Set @ Filename = ' D: \ data backup \ ' + Convert ( Varchar ( 10 ), Getdate (), 120 ) + ' . Bak ' Backup Database Coaltraffic To Disk = @ Filename With Init B -- Differential

Software name: Happy backup system reinstallation backup AssistantSoftware Version: V1.0 BetaRelease type: freeDevelopment Platform: Simplified Chinese Windows XPRunning platform: Simplified Chinese Windows XPResolution: 1024 × 768 (recommended)Color: Over 65536 colors When you need to reinstall the Windows XP operating system, this software automatically backs up or recovers frequently used and easil

From: http://bbs.xiamenwcdma.com/space.php? Uid = 12 Update one-click installation and backup. It is difficult to manually uninstall and load the previous version. If you choose to restore the text message to uninstall and load during installation, the subsequent registry import will be invalid, So modify it.The other reason is that my first HD {Function onclick (){Function onclick (){Tagshow (Event)}}} "> Template, so release a new version. Update re

Fault case: problems that may be caused by regular backup and fault case backup Scenario 1: The database memory is 1.5 GB, with few businesses. The qps is less than 10 at ordinary times. The memory usage soared to 100% from to every morning. When the memory is 100%, the qps surge to 20, cpu usage also surges Solution 1. Check that the buffer pool size is 900 MB. Mysql> show variables like '% innodb_buffer_