Tomcat and Mysql

To execute mysql .sql script files.
Go to here.
The mysql client typically is used interactively, like this:

shell> mysql db_name

However, it’s also possible to put your SQL statements in a file and then tell mysql to read its input from that file. To do so, create a text file text_file that
contains the statements you wish to execute. Then invoke mysql as shown here:

shell> mysql db_name < text_file
You can also start your text file with a USE db_name statement. In this case, it is unnecessary to specify the database name on the command line:

shell> mysql < text_file

If you are running mysql, you can execute an SQL script file using the source or \. command:

mysql> source filename
mysql> \. filename


After installation, set the path to server-api.jar in the local class path so that
v can compile the servlet java files. The servlet-api is found under tomcat-install-dir/common/lib

And in config/web.xml , UNCOMMENT the xml tags having the invoker term.

otherwise it sucks!

About the author

I work with customers helping them achieve more using Microsoft Technologies. I am in my 9th year with Microsoft as of March 2020. I get to work with really smart people (both at Microsoft and Customers). Helping customers, removing any blockers, rapid prototyping is my core work.