文章标签 ‘mysql’
目标: 使用cron自动执行mysql备份命令备份mysql数据库 步骤: 1. shell脚本 mysqlbackup.sh ?View Code SHELL#!/bin/bash #定义变量,注意等号前后无空格 BACKUP_DIR="/root/mysqlbackup" DATE=$(/bin/date +%Y%m%d%H%M%S) FILE_NAME="testdb_$DATE.sql.gz"; echo "starting backup database" #使用mysqldump命令备份我的mysql数据库，并通过gzip进行压缩 exec /usr/bin/mysqldump -uroot -proot –default-character-set=utf8 –opt –extended-insert=false –triggers -R –hex-blob -x test_database | gzip > $BACKUP_DIR/$FILE_NAME echo "end backup database" 2. 赋予执行权限 ?View Code SHELLchmod a+x ./mysqlbackup.sh 3. 使用crontab -e命令编辑自己的crontab任务 ?View Code SHELL0 [...]
?View Code PHP< ? echo "Welcome to AppServ MySQL Root Password Reset Program\n\n"; AppServCMD(); function AppServCMD() { define(’STDIN’,fopen("php://stdin","r")); echo " Enter New Password : "; $input = trim(fgets(STDIN,256)); $input = ereg_replace(’\"’, "\\\"", $input); $input = ereg_replace(’\”, "\’", $input); echo "\n Please wait ……………………………..\n\n"; exec ("net stop mysql"); exec (’start /b e:\AppServ\MySQL\bin\mysqld-nt.exe –skip-grant-tables –user=root’); [...]
[via] Mysql ************************************ 当前列 ClassName ColumnType DisplaySize TypeName 0: java.lang.Integer ColumnType:4 11 INTEGER 1: java.lang.Integer ColumnType:-6 4 TINYINT 2: java.lang.String ColumnType:12 0 UNKNOWN 3: java.lang.Boolean ColumnType:-7 1 TINYINT 4: java.lang.Integer ColumnType:5 6 SMALLINT 5: java.lang.Integer ColumnType:4 9 MEDIUMINT 6: java.lang.Integer ColumnType:4 11 INTEGER 7: java.lang.Long ColumnType:-5 20 BIGINT 8: java.lang.Double ColumnType:8 22 DOUBLE 9: java.lang.Double ColumnType:8 22 DOUBLE 10: java.lang.Float ColumnType:7 12 FLOAT 11: java.lang.String ColumnType:12 11 UNKNOWN 12: java.lang.String ColumnType:12 11 UNKNOWN 13: java.lang.String ColumnType:1 300 CHAR 14: java.lang.String ColumnType:12 300 VARCHAR 15: java.sql.Date ColumnType:91 10 DATE 16: java.sql.Time ColumnType:92 8 TIME 17: java.sql.Date ColumnType:91 4 YEAR 18: java.sql.Timestamp ColumnType:93 19 TIMESTAMP 19: java.sql.Timestamp ColumnType:93 19 DATETIME 20: [B [...]
