Execute a SQL file - NSIS Forums

fabiochelly
18th February 2004 08:44 UTC

Execute a SQL file
Hi,

In my setup, In install Apache and MySQL.
Is it possible to execute a .sql file to create my database and all its content directly in my NSIS setup?

Thanks & Best regards

kobus
18th February 2004 10:36 UTC

Recenlty I've got similar problem with Oracle DB.
I finally did it in line that looks


 nsExec::Exec '$OracleExe\$SqlCli $User/$Passwd@$Db @$script '

where
nsExec::Exec - function from nsExec plugin that execute program and wait till it finish
$OracleExe - directory of Oracle executables
$SqlCli - name of SQL client that will run sql script
$User/$Passwd@$Db - name, passwd and connect string to make a valid connection to database
$Script - full path to the string

This line start the client in silient mode without any window on the screen.

If you want to do this with MySQL check options for MySQL client because they will be probably different ones.

Good luck :)
Kobus

Spatacoli
18th February 2004 19:18 UTC

For mySQL I use a line like this:
nsExec::ExecToLog 'cmd /C $mySQLEXE -u$dbUser -h$dbHost -P$dbPort < "$INSTDIR\tmp\dbinit\create_user.sql"'

$mySQLEXE is usually C:\mysql\bin\mysql.exe, but I detect the correct path earlier in the scripts. The rest should be self explanitory.

fabiochelly
18th February 2004 22:03 UTC

Thank you very much.
That's exactly what I was looking for.

fabiochelly
20th February 2004 07:31 UTC

How do you do when you have a long path to mysql?
I tried to put the mysql path between double quotes but the command doesn't work in this case.

Joost Verburg
20th February 2004 07:40 UTC

Did you put it between single and double quotes?

'"file"'

fabiochelly
20th February 2004 09:17 UTC

I tried to put the path between double quotes.
The whole command line is between single quotes

In fact, the command:

nsExec::ExecToLog 'cmd /C c:\mysql\mysql.exe -uroot -hlocalhost -P3306 < "$INSTDIR\install.sql"'

works fine but the command:

nsExec::ExecToLog 'cmd /C "c:\mysql\mysql.exe" -uroot -hlocalhost -P3306 < "$INSTDIR\install.sql"'

doesn't work (I get nothing)

Spatacoli
20th February 2004 23:57 UTC

not to be picky about it, but I want to be sure you have it right, mysql.exe lives in the bin directory, so do you mean that the path to your mysql.exe file is C:\mysql\bin\mysql.exe or is it C:\mysql\mysql.exe?

I'm trying what you have here, I've always put the path in a variable like mySQLEXE

StrCpy $mySQLEXE "C:\mysql\bin\mysql.exe"

and then used that with quotes around it like this:
nsExec::ExecToStack 'cmd /C "$mySQLEXE" -u$dbUser -p$dbPassword -h$dbHost -P$dbPort < "$INSTDIR\install.sql"'

Spatacoli
21st February 2004 00:05 UTC

So I tried it like this and it doesn't have a problem working (the path is the longest I could come up with on short notice):

nsExec::ExecToStack 'cmd /C "C:\Documents and Settings\temp1\Local Settings\Temporary Internet Files\Content.IE5\Q5IVCDQ1\mysql.exe" -uroot -prootpass -hlocalhost -P3306 < "$INSTDIR\install.sql"'

A short version is:

nsExec::ExecToStack 'cmd /C "C:\mysql\bin\mysql.exe" -uroot -prootpass -hlocalhost -P3306 < "$INSTDIR\install.sql"'

As Joost pointed out to me in a different post, cmd will only work on an NT system (NT, 2000, XP, 2003) not on 9x.

Joost Verburg
22nd February 2004 11:44 UTC

For Win9x use command instead of cmd.

fabiochelly
22nd February 2004 12:30 UTC

is it necessary to use the command 'command' or 'cmd'?

Cannot I type directly the instruction:
nsExec::ExecToStack '"C:\mysql\bin\mysql.exe" -uroot -prootpass -hlocalhost -P3306 < "$INSTDIR\install.sql"'

Joost Verburg
22nd February 2004 12:53 UTC

You are using Windows console features so you have to use command or cmd.

fabiochelly
22nd February 2004 13:43 UTC

