mysql backup shell script

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 applica

1. Install Mutt mail Client # yum Install Mutt-y 2. Create a script # vi/etc/rc.d/mail_to_bak_daily.sh Version One: #!/bin/bash # ========================================================= # Please enter which separate directory you want to put the backup data in basedir=/backup/ Daily # ============================================

($ backupdir, 0755, true);} // delete the backup file get_dir_files ($ backupdir, $ returnval) in the last 10 days; if ($ returnval) {foreach ($ returnval as $ v) {$ time = filemtime ($ v); if ($ time Mysqlbackup. bat: D: \ xampp \ php \ php.exe-q D: \ wamp \ www \ php_lib \ basic \ mysqlbackup. phpPause; Linux shell backup

($handler=Opendir($currPath)) { while(($fileName=Readdir($handler)) !==false) { if($fileName! = '. ' $fileName! = '. ' $fileName[0]! = '. ') { if(Is_file($currPath. '/' .$fileName)) { $returnVal[] =$currPath. '/' .$fileName; } } } Closedir($handler); } } }?> Mysqlbackup.bat: D:\xampp\php\php.exe-q D:\wamp\www\php_lib\basic\mysqlbackup.phpPause Linux sys

MySQL backup script and mysql script Mysqlbackup. php: Mysqlbackup. bat: D: \ xampp \ php \ php.exe-q D: \ wamp \ www \ php_lib \ basic \ mysqlbackup. phpPause; Linux shell backup

First, write backup and clear old log shell script: Copy Code code as follows: #!/bin/sh #backup Eoslog #author Rhao #date 2008-12-27 #定义环境变量Eos_home=/home/eosSas_home=/home/eos/sas # Test primary and secondary nodes.If test-d '/home/eos/sas/sas1_web1 'ThenSas_log_home= $SAS _home/sas1_web

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 relevant parameters.

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

Full_backup; Add_backup ##调用函数, the execution order of the code is the last execution of the function, first two judgment statements are executed before the function processing---------------------------------------------------------------------------------------------------------The following is my test information:650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M00/8F/82/wKioL1jjTUmhGOW1AAA1C5iEx0Y277.png-wh_500x0-wm_ 3-wmp_4-s_1501796330.png "title=" Qq20170404153643.png "alt=" Wkiol1

Mysql backup script and delete the backup file bitsCN.com from the previous five days USER = root # Database username PASSWORD = cucrzmysql # database user PASSWORD # DATABASE = idssr # DATABASE name For DATABASE in 'ls/mysql/data/mysql