clean db batch problem

[Ciel0s]

i tried to execute this batch file :

mysql.exe -e "delete FROM `character_data` USING character_data, character_data AS tmpcharacter_data WHERE NOT character_data.CharacterID=tmpcharacter_data.CharacterID AND character_data.CharacterID<tmpcharacter_data.CharacterID AND (character_data.PlayerUID=tmpcharacter_data.PlayerUID)" dayz_epoch -h localhost -u Svr --password=*****

it says that mysql is not recognised as a program or something ? 

 

[MassAsster]

your using The MySQL Command-Line Tool ?!?

You would really have to locate that executable first before attempting to pass it any arguments

 

and i think the correct format is 

mysql -u root -p

(u = username, p = password)

 

http://stackoverflow.com/questions/3246482/mysql-command-line-client-for-windows