cassandra backup and restore scripts

Tags: mysqldump mysql hot standby backup scriptPerform a full hot backup of the Extmail database daily 01:00, and you can fully recover!First, create a backup script, as follows:VI mysql_extmail_bak.sh #!/bin/bash # program # with mysqldump to Fully backup MySQL data per week! bakdir=/mysqlback# the directory to be bac

MySQL database: Gunzip 3.PURGE binary LOGS to ' mysql=bin.000011 '; Delete all binary logs before bin.00011;(Copy a log before deleting this point in time)Show binary logs; see what binary logs are in;Some changes in the period data, the database is manipulated4. Make an incremental log the next day:Mysql>flush logs; Flush after mysql-bin.0000011 for the past day operation log;#cd/mydata/data/#cp mysql-bin.0000011/root/and then back up#cp mysql-bin.0000012/root/Or#mysqlbinlog mysql-bin.000011 >

=myisamdefaultcharset=utf8;mysql>insert NBSP;INTONBSP;MYISAM_TBL (name) ->values (' One '), (' Joy '), (' Li '), (' Tom '), (' Jerry '), (' Hello ');### a good way to build data mysql>insertintomyisam_tbl (name ) ->selectnamefrommyisam_tbl;### Create a table mysql>createtableinnodb_tbl for the InnoDB engine (-> idINTNotnullauto_increment,->namevarchar (+), ->primarykey (ID) - >) engine=innodbDEFAULTcharset=utf8;# myisam_tbl data to Innodb_ TBL Table MYSQLGT;NBSP;INSERTNBSP;INTONBSP;INNODB_TBL (

backups, allowing the database to revert to the nearest current state. db_owner, dbcreator, or sysadmin. ">RESTORE with STANDBY to keep the database in read-only mode. Undo uncommitted transactions, but save the undo action in an alternate file so that the restore effect can be reversed. when this item is selected, the alternate file selection directory is activated. This item restores the unfinished tran

There are currently two major tools available for physical hot provisioning: Ibbackup and Xtrabackup, Ibbackup is expensive to authorize, and Xtrabackup is more powerful and open source than IbbackupXtrabackup provides two command-line tools:Xtrabackup: Data dedicated to backing up the InnoDB and XTRADB engines;Innobackupex: This is a Perl script that calls the Xtrabackup command during execution to implement backup InnoDB, or to back up objects of th

transaction logs, binary logs)3. Stored procedures, stored functions, triggers4. configuration file (very important, each configuration file to be backed up)5. Scripts used to implement database backup, Croutab of the database itself, etc...Third, MySQL Backup toolCommon backup tools:1.Mysql comes with

In order to ensure data security, the data needs to be backed up regularly. There are a number of ways to backup, and the effect is different. Once there is an error in the data in the database, you need to use the backed-up data for restore recovery. Thus minimizing the loss. Let's take a look at MySQL common three types of backup recovery methods: 1, using mys

Tags: sys usr object NEC traffic Roo Delta Center offThere are currently two major tools available for physical hot provisioning: Ibbackup and Xtrabackup, Ibbackup is expensive to authorize, and Xtrabackup is more powerful and open source than Ibbackup Xtrabackup provides two command-line tools: Xtrabackup: Data dedicated to backing up the InnoDB and XTRADB engines; Innobackupex: This is a Perl script that calls the Xtrabackup command during execution to implement

Tags: div from full disaster backup mode efficient way prepare failedSQL Server supports three kinds of backup methods Full backup; Differential backup Transaction log Backups The general backup method is full bac