Unanswered: mysql command in batch mode on Windows98
Hopefully someone can help me with this....
I recently installed MySQL (standard installation) on Windows 98, and created a test database to practice on. I have no difficulty connecting to the database or creating tables manually.
However, I wanted to use the mysql command in batch mode to run a .sql script to create tables in the database. The MySQL manual says to type 'mysql <filename.sql', or 'source filename.sql'. I have tried this but neither option has worked. I always get the message
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql <schema.sql' at line 1
How can there be a syntax error with such a basic command?
I am using mysqlc to enter the command. I've seen it suggested elsewhere to close the database and type the file path from the standard c: prompt, but this did not work. Also, I found out that there should be no comment lines with the # character in the .sql file. I took these out but it did not make any difference. The .sql file is stored in the directory 'c:mysql\data\databasename'.
Is there something I should do in the MySQL configuration to make the mysqlc window recognise the mysql batch command? Is there a bug in mysqlc?