MYSQL资料大全

http://www.chinaitlab.com/www/special/mysql.asp
http://tech.ccidnet.com/pub/column/c1108.html
http://bbs.caoyuan.net/viewtopic.php?t=2030&view=previous MySQL管理员指南

**mysql 数据备份和恢复方法

** mysqldump
备份整个数据库
mysqldump -u root -ppassword databasename >data.sql
备份某个或多个表
mysqldump -u root -ppassword databasename table1name table2name >data.sql
只备份数据结构
mysqldump -u root -ppassword databasename --no-data >data.sql
恢复
mysql -u root -ppassword --database=databasename

 1<data.sql ##="" *="" --add-drop-table="" --all-databases="" --opt="" -f="" -pabc="" -uroot="" bin="" local="" mysql="" mysqldump="" mysql备份恢复="" usr="" 备份：=""> /back/mysql-back.sql   
 2tar czvf /back/mysql-back.tgz /back/mysql-back.sql//整个数据库 
 3
 4/usr/local/mysql/bin/mysqldump --add-drop-table --opt -f -uroot -p123 ywrc &gt; /home/back/www/ywrc.sql   
 5tar czvf /home/back/www/tar/ywrc-back.tgz /home/back/www/ywrc.sql//单个数据库 
 6
 7恢复mysql ywrc &lt; ywrc.sql   
 8  
 9---  
10  
11* * *
12
13%mysqldump samp_db &gt;/usr/archives/mysql/samp_db.1999-10-02   
14%mysqldump samp_db | gzip &gt;/usr/archives/mysql/samp_db.1999-10-02.gz   
15%mysqldump samp_db student score event absence &gt;grapbook.sql   
16%mysqldump samp_db member president &gt;hist-league.sql   
17%mysqladmin -h boa.snake.net create samp_db   
18%mysqldump samp_db | mysql -h boa.snake.net samp_db   
19%mysqldump --add-drop-table samp_db | mysql -h boa.snake.net samp_db   
20  
21% ls -t -r -1 update.[0-9]* | xargs cat | mysql --one-database db_name   
22%mysql --one-database db_name &lt; update.392   
23%mysql --one-database db_name &lt; update.393</data.sql>