Thread View: cn.bbs.comp.database
1 messages
1 total messages
Started by Dem����ɫ�н�����
Mon, 15 Feb 2010 01:53
��3������Mysql��ݿ�
Author: Dem����ɫ�н�����
Date: Mon, 15 Feb 2010 01:53
Date: Mon, 15 Feb 2010 01:53
56 lines
2145 bytes
2145 bytes
ֻ�谴������3������һ�ж�������ƿ�֮�£� ��һ�����ڷ����������ñ���Ŀ¼ ���룺 mkdir /var/lib/mysqlbackup cd /var/lib/mysqlbackup �ڶ�������д���ݽű� ���룺 vi dbbackup.sh ճ�����´��룬��ظ�����е�username,password��dbname�� ���룺 #!/bin/sh #Username to access the MySQL server USERNAME="username" # Username to access the MySQL server PASSWORD="password" # List of DBNAMES for Backup DBNAME="dbname" #date timestamp for log message DATE=`/bin/date +%Y-%m-%d_%Hh%Mm` #output file OUTDIR="/var/lib/mysqlbackup/" OUTFILE="ip_bindass".$DATE."sql.gz" #working directory DIR="/var/lib/mysqlbackup/" #cd $DIR # MySQL Backup /usr/bin/mysqldump --database $DBNAME --opt --single-transaction -u$USERNAME -p$PASSWORD | /usr/bin/gzip -9 > $OUTDIR$OUTFILE ��ı��ݽű�Ȩ�� ���룺 chmod +x dbbackup.sh ������crontab��ʱִ�б��ݽű� ���룺 crontab -e ��ÿ������3��20���ݣ�������´��룬 ���룺 20 15 * * * /var/lib/mysqlbackup/dbbackup.sh http://article.yeeyan.org/view/50012/84158 -- http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg [m[1;34m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.29][m
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads