i have an mySQL database script. ... what is the best way to execute SQL script?. An easy way is to log on to the server using telnet or ssh, run the MySQL interactive shell by typing "mysql", and then just "paste" your script into the terminal emulator. That should run it. Or you can upload the script to somewhere on the server, log in as above and type "mysql < name_of_script"
i have a .war file ... then upload war file to WEB-INF directory? Several people have given advice on this, above. We can't give any more details without knowing (a) which
servlet container you are using, (b) how it is configured, (c) what (if any) user-modifyable settings there are in your war file.
Note in particular, that you have to be accurate with file and directory names. No one suggested uploading a war file to "WEB-INF", look again at the messages above.
may i have to change the Driver settings to connecting the web databse server?.i think i have to change it according to hosting database server settings. Probably. The first place I'd look is the installation instructions for the web application. I can't believe there aren't any at all. We can't really help you with any detailled answers, because there are almost as many ways of configuring a database connection as there are programmers.
Look in your war file for text files with configuration details. Look wherever you got it from for instructions and documents.
Finally, it's always wise to understand that you will get much better answers from JavaRanch if you give us (a) all the detailled information you have and (b) enough time to answer. Most visitors to JavaRanch drop in once a day at most, and expecting a reply within a few hours is foolish.