Next time you have an error whilst running an sql script into mysql using the pretty easy redirect into eg: mysql -uroot -pmsandbox -h127.0.0.1 -P3306 dbname < filename you might want to give the -v option a shot.
MySQL normally outputs an error with the line number like:
[mysql@dcassar-ubuntu /mysql/dumps/stored_procs 11:10:12]$ mysql
-uroot -pmsandbox -h127.0.0.1 -P5151 test < file
ERROR 1267 (HY000) at line 375: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for
operation '='
But 375 is not including comments and stuff so it’s a bit hard to go through the file to locate the exact section which is failing.
Run the same command with -v:
[mysql@dcassar-ubuntu /mysql/dumps/stored_procs 11:10:30]$ mysql
-uroot -pmsandbox -h127.0.0.1 -P5151 -v test < file | tail
-5
ERROR 1267 (HY000) at line 375: Illegal mix …