Run a MySql Script from Command Line in Windows

Locate MySql.exe.  It’s probably here:

c:\mysql\bin\

Open a command prompt and type:

c:\mysql\bin\mysql.exe -h [database] -u [username] -p [scriptpath] --force

The –force switch ignores all errors the script may run into.  When you press enter, you’ll be asked for a password.  Enter the password and your script will start running.