- 1、本文档共16页,可阅读全部内容。
- 2、有哪些信誉好的足球投注网站(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
- 5、该文档为VIP文档,如果想要下载,成为VIP会员后,下载免费。
- 6、成为VIP后,下载本文档将扣除1次下载权益。下载后,不支持退款、换文档。如有疑问请联系我们。
- 7、成为VIP后,您将拥有八大权益,权益包括:VIP文档下载权益、阅读免打扰、文档格式转换、高级专利检索、专属身份标志、高级客服、多端互通、版权登记。
- 8、VIP文档为合作方或网友上传,每下载1次, 网站将根据用户上传文档的质量评分、类型等,对文档贡献者给予高额补贴、流量扶持。如果你也想贡献VIP文档。上传文档
查看更多
数据库的备份与恢复 导入 导出(Database backup and recovery, import and export)
数据库的备份与恢复 导入 导出(Database backup and recovery, import and export)
SQL command database backup and recovery, import and export MySQL Export Import command use case
1. export the entire database
Mysqldump -u user name, -p database name export file name
Mysqldump, -u, zoujq, -p, urldbTT_Mart ttmart_db.sql
2. export a table
Mysqldump -u user name, -p database name export file name
Mysqldump, -u, zoujq, -p, urldbTT_Mart, b2c_categories, categories.sql
3. export a database structure
Mysqldump, -u, zoujq, -p, -d, --add-drop-table, urldbTT_Mart url_db.sql
-d does not have data. --add-drop-table adds a drop table before each create statement
4. import database
Frequently used source commands
Go to the MySQL database console,
Such as mysql, -u, root, -p
Mysqluse database
Then use the source command, followed by the script file (such as the.Sql used here)
Mysqlsource d:wcnc_db.sql
Backup and recovery of MySQL database
Free backup tools currently supported by MySQL: mysqldump, mysqlhotcopy, also can make a backup using SQL syntax: BACKUP TABLE or SELECT INTO OUTFILE, or binary log backup (binlog), can also be directly copy the data files and related configuration files. The MyISAM table is saved in a file form, so its relatively easy to backup, and several of the methods mentioned above can be used. Innodb all the tables are stored in the same data in the ibdata1 file (possibly multiple files, or file table space independent), relatively good solutions can be free backup, copy a data file, backup binlog, or mysqldump.
1, mysqldump1.1 backup
Mysqldump uses the SQL level backup mechanism, which leads the data table into SQL script file, which is relatively suitable for upgrading between different versions of MySQL, and this is the most commonly used backup method. Now lets talk about some of the main parameters of mysqldump:
--compatible=name
It tells mysqldump that the exported data will be compatible with which database or which of the older versions of the MySQL server is c
您可能关注的文档
- 拖拉机故障分析及诊断方法(Tractor fault analysis and diagnosis method).doc
- 拖延,时间不一致与如何行动(Procrastination, time inconsistency, and how to act).doc
- 招教考试语文+综合模拟试题(Chinese language teaching + comprehensive simulation test questions).doc
- 招商,学习蒙牛好榜样--从蒙牛成功上市看招商突围(Inviting businessmen to learn the good example of Mengniu -- looking at the breakthrough of Mengniu's successful listing).doc
- 招势三顾客感知风险预测——上市前的准备(Potential three customer perceived risk prediction - preparation before listing).doc
- 招势一战略部署的重要性(Recruit one potential the importance of strategic deployment).doc
- 招聘简讯(Recruitment Newsletter).doc
- 拔罐的原理和作用(The principle and function of cupping).doc
- 招聘选拔6步法管理模式(Recruitment and selection of 6 steps management model).doc
- 招聘选拔六步法管理模式(Recruitment and selection of six steps management model).doc
- 数据恢复秘技参考大全(Data recovery by reference).doc
- 数据恢复与备份(Data recovery and backup).doc
- 数据恢复秘技大全(Data recovery cheats Daquan).doc
- 数据恢复全解析(Data recovery full resolution).doc
- 数据恢复基础知识(Data recovery Basics).doc
- 数据挖掘细分客户群,精准营销赢得市场(Data mining, customer segmentation, precision marketing to win the market).doc
- 数据是可以恢复的(The data can be restored).doc
- 数据结构(专科)作业1(Data structure (specialist) job 1).doc
- 数据融合原理与方法(Principles and methods of data fusion).doc
- 数控g m代码(NC G M code).doc
最近下载
- 有效沟通技巧.pptx VIP
- 2025年福建省中国海峡人才市场漳州工作部招聘1人备考试题及答案解析.docx VIP
- 2025年河北石家庄辛集市事业单位公开招聘工作人员191名考试备考试题及答案解析.docx VIP
- 2025石家庄辛集市事业单位招聘191名笔试备考试题及答案解析.docx VIP
- 有效沟通的技巧.pptx VIP
- 再生复原科学技术在烧伤创疡等疾病临床治疗中应用.pdf VIP
- 2025年河北石家庄辛集市事业单位公开招聘工作人员191名考试备考题库及答案解析.docx VIP
- 技术质量培训系列英之地下连续墙施工.pptx VIP
- 三支一扶面试真题.docx VIP
- 有效沟通技巧.ppt VIP
文档评论(0)