Ciao a tutti,

sto preparando un progetto per l'esame di basi di dati all'università.
Creo lo schema er e lo schema logico con Power Designer e questo stesso programma mi genera il codice sql per istanziare il database.

Come Versione di MySql Administrator uso la 5.037

Quando provo ad importare il codice compare questo messaggio di errore

The selected file was generated by mysqldump and cannot be restored by this application.

Se nell'administrator spunto la voce "ignora gli errori" mi carica solo una parte del db e genera questi warning

Warning: Do not know how to handle this statement at line 7:
drop index ABILITATO2_FK on ABILITATO;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 9:
drop index ABILITATO_FK on ABILITATO;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 11:
drop index INCASSO_FK on ENTRATE;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 13:
drop index DIAGNOSTICA_FK on IMMAGINE;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 15:
drop index MEMO_FK on NOTA;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 17:
drop index EFFETTUA_FK on PRESTAZIONE;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 19:
drop index OFFERTA_FK on PRESTAZIONE;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 21:
drop index PRENOTA_FK on PRESTAZIONE;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Error while executing this query:create table if not exists PRESTAZIONE
(
CF char(16) not null,
CODICE int not null,
"DATA" date not null,
CFP char(16) not null,
ORA time not null
) DEFAULT CHARSET=utf8;
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DATA" date not null,
CFP ' at line 5
Warning: Error while executing this query:create index PRENOTA_FK on PRESTAZIONE
(
CF
);
The server has returned this error message:Table 'lala.prestazione' doesn't exist
Warning: Error while executing this query:create index EFFETTUA_FK on PRESTAZIONE
(
CFP
);
The server has returned this error message:Table 'lala.prestazione' doesn't exist
Warning: Error while executing this query:create index OFFERTA_FK on PRESTAZIONE
(
CODICE
);
The server has returned this error message:Table 'lala.prestazione' doesn't exist
Warning: Error while executing this query:create table if not exists IMMAGINE
(
IDLASTRA int not null,
CF char(16) not null,
CODICE int not null,
"DATA" date not null,
LASTRA longblob not null,
REFERTO text
) DEFAULT CHARSET=utf8;
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DATA" date not null,
LAST' at line 6
Warning: Error while executing this query:create index DIAGNOSTICA_FK on IMMAGINE
(
CF,
CODICE,
"DATA"
);
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DATA"
)' at line 5
Warning: Error while executing this query:create table if not exists NOTA
(
IDNOTA int not null,
CF char(16) not null,
CODICE int not null,
"DATA" date not null,
APPUNTO text not null
) DEFAULT CHARSET=utf8;
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DATA" date not null,
APPU' at line 6
Warning: Error while executing this query:create index MEMO_FK on NOTA
(
CF,
CODICE,
"DATA"
);
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DATA"
)' at line 5
Warning: Error while executing this query:create table if not exists ENTRATE
(
ID int not null,
CF char(16) not null,
CODICE int not null,
"DATA" date not null,
PREZZO float(6,2) not null,
COMMENTO text
) DEFAULT CHARSET=utf8;
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DATA" date not null,
PREZ' at line 6
Warning: Error while executing this query:create index INCASSO_FK on ENTRATE
(
CF,
CODICE,
"DATA"
);
The server has returned this error message:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"DATA"
)' at line 5

sapreste dirmi cosa c'è che non va??