cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
james_decosta
Level 9

Hi i want to know if this is the way to load the sql file

hi,
i am loading the sql scripts externally from the execute script or batch feature of installanywhere.
I CALL the batch file whose contents are as follows:
mysql -ulocalhost -uroot -proot -Proot < C:\xxx.sql

Is this approach right or am i going amry somewhere in between.
james.
Labels (1)
0 Kudos
(1) Reply
james_decosta
Level 9

hi,
i would like to know if i am right in using this approach
I am calling the sql scripts using the execute script or batch file

:
call "$USER_INSTALL_DIR$$/$XXX.sql"
or using like this:
call mysql -ulocalhost -uroot -proot -P3306 < "$USER_INSTALL_DIR$$/$yyy.sql"

Am i right when i load the sql scripts in the mysql database
Or can these be done effectively
james.
0 Kudos