没错啊,在我机器上执行很好
版本4.0.21-NT,结果:--
-- Current Database: mysql
--CREATE DATABASE /*!32312 IF NOT EXISTS*/ mysql;USE mysql;--
-- Table structure for table `columns_priv`
--DROP TABLE IF EXISTS 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';........
版本4.0.21-NT,结果:--
-- Current Database: mysql
--CREATE DATABASE /*!32312 IF NOT EXISTS*/ mysql;USE mysql;--
-- Table structure for table `columns_priv`
--DROP TABLE IF EXISTS 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';........
mysqldump --add-drop-table -h127.0.0.1 -uroot -p --all-databases > db.sql
用--single-transaction试试