mysql导入setup.sql没成功？

2011-01-11 12:43:30 122 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

yschat2010 墨衍会员 · AI 创作全网分发关注 + 加入社区

BCIC IV 2a数据集：从下载到实战应用全解析本文全面解析了BCI Competition IV 2a（BCIC IV 2a）数据集的应用流程。从官方渠道下载数据、解析其结构，到在MATLAB和Python环境中进行数据导入、预处理（包括处理特殊受试者A04T），并详细演示了从特征提取（如CSP）到分类（如LDA、SVM）的完整实战步骤，为脑机接口研究者提供了从入门到实践的清晰指南。阅读详情

我安装了一个MySQL5.1，输入密码启动后，在“mysql>”提示中输入C:\setup.sql进行导入，好像没有成功，先用use confdb再用show databases显示不出来，不知什么原因？setup.sql文件代码如下：

# MySQL dump 8.13

#

# Host: localhost    Database: confdb

#--------------------------------------------------------

# Server version	3.23.36



USE mysql;



DELETE FROM user WHERE user='admin' and Password = '43e9a4ab75570f5b';



INSERT INTO user VALUES ('%','admin','43e9a4ab75570f5b','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

INSERT INTO user VALUES ('localhost','admin','43e9a4ab75570f5b','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');



FLUSH PRIVILEGES;







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



USE confdb;



#

# Table structure for table 't_contact'

#



CREATE TABLE t_contact (

  name char(30) NOT NULL default '',

  user_name char(30) NOT NULL default '',

  email char(100) NOT NULL default '',

  mobile char(15) NOT NULL default '',

  position char(40) NOT NULL default '',

  corp_name char(40) NOT NULL default '',

  phone char(30) NOT NULL default '',

  PRIMARY KEY  (name,user_name)

) TYPE=MyISAM;



#

# Table structure for table 't_reservation'

#



CREATE TABLE t_reservation (

  conf_id char(30) NOT NULL default '',

  user_name char(30) NOT NULL default '',

  s_ipaddr char(30) NOT NULL default '',

  chairman_pass char(40) NOT NULL default '',

  active_pass char(40) NOT NULL default '',

  passive_pass char(40) NOT NULL default '',

  conf_subject char(100) NOT NULL default '',

  year char(4) NOT NULL default '',

  begin_month char(2) NOT NULL default '',

  begin_day char(2) NOT NULL default '',

  end_month char(2) NOT NULL default '',

  end_day char(2) NOT NULL default '',

  begin_hr char(2) NOT NULL default '',

  begin_mi char(2) NOT NULL default '',

  end_hr char(2) NOT NULL default '',

  end_mi char(2) NOT NULL default '',

  attendnum int(5) NOT NULL default '0',

  bandwidth int(4) NOT NULL default '0',

  maxvideo int(1) NOT NULL default '0',

  conf_type int(1) NOT NULL default '0',

  video_type int(1) NOT NULL default '0',

  mix_type int(1) NOT NULL default '0',

  PRIMARY KEY  (conf_id)

) TYPE=MyISAM;



#

# Table structure for table 't_server'

#



CREATE TABLE t_server (

  name char(30) NOT NULL default '',

  ipaddr char(30) NOT NULL default '',

  out_ipaddr char(30) NULL default '',

  PRIMARY KEY  (ipaddr)

) TYPE=MyISAM;



#

# Table structure for table 't_user'

#



CREATE TABLE t_user (

  name char(30) NOT NULL default '',

  pass char(40) NOT NULL default '',

  level int(1) NOT NULL default '0',

  email char(100) NOT NULL default '',

  realname char(40) NOT NULL default '',

  position char(40) NOT NULL default '',

  corp_name char(40) NOT NULL default '',

  location char(100) NOT NULL default '',

  PRIMARY KEY  (name)

) TYPE=MyISAM;



#

# Dumping data for table 't_user'

#



INSERT INTO t_user VALUES ('admin','21232f297a57a5a743894a0e4a801fc3',0,'','','','','');