Linux MySQL - triggers

[Drakos]

i cant import the table players. I know that phpmyadmin lost triggers. Buy how i can import? I try from mysql console but it isnt work

-u root -p yo5jddafsdfgdw4h < /home/admin/Desktop/trig.sql

what is wrong ?

someone could help me ?

 

[Migxxx]

don't login on the mysql

mysql -uroot -p LEAVE IT IN BLANK IT WILL ASK U FOR THE PASSWORD -D database must be forggotenserver or something < /home/admin/Desktop/trig.sql

 

[Drakos]

i change the name of database ;p

ERROR 1064 (42000) at line 1: 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 'mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2' at line 1

 

[Migxxx]

i change the name of database ;p

ERROR 1064 (42000) at line 1: 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 'mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2' at line 1

for me is working all right and i got debian etch 4.0 using mysql-server-5.0, try restarting your comp or restarting your mysql...

 

[Drakos]

@Migxxx

it doesnt work .

@edit
sorry my mistake. The database was damaged.
but i have another error

ERROR 1360 (HY000) at line 78: Trigger does not exist

in line 78:

DROP TRIGGER `yo5jddafsdfgdw4`.`oncreate_players`;

hmmm its the same error when i get in phpmyadmin

@edit2
strange, but when i delete line 78 it is ok

 

[Don Daniello]

DO YOU HAVE TRIGGER CALLED 'yo5jddafsdfgdw4' ?????

 

[Drakos]

yo5jddafsdfgdw4

its a name of database

 

[Don Daniello]

o lol
forget about this error
If trigger doesn't exists that what you wante.

 

[Drakos]

i searched that it must be like this

DROP TRIGER IF EXISTS name