MySQL강좌33편: 데이터는 백업하지않고 테이블 스키마만 백업하기

[root@sulinux bin]# pwd

/usr/local/mysql/bin

[root@sulinux bin]#

[root@sulinux bin]# ./mysqldump -u root -p -d temp_db2 > temp_db2.sql

Enter password: ********

[root@sulinux bin]#
[root@sulinux bin]# ls -l temp_db2.sql

-rw-r--r--    1 root     root         1422  2월 14 16:29 temp_db2.sql

[root@sulinux bin]#

[root@sulinux bin]# cat temp_db2.sql

-- MySQL dump 9.08

--

-- Host: localhost    Database: temp_db2

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

-- Server version       4.0.14

--

-- Table structure for table 'Demo_Domain'

--

CREATE TABLE Demo_Domain (

  d_id smallint(7) unsigned NOT NULL auto_increment,

  d_name varchar(255) default NULL,

  d_type varchar(10) default NULL,

  d_sday varchar(20) default NULL,

  d_eday varchar(20) default NULL,

  d_email varchar(255) default NULL,

  d_register varchar(60) default NULL,

  hosting char(1) default NULL,

  h_name varchar(255) default NULL,

  h_homepage varchar(255) default NULL,

  h_price varchar(20) default NULL,

  h_sday varchar(20) default NULL,

  h_eday varchar(20) default NULL,

  h_memo text,

  PRIMARY KEY  (d_id)

) TYPE=MyISAM;

--

-- Table structure for table 'Demo_DomainAdmin'

--

CREATE TABLE Demo_DomainAdmin (

  admin_id varchar(12) NOT NULL default '',

  admin_pass varchar(40) default NULL,

  PRIMARY KEY  (admin_id)

) TYPE=MyISAM;

--

-- Table structure for table 'Demo_DomainDrop'

--

CREATE TABLE Demo_DomainDrop (

  drop_id smallint(7) unsigned NOT NULL auto_increment,

  drop_name varchar(255) default NULL,

  drop_day varchar(20) default NULL,

  PRIMARY KEY  (drop_id)

) TYPE=MyISAM;