This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallAnywhere
- :
- InstallAnywhere Forum
- :
- how shall i achieve this with mysql
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 03, 2008
08:16 AM
how shall i achieve this with mysql
hi,
i have a requirement wherein i need to run some sql scripts after installation
,i am using a batch file wherein i am writing this command:
mysql -ulocalhost -uroot -proot -P3306 < C:\something.sql
But now i want to remove this hard coding and therefore i want to use this command.
mysql -ulocalhost -uroot -proot -P3306 < %SQL_HOME%\something.sql
But the error stack trace in stderr.log is
OUT:
OUT:
OUT: C:\DOCUME~1\xxxx\LOCALS~1\Temp\I1199360856\Windows>set PATH=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32;D:\eclipse\plugins\org.apache.ant_1.6.5\bin;C:\WINDOWS\system32;C:\Program Files\Java\jdk1.5.0_08\bin;;C:\Program Files\MySQL\MySQL Server 5.0\bin
OUT:
OUT:
OUT: C:\DOCUME~1\xxxxxx\LOCALS~1\Temp\I1199360856\Windows>mysql -ulocalhost -uroot -proot -P3306 0<\something.sql
ERR: The system cannot find the file specified.
OUT:
OUT:
OUT: C:\DOCUME~1\xxxxx\LOCALS~1\Temp\I1199360856\Windows>mysql -ulocalhost -uroot -proot -P3306 0<\yyyyyy.sql
ERR: The system cannot find the file specified.
OUT:
OUT:
OUT: C:\DOCUME~1\xxxx\LOCALS~1\Temp\I1199360856\Windows>mysql -ulocalhost -uroot -proot -P3306 0<\zzazzzz.sql
How shall i overcome this problem.
I want to install the sql scripts in the $USER_INSTALL_DIR$ and load the file from there using
mysql -ulocalhost -uroot -proot -P3306< $USER_INSTALL_DIR$$\$something.sql
But mysql does not recognise this And my installer searches for it in Temp folder ,How shall i overcome this issue
ERR: The system cannot find the file specified.
OUT:
OUT:
OUT: C:\DOCUME~1\xxxx\LOCALS~1\Temp\I1199360856\Windows>mysql -ulocalhost -uroot -proot -P3306 0<\yyyyy.sql
ERR: The system cannot find the file specified.
OUT: done reading
ERR: done reading
i have a requirement wherein i need to run some sql scripts after installation
,i am using a batch file wherein i am writing this command:
mysql -ulocalhost -uroot -proot -P3306 < C:\something.sql
But now i want to remove this hard coding and therefore i want to use this command.
mysql -ulocalhost -uroot -proot -P3306 < %SQL_HOME%\something.sql
But the error stack trace in stderr.log is
OUT:
OUT:
OUT: C:\DOCUME~1\xxxx\LOCALS~1\Temp\I1199360856\Windows>set PATH=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32;D:\eclipse\plugins\org.apache.ant_1.6.5\bin;C:\WINDOWS\system32;C:\Program Files\Java\jdk1.5.0_08\bin;;C:\Program Files\MySQL\MySQL Server 5.0\bin
OUT:
OUT:
OUT: C:\DOCUME~1\xxxxxx\LOCALS~1\Temp\I1199360856\Windows>mysql -ulocalhost -uroot -proot -P3306 0<\something.sql
ERR: The system cannot find the file specified.
OUT:
OUT:
OUT: C:\DOCUME~1\xxxxx\LOCALS~1\Temp\I1199360856\Windows>mysql -ulocalhost -uroot -proot -P3306 0<\yyyyyy.sql
ERR: The system cannot find the file specified.
OUT:
OUT:
OUT: C:\DOCUME~1\xxxx\LOCALS~1\Temp\I1199360856\Windows>mysql -ulocalhost -uroot -proot -P3306 0<\zzazzzz.sql
How shall i overcome this problem.
I want to install the sql scripts in the $USER_INSTALL_DIR$ and load the file from there using
mysql -ulocalhost -uroot -proot -P3306< $USER_INSTALL_DIR$$\$something.sql
But mysql does not recognise this And my installer searches for it in Temp folder ,How shall i overcome this issue
ERR: The system cannot find the file specified.
OUT:
OUT:
OUT: C:\DOCUME~1\xxxx\LOCALS~1\Temp\I1199360856\Windows>mysql -ulocalhost -uroot -proot -P3306 0<\yyyyy.sql
ERR: The system cannot find the file specified.
OUT: done reading
ERR: done reading
(5) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 03, 2008
01:59 PM
Call the command file as
and inside the file.cmd use the following call
Best Regards,
Yves
file.cmd $USER_INSTALL_DIR$
and inside the file.cmd use the following call
mysql -ulocalhost -uroot -proot -P3306< $1\something.sql
Best Regards,
Yves
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 08, 2008
01:37 AM
hi yves,
can i use this script for calling eclipse.exe
file.cmd $USER_INSTALL_DIR$$\eclipse
call eclipse.exe -data $1\Workspace
This script is used for calling eclipse which i install in the user install folder with a worspace and then i want to start eclipse.exe with my workspace.
How to do it.
can i use this script for calling eclipse.exe
file.cmd $USER_INSTALL_DIR$$\eclipse
call eclipse.exe -data $1\Workspace
This script is used for calling eclipse which i install in the user install folder with a worspace and then i want to start eclipse.exe with my workspace.
How to do it.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 08, 2008
01:51 AM
file.cmd $USER_INSTALL_DIR$$\$eclipse
call eclipse.exe -data "$1\Workspace"
P.S.: First test your idea, then ask if it is not working!
Best Regards,
Yves
call eclipse.exe -data "$1\Workspace"
P.S.: First test your idea, then ask if it is not working!
Best Regards,
Yves
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 08, 2008
06:03 AM
HI,
the script i used is
file.cmd $USER_INSTALL_DIR$$\$eclipse
call eclipse.exe -data "$1\Workspace"
But eclipse did not startup, i am unable to grasp what is wrong.
and when i use this script for calling:
start /?
start "" "$USER_INSTALL_DIR$$\$eclipse$\$eclipse.exe" -data "$USER_INSTALL_DIR$$\$WorkSpace"
the script is calling but the user needs to enter any key which is not user friendly.
Please provide any suggestion for this.
And even when i start the jboss (run.bat) by this script:
cd $USER_INSTALL_DIR$$\$jboss$\$bin
$USER_INSTALL_DIR$$\$jboss$\$bin$\$run.bat
,EVEN THIS DOES NOT WORK WHEN $USER_INSTALL_DIR$ IS SAY
C:\Program Files\SOMETHING
when the folder choosen contains space in between
the script i used is
file.cmd $USER_INSTALL_DIR$$\$eclipse
call eclipse.exe -data "$1\Workspace"
But eclipse did not startup, i am unable to grasp what is wrong.
and when i use this script for calling:
start /?
start "" "$USER_INSTALL_DIR$$\$eclipse$\$eclipse.exe" -data "$USER_INSTALL_DIR$$\$WorkSpace"
the script is calling but the user needs to enter any key which is not user friendly.
Please provide any suggestion for this.
And even when i start the jboss (run.bat) by this script:
cd $USER_INSTALL_DIR$$\$jboss$\$bin
$USER_INSTALL_DIR$$\$jboss$\$bin$\$run.bat
,EVEN THIS DOES NOT WORK WHEN $USER_INSTALL_DIR$ IS SAY
C:\Program Files\SOMETHING
when the folder choosen contains space in between
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 08, 2008
07:12 AM
Try without the start...
Or paste an executable...
Best Regards,
Yves
Or paste an executable...
Best Regards,
Yves
![](/skins/images/A5EADE085F77DE82FB3B14D6B307AE6A/responsive_peak/images/icon_anonymous_message.png)