mysql数据库备份的问题

Mysql数据库的常用备份方法是使用使用实用程序mysqldump, 其命令格式如下

　# mysqldump [options] database [tables]

其参数的含义为：

options：代表mysqldump的选项，通过mysqldump –help可以查到。

database: 代表将要备份的数据库

tables: 代表将要备份的表，如果不指定任何表，则备份整个数据库。

使用 mysqldump进行备份非常简单，如果要备份数据库” phpbb_db_backup ”,使用命令：

#mysqldump –u -p phpbb_db_backup >/usr/backups/mysql/ phpbb_db_backup.2005.5.6

还可以使用gzip命令对备份文件进行压缩：

#mysqldump phpbb_db_backup | gzip >/usr/backups/mysql/ phpbb_db_backup.2005.5.6。gz

恢复数据使用命令：

#mysql –u -p phpbb_db_backup </usr/backups/mysql/phpbb_db_backup.2005

Released in 2001-2002,Wholesale Jordan Shoes, the Air Jordan 17 was the first sneakers that Michael Jordan the second times to come back to play basketball for the Washington Wizards, so he devoted himself to design the sneakers. The innovation of this sneakers came from the Jazz music, which made this kind of sneakers become the most expensive in the Air Jordan sneakers ever released. Firstly, its noticeable feature is the dynamic fit sleeve which expends far past the length of the sneakers. And the heel features a metal lacing eyelets, a midfoot cover which provides a customized, supportive fit. Secondly, it features a lightweight phylon midsole with blow molded heel Air-sole unit and forefoot tuned air unit, TPU heel stabilizer for heel and ankle suppout. And the full length composite shank plate provides increased support and prevents turf toe. Thirdly, it is equipped well with a removable mid-foot strap, dynamic fit, hidden quick lace system,nike air jordans, lace locks, leather upper and carbon fiber sheath. Welcome to buy the high quality and low price Jordan sneakers from us, we will give you the best service. All the items are come with the original boxes, logoes and tags. Hope you will have a pleasant shopping experience with us.

相关的主题文章：

jordan sneakers wearing the Air Jordan 2

cheap designer handbags making them as popular as the Jordan 1

nike air max air max 2010

Cheap Jordans include Air Jordan1,Air Jordan 2....Air Jordan 23,Air Jordan 2009,Air Jordan 2010,Air Jordan 25,Air Jordan &AF1 Fusions,True Flight,Flight 45,etc.

Now Cheap women Jordans and Cheap Kids Jordans are hot selling here and there!

你没有重定向输出的目标文件。

如果没有指定目标文件，mysqldump默认将结果print出来。

mysqldump -h localhost -u root -p test >backup.sql

---