And isn't it better to always use 'command' instead of 'cmd'?

Are there cases where 'command' cannot be used or where 'cmd' doesn't work the same way than 'command'?

Spatacoli
22nd February 2004 19:56 UTC

As Joost pointed out, cmd isn't a recognized program on Windows 9x. I use it in my installers because our software is only supported on Windows 2000, XP, and 2003. If you need compatibility with Windows 9x you should use command.

Joost Verburg
22nd February 2004 20:01 UTC

command on Windows NT is not the same as cmd.

command is the 16-bit MS-DOS version that will be emulated. It does not support long files names.

cmd is a 32-bit console with long file name support.

arfinator853
25th February 2005 22:44 UTC

I am using this code that you guys mentioned earlier for the sql files that I need executed (9 of them)

nsExec::ExecToLog 'cmd /C $mySQLEXE -u$user -h$host -P$port < "$INSTDIR\tmp\db\"

I have the user enter these mysql values in a custom page I created. (Value - user variable)

Username - $user
Password - $pass
SQL Host - $host
Port MySQL is running on - $port
SQL Database - $base

I am very new at mysql, and I was wondering if in the code, how I should deal with the database password, and what actual schema to put it in.

For this would -b (schema to put it in) -p (for password), would these work. Should I just add them into the code?

Thanks in advance everybody! :)

Arfy

arfinator853
26th February 2005 16:44 UTC

*bump*

mutantbc
13th November 2006 06:43 UTC

Hi,

Have you guys encountered hang on your installer when trying to execute below script?

nsExec::ExecToLog 'cmd /C $MySQLEXE -u $dbUser -p $dbPwd -h $dbHost -P $dbPort < $MySQLScript'

where:
MySQLScript -> contains the sql file (Check the syntax alread, which is correct :))

usrname, pwd, host, port are correct also.

Please help.

thanks

bholliger
13th November 2006 08:21 UTC

Hi mutantbc!


nsExec::ExecToLog 'cmd /C $MySQLEXE -u $dbUser -p$dbPwd -h $dbHost -P $dbPort < $MySQLScript'

I think the installer 'hangs' because mysql.exe is waiting for the password. Remove the space between -p and $dbPwd and try again.

Have a nice day!

Cheers

Bruno

Edit: Erm, there's something else to consider: cmd is Windows NT and higher only. The %COMSPEC% environment variable contains the correct value. (Forget this if you are sure, that your installer is not getting in touch with Windows 9x versions.)

mutantbc
13th November 2006 09:37 UTC

after installing MySQL, i try to execute MySQLInstanceConfig.exe...this will configure the username/pwd and install mysql as service. After the configuration, I try to connect to mysql server and execute the sql script...if I remove the -p $dbPwd, an error will occured "Access denied..."

How can i proceed? it seems mysql will ask a password if -p is supplied.

bholliger
13th November 2006 09:44 UTC

Hi!

Of course, you have to provide a password! But not in the format
-p MyPassWOrD

You have to use it like this:
-pMyPassWOrD

(without space between -p and password)

Cheers

Bruno

sunlight112
13th November 2006 10:46 UTC

I think this can help you,
It works perfectly, :)


   GetTempFileName $0
   StrCpy $0 "temp.bat"
   FileOpen $1 $0 "w"
   FileWrite $1 "@echo off$\r$\n"
   StrCpy $2 $TEMP 2     ##C:
   FileWrite $1 "$2$\r$\n"
   FileWrite $1 "mysql.exe database --user=root --password=$passroot < c:\test.sql$\r$\n"
   FileClose $1
   nsExec::exec "$0"

However, I think you should check Environment Variable in Computer property. In Path,you must add "C:\MySQL\MySQL server..\bin"
It also can recognize mysql.exe when you run it on command line.
:)

mutantbc
16th November 2006 05:33 UTC

the parameter without space works...strange but i works without prompting a password. :)

-pwithoutspacepassword

thanks

bholliger
16th November 2006 05:44 UTC

Hi mutantbc!

Actually you'll find this in the manual:

http://dev.mysql.com/doc/refman/5.0/...d-options.html

--password[=password], -p[password]

Cheers

Bruno

mutantbc
17th November 2006 10:31 UTC

you are right, maybe I didnt read the manual thourougly