Skip sql commands

[alirezaok]

hi

I want to run a .sql file that have 10000 sql commands in it.

some of commands return error (I dont know which commands will retrun error)

I want when running sql file, when mysql get error in commands it will not stop. it skip this command and continue by run next command until end of this sql file.

what is solution?

thanks

[laserlight]

Read the manual:

If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option.