Table 'nameoftable' doesn't exist

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Table 'nameoftable' doesn't exist

Author

Topic

mozhais
Starting Member

1 Post

Posted - 2011-02-12 : 08:01:28

sql file
---

#
# Struktur dari tabel `wc_advert`
#

DROP TABLE IF EXISTS wc_advert;
CREATE TABLE wc_advert (
ID tinyint(4) NOT NULL auto_increment,
ADV_NAME varchar(16) default '',
ADV_TYPE tinyint(1) default '0',
ADV_ACTIVATE tinyint(1) default '0',
ADV_WRAP tinyint(1) default '0',
ADV_TEXT varchar(250) default '',
COB_ID varchar(16) NOT NULL default '',
ROOM_ID varchar(32) default '',
CREATED_BY varchar(16) default '',
DATETIME datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ID)
) TYPE=MyISAM;

#
# Dumping data untuk tabel `wc_advert`
#

INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (1, 'masterweb', 1, 1, 1, 'Visit Masterweb.or.id', 'ITDIV', 'admin20050927095737', 'admin', '2005-09-27 11:05:20');
INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (2, 'masterweb2', 0, 1, 1, 'Visit Masterweb.or.id', 'ITDIV', 'admin20050927095737', 'admin', '2005-09-27 11:06:28');
INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (3, 'masterweb', 1, 1, 1, 'Visit Masterweb.or.id', 'HRDIV', 'admin20050927095832', 'admin', '2005-09-27 11:07:58');
INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (4, 'masterweb2', 0, 1, 1, 'Visit Masterweb.or.id', 'HRDIV', 'admin20050927095832', 'admin', '2005-09-27 11:08:14');

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

#
# Struktur dari tabel `wc_message`
#

DROP TABLE IF EXISTS wc_message;
CREATE TABLE wc_message (
COB_ID varchar(16) NOT NULL default '',
USER_ID varchar(16) NOT NULL default '',
DEST_ID varchar(16) NOT NULL default '',
ROOM_ID varchar(32) NOT NULL default '',
MESSAGE text NOT NULL,
DATETIME datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

#
# Dumping data untuk tabel `wc_message`
#

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

#
# Struktur dari tabel `wc_room`
#

DROP TABLE IF EXISTS wc_room;
CREATE TABLE wc_room (
COB_ID varchar(16) NOT NULL default '',
ROOM_ID varchar(32) NOT NULL default '',
ROOM_NAME varchar(16) NOT NULL default '',
CREATED_BY varchar(16) NOT NULL default '',
DATETIME datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ROOM_ID)
) TYPE=MyISAM;

#
# Dumping data untuk tabel `wc_room`
#

INSERT INTO wc_room (COB_ID, ROOM_ID, ROOM_NAME, CREATED_BY, DATETIME) VALUES ('ITDIV', 'admin20050927095737', 'IT Room', 'admin', '2005-09-27 09:57:37');
INSERT INTO wc_room (COB_ID, ROOM_ID, ROOM_NAME, CREATED_BY, DATETIME) VALUES ('HRDIV', 'admin20050927095832', 'HR Room', 'admin', '2005-09-27 09:58:32');

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

#
# Struktur dari tabel `wc_user`
#

DROP TABLE IF EXISTS wc_user;
CREATE TABLE wc_user (
COB_ID varchar(16) NOT NULL default '',
USER_ID varchar(16) NOT NULL default '',
PASSWORD varchar(16) NOT NULL default '',
EMAIL varchar(32) NOT NULL default '',
LAST_LOGIN datetime NOT NULL default '0000-00-00 00:00:00',
DATETIME datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

#
# Dumping data untuk tabel `wc_user`
#

i import it via phpmyadmin, but it shows error?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-02-12 : 10:12:26

for MySQL questions please post at http://www.dbforums.com/

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources