Mysql备份和恢复
时间:2008-09-12 来源:zlj2208
mysqldump -p<username> -p<password> [--opt] <DatabaseName> [TableName] > FileName.sql
[root@fedora data]#mysqldump -uroot -p123456 mytestdb>/home/zhoulj/mytestdb.sql
[root@fedora data]# mysql -uroot -p123456 mytestdb</home/zhoulj/mytestdb.sql
mysqldump -p<username> -p<password> [--opt] <DatabaseName> [TableName] > FileName.sql
在flush binlogs之前,touch一个空文件,在第二天备份时候给这个文件比较,如果比这个文件新就备份。
# mysql -uroot -p123456 mytestdb</home/zhoulj/mytestdb.sql
/usr/local/mysql/bin/mysqlbinlog fc5-1-bin.000001 |/usr/local/mysql/bin/mysql -uroot -p123456
/usr/local/mysql/bin/mysqlbinlog fc5-1-bin.000002 |/usr/local/mysql/bin/mysql -uroot -p123456
/usr/local/mysql/bin/mysqlbinlog fc5-1-bin.00000n |/usr/local/mysql/bin/mysql -uroot -p123456