Do not stop or exit from a script in case of error.

philipina · 07-02-2004, 05:56 AM

Hello,

I would like to execute a linux script including some mysql commands.
My problem is that my script is exiting in case of error.
Is there any possibility to automatically ignore in case of error and continue to execute all other mysql commands.

Thanks in advance.

Alain.

wolfe2554 · 07-02-2004, 06:10 AM

so when the program script in bash? right? is going though it exits because? well the only reason a script would exit is ctl c, return 1, or it is finished. can you give some more info pls.
thank you
wolfe

philipina · 07-02-2004, 06:30 AM

Yes, this is a bash file.

Example:

!#/bin/bash
exec mysql -e"INSERT INTO MyTable1 VALUES(1,2,3,4,5);"
exec mysql -e"INSERT INTO MyTable2 VALUES(1,2,3,4,5);"
exec mysql -e"INSERT INTO MyTable3 VALUES(1,2,3,4,5);"

If there is a problem in the first mysql command, all other mysql commands are not executed.

Thanks in advance.

linuxxed · 07-02-2004, 06:33 AM

Quote:

Originally posted by philipina
Yes, this is a bash file.

Example:

!#/bin/bash
exec mysql -e"INSERT INTO MyTable1 VALUES(1,2,3,4,5);"
exec mysql -e"INSERT INTO MyTable2 VALUES(1,2,3,4,5);"
exec mysql -e"INSERT INTO MyTable3 VALUES(1,2,3,4,5);"

If there is a problem in the first mysql command, all other mysql commands are not executed.

Thanks in advance.

remove the "exec". Exec causes the process to execute in the same shell.
!#/bin/bash
mysql -e"INSERT INTO MyTable1 VALUES(1,2,3,4,5);"
mysql -e"INSERT INTO MyTable2 VALUES(1,2,3,4,5);"
mysql -e"INSERT INTO MyTable3 VALUES(1,2,3,4,5);"

philipina · 07-02-2004, 06:52 AM

Yes, now it works fine!

Thanks you.

Alain.