Re: [cobalt-users] WebCalendar - MySQL issues

["Chris \"Oger\" Gebhardt" <oger@xxxxxxxxx>]

"Brian N. Smith" wrote
> DO NOT do it from a mysql> prompt, you want to be in the shell.  So, it
> would
> be like:
>
> [root /root]#  mysql dsrcal < tables-mysql.sql
>
> Also, you NEED to make sure that you already created the dsrcal table.
<SNIP>
> See, now it is in there!!

Hi Brian -

Thank you!

Maybe something is screwy in the MySQL installation?  Because if I give a
command starting with "mysql" then I invariably receive "No such file or
directory"   However, putting the ./ in front always seems to make it work.
Does the fact that I'm having to do everything from /home/mysql/bin indicate
a problem?   Shouldn't I be able to execute mysql from the shell just about
anyplace?

Also, I've found that I was simply not giving the proper path to the
tables-mysql.sql.  So now I've made some progress.  In addition, I'm always
required to give the password for MySQL.

However, when I was able to do this:
[root bin]#  mysql -p dsrcal < tables-mysql.sql

I was met with resistance from MySQL (again.)
ERROR 1064 at line 120: You have an error in your SQL syntax near ';


/*
 * This table associates one or more users with an event by the event' at
line 15

This is why I'm thinking the MySQL must be wierd - the commands that I am
giving appear to be pretty across-the-board standard, but with me, Murphey's
Law continues to prevail.

THANKS!

--Chris