简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

mysql导出表结构命令_MySQL

WBOY
Release： 2016-06-01 13:19:06
Original
943 people have browsed it

bitsCN.com

如果将数据库中的数据导出来的话有时候一个文件都有一点多G，所以测试的时候就只需要表结构。命令如下：

  mysqldump -h127.0.0.1 -uroot -p -d DBname >D:/db.sql
Copy after login

如图所示：

如果文件较大，导出时间会比较长。请耐心等待！

bitsCN.com
Related labels：
mysql database
source：php.cn
Previous article：MySQL学习笔记_3_MySQL创建数据表（中）_MySQL Next article：SQLSERVER服务器链接连接（即sqlserver的跨库连接）_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to list data in a section by ID using while loop in PHP? I have a mysql table with these columns: series_id, series_color, product_name In the outp...
From 2023-11-17 20:03:03
0
1
290
How to make table cell values ​​hyperlinked in Dash? (Using Plotly, Dash, Pandas, etc.) I want to set the cell value under the "JobLink" column as a hyperlink. When I c...
From 2023-11-17 18:47:10
0
1
283
Best way to preload route data before accessing the route. Before rendering the page for a given route, I want to first get the necessary data synchr...
From 2023-11-17 14:54:42
0
2
379
New title: New script does not correctly display strange character encoding of stored data I'm trying to rewrite an old website. It is in Persian and uses Persian/Arabic characters....
From 2023-11-17 10:51:01
0
2
273
Nuxt.js SSG (Static Site Generator) Get API Data When building a project using a static site generator, I understand that documentation cre...
From 2023-11-16 21:36:07
0
1
176
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！