mysql 备份结构_mysqldump如何只备份表结构

用--no-data选项，例如:

C:\Users\duansf\Desktop>mysqldump -uroot -p123456 --no-data --databases test > test.sql

test.sql内容如下:

-- MySQL dump 10.13  Distrib 5.5.13, for Win32 (x86)

--

-- Host: localhost    Database: test

-- ------------------------------------------------------

-- Server version5.5.13

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=&