SQL File Execution Problems

Hi,

I am simply trying to execute an SQL file to create a database in mySql. Whenever I try using either of the code snippets below however, I always get errors.

When I try using this:

nsExec::ExecToLog 'cmd /C "$mySQLEXE" -uroot -p$databaseLoginPass < "$databaseConfigFile"'

(Where $mySQLEXE is the path to the mysql.exe file, $databasepass is the root user password, and $databaseConfigFile is the full path to the SQL file.)

I get the error: 'C:\Program' is not recognized as an internal or external command,operable program or batch file. I have doubled checked all the paths and the database password, and everything is correct.

When I try using this:

nsExec::ExecToLog '"cmd /C "$mySQLEXE" -uroot -p$databaseLoginPass < "$databaseConfigFile""'

I don't get an error, but no database is created.

If anybody knows what is going on please let me know.

Thanks!

That's just cmd.exe messing with your quotes.

    1.  If all of the following conditions are met, then quote character

        on the command line are preserved:



        - no /S switch

        - exactly two quote characters

        - no special characters between the two quote characters,

          where special is one of: &<>()@^|

        - there are one or more whitespace characters between the

          the two quote characters

        - the string between the two quote characters is the name

          of an executable file.



    2.  Otherwise, old behavior is to see if the first character is

        a quote character and if so, strip the leading character and

        remove the last quote character on the command line, preserving

        any text after the last quote character.

Add IF 1==1 right after /C or use a short filename for $mysqlexe (GetFullPathName /SHORT).

Thanks a lot kichik, the IF 1==1 thing worked perfectly.