Instance method for mysql automatic incremental backup (local backup and remote backup) bitsCN.com
1. local backupCompile an automatic backup script:Vim/var/lib/mysql/autobakThe content is as follows:Cd/data/home/mysqlbakRq = 'dat
1. Local backupCompile an automatic backup script:Vim/var/lib/mysql/autobakThe content is as follows:Copy codeThe Code is as follows:Cd/data/home/mysqlbakRq = 'date + % Y % m % d'/Usr/local/mysql/bin/mysqldump sqldb -- flush-logs-uroot-p123456 -- opt> 777city _ $ rq. SQLSave and exit.
Chmod-777/var/lib/mysql/autobak
Crontab-e00 00 ***/var/lib/mysql/autobakThe aut
1. Local backupCompile an automatic backup script:Vim/var/lib/mysql/autobakThe content is as follows:
Copy codeThe Code is 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 and exit.
Chmod-777/var/lib/mysql/autobak
Crontab-e00 00 ***/var/lib/mysql/autobakTh
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/a
The message "whether the local message password is lost or the chat record is backed up" is displayed. If yes, the message "saved on Q/msgbak/msgex_20090418163057.db" is displayed ". In this case, a file msgbak/msgex_20090418163057.db is generated after the backup (20090418163057 indicates the date on which the record is lost ), generally, it is stored in the msgbak folder (for example, C:/program files/qq2
MYSQL database automatic local remote dual-backup MYSQL incremental backup to build a high-security E-commerce website (automatic local/remote dual-backup of website files and databases) architecture diagram
We will continue to introduce the e-commerce system architecture
Construction of high-security e-commerce website (website file and database automatic local/offsite dual backup) architecture diagramContinue to introduce Linux server file backup, database backup, data security storage related e-commerce system architecture. There are a variety of solutions for security, where data
Construction of a high security E-commerce site (Web site files and database automatic local/remote dual backup) architecture diagram
Continue to introduce Linux server file backup, database backup, data security storage-related E-commerce system architecture. There are a variety of solutions for security, where dat
First modify the script for necessary configuration, and then run it as the root user. 1. first, the first parameter is used for remote backup. 2. local parameter for local backup 3. note 1: You need to add a user to Mysql on another host .. where to configure: # definehostandmysqlpasswordREMOTE_HOST
First modify the s
First modify the script for necessary configuration, and then run it as the root user. 1. first, the first parameter is used for remote backup. 2. local parameter for local backup 3. parameter-free remote backup note: you need to add a user to the Mysql user on another host
First modify the script for necessary configuration, and then run it as the root user.
1. The first parameter is used for remote backup.2. local Parameters for local backup3. No parameter is required for remote backup. Note: You need to add a user to the Mysql user on another host ..Configuration:
# Define host and mys
Modify the script to make the necessary configuration, and then execute it as the root user.
1. First when performing a remote backup.
2. Local Backup
3. Remote backup without parameters
Note: You need to add users to a MySQL user on another host ...
Where to configure:
# define host and mysql password REMOTE_
knowledge is involved here. For example, if you are not in the same domain as the server, the ing may cause problems. The prompt from the database is always strange, such as the wrong user name.
4. The database with init on the backup server overwrites ¦ noinit to add
Backup database name to disk = 'C:/backup file name. Bak' with init
5. Copy the
1. How to Use Dell DataSafe Local Backup to create system recovery mediaDell DataSafe Local Backup is a secure, simple, and highly reliable Local Backup and recovery solution that helps Dell Computer users avoid software faults an
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
A recent deployment of a system, in the data security considerations, so the corresponding database server scheduled backup, and data synchronization to the backup service. Before in another project also did the corresponding operation, but the operation is to follow the found article step-by-step operation, encountered some details of the problem is not recorded, so in this deployment process encountered t
Who's going to help? Modify the current code backup MySQL PHP code requires backup to local
I use the web-based PHP backup MySQL data code, the article title is: Back up the MySQL database PHP code (a table a file). The code at the bottom of the post.
But now can only back up to the directory of the virtual host, now
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-
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.