星空网 > 软件开发 > 数据库

mysql命令行工具

mysqldump

 

mysqldump -u root -d -R --add-drop-table basedata >basedata.sql

 

-d只有表结构即列信息,无内容即行信息

·   --no-data, -d

           Do not write any table row information (that is, do not dump table contents). This is
           useful if you want to dump only the CREATE TABLE statement for the table (for example,
           to create an empty copy of the table by loading the dump file).

 

·   --routines, -R

           Include stored routines (procedures and functions) for the dumped databases in the
           output. Use of this option requires the SELECT privilege for the mysql.proc table. The
           output generated by using --routines contains CREATE PROCEDURE and CREATE FUNCTION
           statements to re-create the routines. However, these statements do not include
           attributes such as the routine creation and modification timestamps. This means that
           when the routines are reloaded, they will be created with the timestamps equal to the
           reload time.




原标题:mysql命令行工具

关键词:MYSQL

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

tiktok俄罗斯网红:https://www.goluckyvip.com/tag/83903.html
tiktok海外变现:https://www.goluckyvip.com/tag/83904.html
tiktok国际版免登录版:https://www.goluckyvip.com/tag/83905.html
营运tiktok:https://www.goluckyvip.com/tag/83906.html
tiktok达人联盟:https://www.goluckyvip.com/tag/83907.html
免插卡tiktok:https://www.goluckyvip.com/tag/83908.html
在古巴做游轮 古巴旅游项目:https://www.vstour.cn/a/363194.html
西藏旅游攻略自驾游需要多少天 去西藏旅游自驾游要多久时间:https://www.vstour.cn/a/363195.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流