J'aimerais importer une base de donnée en .sql grace à phpmyadmin mais je n'y arrive pas il me dit erreur!! Comment faire?

elle était à quel "format" avant ?
Tu as un fichier .sql ?
Donnes nous un exemple de requête

DROP TABLE IF EXISTS access;
CREATE TABLE access (
   userid int(10) unsigned NOT NULL,
   forumid smallint(5) unsigned NOT NULL,
   accessmask smallint(5) unsigned NOT NULL,
   KEY userid (userid,forumid)
);
 
INSERT INTO access VALUES('6','14','1');
INSERT INTO access VALUES('6','41','1');
 
 
 
DROP TABLE IF EXISTS adminlog;
CREATE TABLE adminlog (
   adminlogid int(10) unsigned NOT NULL auto_increment,
   userid int(10) unsigned NOT NULL,
   dateline int(10) unsigned NOT NULL,
   script varchar(20) NOT NULL,
   action varchar(20) NOT NULL,
   extrainfo varchar(200) NOT NULL,
   ipaddress varchar(15) NOT NULL,
   PRIMARY KEY (adminlogid)
);
 
INSERT INTO adminlog VALUES('1','1','1010
857701','index.php','
9;,'','80.11.88.83');
INSERT INTO adminlog VALUES('2','1','1010
857766','options.php','&#
039;,'','80.11.88.83');
INSERT INTO adminlog VALUES('3','1','1010
857948','options.php','&#
039;,'','80.11.88.83');
INSERT INTO adminlog VALUES('4','1','1010
858137','options.php','doo
ptions','','80.11.88.83&#
039;);
INSERT INTO adminlog VALUES('5','1','1010
858154','options.php','&#
039;,'','80.11.88.83');
INSERT INTO adminlog VALUES('6','1','1010
858216','backup.php','choo
se','','80.11.88.83'
);
INSERT INTO adminlog VALUES('7','1','1010
858222','backup.php','sqlt
able','Table = Array','80.11.88.83');
INSERT INTO adminlog VALUES('8','1','1010
858252','style.php','downl
oad','','80.11.88.83'
;);
INSERT INTO adminlog VALUES('9','1','1010
858265','announcement.php',
9;add','','80.11.88.83�
39;);
INSERT INTO adminlog VALUES('10','1','101
0858293','forum.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('11','1','101
0858307','usertitle.php','
add','','80.11.88.83'
;);
INSERT INTO adminlog VALUES('12','1','101
0858311','user.php','add&
#039;,'','80.11.88.83');
INSERT INTO adminlog VALUES('13','1','101
0858366','user.php','inser
t','','80.11.88.83')
;
INSERT INTO adminlog VALUES('14','1','101
0858397','user.php','find
','','80.11.88.83');

INSERT INTO adminlog VALUES('15','1','101
0858402','user.php','edit
','user id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('16','1','101
0858416','user.php','doupd
ate','user id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('17','1','101
0858418','user.php','find
','','80.11.88.83');

INSERT INTO adminlog VALUES('18','1','101
0858438','forum.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('19','1','101
0858556','forum.php','inse
rt','','80.11.88.83'
);
INSERT INTO adminlog VALUES('20','1','101
0858577','options.php','&
#039;,'','80.11.88.83');
INSERT INTO adminlog VALUES('21','1','101
0858555','announcement.php',�
39;add','','80.11.88.83&#
039;);
INSERT INTO adminlog VALUES('22','1','101
0858733','announcement.php',�
39;insert','','80.11.88.83
');
INSERT INTO adminlog VALUES('23','1','101
0858778','forum.php','modi
fy','','80.11.88.83'
);
INSERT INTO adminlog VALUES('24','1','101
0858757','forum.php','remo
ve','forum id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('25','1','101
0858783','forum.php','kill
','forum id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('26','1','101
0858794','forum.php','door
der','','80.11.88.83'
;);
INSERT INTO adminlog VALUES('27','1','101
0858847','thread.php','vot
es','','80.11.88.83'
);
INSERT INTO adminlog VALUES('28','1','101
0858859','announcement.php',�
39;add','','80.11.88.83&#
039;);
INSERT INTO adminlog VALUES('29','1','101
0858863','forum.php','modi
fy','','80.11.88.83'
);
INSERT INTO adminlog VALUES('30','1','101
0858840','announcement.php',�
39;modify','','80.11.88.83
');
INSERT INTO adminlog VALUES('31','1','101
0858868','announcement.php',�
39;edit','announcement id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('32','1','101
0859028','announcement.php',�
39;doupdate','announcement id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('33','1','101
0859043','misc.php','choos
er','','80.11.88.83'
);
INSERT INTO adminlog VALUES('34','1','101
0859054','style.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('35','1','101
0859459','index.php','�
39;,'','80.11.88.83');
INSERT INTO adminlog VALUES('36','1','101
0859510','stats.php','inde
x','','80.11.88.83')
;
INSERT INTO adminlog VALUES('37','1','101
0859489','adminlog.php','c
hoose','','80.11.88.83�
39;);
INSERT INTO adminlog VALUES('38','1','101
0859538','forum.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('39','1','101
0859602','forum.php','inse
rt','','80.11.88.83'
);
INSERT INTO adminlog VALUES('40','1','101
0859587','forum.php','edit
','forum id = 4','80.11.88.83');
INSERT INTO adminlog VALUES('41','1','101
0859615','forum.php','door
der','','80.11.88.83'
;);
INSERT INTO adminlog VALUES('42','1','101
0859788','forum.php','edit
','forum id = 4','80.11.88.83');
INSERT INTO adminlog VALUES('43','1','101
0859799','announcement.php',�
39;add','','80.11.88.83&#
039;);
INSERT INTO adminlog VALUES('44','1','101
0859847','announcement.php',�
39;insert','','80.11.88.83
');
INSERT INTO adminlog VALUES('45','1','101
0859851','announcement.php',�
39;edit','announcement id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('46','1','101
0859955','style.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('47','1','101
0859994','style.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('48','1','101
0859998','style.php','down
load','','80.11.88.83
9;);
INSERT INTO adminlog VALUES('49','1','101
0860049','style.php','doup
load','','80.11.88.83
9;);
INSERT INTO adminlog VALUES('50','1','101
0860166','style.php','modi
fy','','80.11.88.83'
);
INSERT INTO adminlog VALUES('51','1','101
0860173','style.php','edit
','','80.11.88.83');
 
INSERT INTO adminlog VALUES('52','1','101
0860194','style.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('53','1','101
0860202','style.php','modi
fy','','80.11.88.83'
);
INSERT INTO adminlog VALUES('54','1','101
0860181','style.php','dodo
wnload','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('55','1','101
0860238','style.php','down
load','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('56','1','101
0860247','style.php','doup
load','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('57','1','101
0860738','style.php','down
load','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('58','1','101
0860748','style.php','doup
load','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('59','1','101
0860728','style.php','doup
load','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('60','1','101
0863840','index.php','�
39;,'','80.11.88.83');
INSERT INTO adminlog VALUES('61','1','101
0863850','adminlog.php','c
hoose','','80.11.88.83�
39;);
INSERT INTO adminlog VALUES('62','1','101
0863859','style.php','modi
fy','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('63','1','101
0863869','style.php','edit
','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('64','1','101
0863878','style.php','modi
fy','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('65','1','101
0863881','style.php','add
','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('66','1','101
0863893','style.php','inse
rt','style id = 1','80.11.88.83');
INSERT INTO adminlog VALUES('67','1','101
0863897','style.php','dodo
wnload','style id = 3','80.11.88.83');
INSERT INTO adminlog VALUES('68','1','101
0863878','style.php','down
load','style id = 3','80.11.88.83');
INSERT INTO adminlog VALUES('69','1','101
0863966','style.php','doup
load','style id = 3','80.11.88.83');
INSERT INTO adminlog VALUES('70','1','101
0866369','index.php','�
39;,'','80.11.88.83');
INSERT INTO adminlog VALUES('71','1','101
0866379','options.php','&
#039;,'','80.11.88.83');
INSERT INTO adminlog VALUES('72','1','101
0866615','options.php','do
options','','80.11.88.83&
#039;);
INSERT INTO adminlog VALUES('73','1','101
0867569','index.php','�
39;,'','80.11.88.83');
INSERT INTO adminlog VALUES('74','1','101
0867598','forum.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('75','1','101
0867609','forum.php','modi
fy','','80.11.88.83'
);
INSERT INTO adminlog VALUES('76','1','101
0867635','user.php','pmsta
ts','','80.11.88.83'
);
INSERT INTO adminlog VALUES('77','1','101
0867639','user.php','refer
rers','','80.11.88.83
9;);
INSERT INTO adminlog VALUES('78','1','101
0867638','user.php','doips
','','80.11.88.83');
 
INSERT INTO adminlog VALUES('79','1','101
0867641','forum.php','modi
fy','','80.11.88.83'
);
INSERT INTO adminlog VALUES('80','1','101
0867644','options.php','&
#039;,'','80.11.88.83');
INSERT INTO adminlog VALUES('81','1','101
0867647','forum.php','add
','','80.11.88.83');

INSERT INTO adminlog VALUES('82','1','101
0867650','forumpermission.php',
'modify','','80.11.88
.83');
INSERT INTO adminlog VALUES('83','1','101
0867656','forumpermission.php',
'edit','','80.11.88.8
3');
INSERT INTO adminlog VALUES('84','1','101
0867722','user.php','modif
y','','80.11.88.83')
;
INSERT INTO adminlog VALUES('85','1','101
0867726','user.php','find
','','80.11.88.83');

INSERT INTO adminlog VALUES('86','1','101
0867727','user.php','edit
','user id = 3','80.11.88.83');
INSERT INTO adminlog VALUES('87','1','101
0867733','user.php','edita
ccess','user id = 3','80.11.88.83');
INSERT INTO adminlog VALUES('88','1','101
0867744','user.php','updat
eaccess','user id = 3','80.11.88.83');
INSERT INTO adminlog VALUES('89','1','101
0867805','user.php','doips
','','80.11.88.83');
 
INSERT INTO adminlog VALUES('90','1','101
0867832','user.php','doips
','','80.11.88.83');
 
INSERT INTO adminlog VALUES('91','1','101
0867835','user.php','doips
','','80.11.88.83');
 
INSERT INTO adminlog VALUES('92','1','101
0867836','user.php','doips
','','80.11.88.83');
 
INSERT INTO adminlog VALUES('93','1','101
0867892','user.php','pmsta
ts','','80.11.88.83'
);
INSERT INTO adminlog VALUES('94','1','101
0867899','forum.php','modi
fy','','80.11.88.83'
);
INSERT INTO adminlog VALUES('95','1','1010867902','forum.php','addm

j'ai juste essayé la table access et ça marche sans pb

kesako?

C'est quoi les commandes de table access .. Pourquoi moi j'ai des erreurs ?