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!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: