Backup Database
mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql
Add Drop Table - This option is useful if you would like to create a backup file which can rewrite an existing database without having to delete the older database manually first.
mysqldump -–add-drop-table -uusername -ppassword databasename > backupfile.sql
Directly Compress Data from a Database
mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz
Back up Only Specified Tables
mysqldump -hhostname -uusername -ppassword databasename specific_table1 specific_table2 > backupfile.sql
Backup Multiple Databases
mysqldump -hhostname -uusername -ppassword –databases databasename1 databasename2 databasename3 > multibackupfile.sql
Back up Only the Database Structure
mysqldump –no-data –databases databasename1 databasename2 databasename3 > structurebackupfile.sql
Backup up All Databases on a Server
mysqldump –all-databases > allbackupfile.sql
Restore Database
mysql -hhostname -uusername -ppassword databasename < backupfile.sql
Restoring Zipped Files
gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename
Moving Database to a New Server
mysqldump -uusername -ppassword databasename | mysql –host=*.*.*.* -C databasename
Backup and Restore MySQL Database with Shell Access
上一篇：几个常见的SEO错误观点
下一篇：第一次使用服务器的站长常犯的一些小错误
- 油价攀升刺激股市创新高 谷歌逆市急跌
- 访谈PlentyofFish.com的站长Markus Frind
- 用西联快汇收取Google Adsense收入
- 什么是CMS
- 使用FTP登录远程服务器出现无法列表错误
- Google AdSense 西联汇款被取消了
- 如何把CN域名转到国外？
- 哈佛辍学生当黑客 如今身价十亿英镑
- 相片软件下载
- Applying to the AzoogleAds Network
- 如何设置WordPress首页显示摘要而不是全文
- Domain Parking Affiliate Programs
- 美国论坛用语小讲
- T60/X60 SATA 硬盘驱动下载及安装
- PHP5的php.ini文件在PHP的安装目录下
- 笔记本电脑电池长寿秘方
- 站长常用英语
- 读“史玉柱五百亿财富如何得来”有感
- 常见职位英语对应表
- 做什么事情都要循序渐进
