mySQL Script Question

[Zero-G.]

Hey
I use IA15 and I am trying to get a script running.
The script at all is about 3MB big. -> When I run the script in DOS Box with the following command:
mysql -uUSER -P3306 < "Path\Script.sql" then the script will be imported correct
First: When I use Run Program from IA built in, then the Script isn't running
(But I can't see the error, because the dos box imediatly Closes)
Second: I use the built in Script Editor of IA15. - This always Ends when the code Comes to the following lines:

Code: Select all

DELIMITER $$

/*!50003 DROP TRIGGER*//*!50032 IF EXISTS */ /*!50003 `iCodeDatSeit` */$$

/*!50003 CREATE */ /*!50017 DEFINER ...

Any Ideas to this!?
THX

[FrancescoT]

Dear User,

if you are able to run your script via CMD prompt, you should be able to the same usng RUN PROGRAM command (it does exactly the same).
To keep the program window open while executing RUN PROGRAM, uncheck the "Hide Program Window" control.

Regarding the error that you receive by MY SQL IA command, if I am not wrong seems that it is confusing some part of your script with a possible IA Variable due the used sign $.

Regards

[Zero-G.]

Thx for your answer!
The Thing with $$ could be the right Thing! -I will try tomorrow!

Do you know, if there is a possibility to Set the Progress Status to the Lines of executed Statements?

Thx