MySQL강좌26편: MYSQL의 전체 데이터베이스 데이터 백업하기

[root@sulinux bin]# pwd

/usr/local/mysql/bin

[root@sulinux bin]#
[root@sulinux bin]# ./mysqldump -u root -p --all-databases > ALLDATA.sql

Enter password: ********

[root@sulinux bin]#

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

-rw-r--r--    1 root     root        14929  2월 14 12:25 ALLDATA.sql

[root@sulinux bin]#

[root@sulinux bin]# cat ALLDATA.sql

-- MySQL dump 9.08

---- Host: localhost    Database:

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

-- Server version       4.0.14

--

-- Current Database: locli

--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ locli;

USE locli;

--

-- Current Database: mysql

--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ mysql;

USE mysql;
--

-- Table structure for table 'columns_priv'

--

CREATE TABLE columns_priv (

  Host char(60) binary NOT NULL default '',

  Db char(64) binary NOT NULL default '',

  User char(16) binary NOT NULL default '',

  Table_name char(64) binary NOT NULL default '',

  Column_name char(64) binary NOT NULL default '',

  Timestamp timestamp(14) NOT NULL,

  Column_priv set('Select','Insert','Update','References') NOT NULL default '',

  PRIMARY KEY  (Host,Db,User,Table_name,Column_name)

) TYPE=MyISAM COMMENT='Column privileges';

--