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?

so check the table does exist
run a query in PHPMyAdmin iof yoiu must and see if the table is defiend

if it is check tghe spelling
checdk the capitalisaion (depedning on where you are running your MySQL server it can be case sensitive

if i send u scrpit can u help me? i dont have a idea, how make queries etc

no
the problem is on your computer, not mine
your script shoudl have created the table, yet subsequent actiosn are saying its not there
so you need to do some steps to find out if it is there (ie something is lying).
so do a quick check, if you are using PHPMyAdmin there is a page which tells ou what tables are there.
if the table exists, cherk its spelling

if it doesnt' exists then rerun the fragemnt of script that created the missign table and wathc for any errors being reported.

so first off
see if the table is there, if so check the spelling if exists and the spellign is corrrect theen I suspect its going to be c capitalisation issue. forget the precise details but on some installation TableName isnt the same as tablename or TABLENAME, even though it may be displayed as Tablename.

Perhaps I am missing something from the post, you have provided us with a script. I have run this script in a test database and get no errors. When do you get the errors and what is the error message?