I'm trying to teach myself JavaServlets and JSP pages. I'm using Murach's Java Servlets and JSP, 2nd edition book.
I'm supposed to download MySQL from the website then install it, which I've done. The book recommends I install MySQL at C:\Program Files\MySQL\MySQL Server 5.0. It further recommends installing the book files, including the database files at C:\murach\servlet_jsp\db. I've done that.
When I double-click on the setup_db.bat file to run it, I get the following error message," The system cannot find the path specified. 'mysql' is not recognized as an internal or external command, operable program or batch file."
Please note that Tomcat and Netbeans are setup and configured adequately, so I don't think it has any interoperation problems.
Knowing that Windows gets a little picky about spaces in it's classpath, I changed "MySQL Server 5.1" to "MySQL_Server5.1". I still get the same error message.
What am I doing wrong?
Thank you in advance for your helpful replies.
I'm guessing that installing MySQL didn't change your PATH environment variable to include the bin folder of your MySQL install (or wherever mysql.exe ended up). If it didn't, then you're going to have to do that yourself.
(The PATH environment variable contains a list of Windows folders where Windows looks when you ask it to run some executable from the command line.)
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com