Re: [cobalt-users] WebCalendar - MySQL issues

["Brian N. Smith" <support@xxxxxxxxxx>]

> mysql> mysql dsrcal < tables-mysql.sql;
>
> The page I'm working on, BTW:
> http://www.dallasscottishrite.org/calendar/WebCalendar-0.9.40/index.php
>
> I am banging my head against the desk wondering why it worked on another
> RaQ... I'm sure I'm missing something simple.  Am I just being dense?
Help
> /suggestions are appreciated.
>
> --Chris

Chris,

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.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.13

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+----------+
| Database |
+----------+
| mysql    |
| shop     |
| test     |
+----------+
3 rows in set (0.00 sec)

It should come back with YOURS in there.

If it is NOT there, you need to create it!

[root /root]# mysqladmin -p create dsrcal

OR

mysql> create database dsrcal;
Query OK, 1 row affected (0.00 sec)

One of the two ways will work ... then do "show databases;"

mysql> show databases;
+----------+
| Database |
+----------+
| dsrcal   |
| mysql    |
| shop     |
| test     |
+----------+
4 rows in set (0.00 sec)

mysql>

See, now it is in there!!

Brian N. Smith
NuOnce Networks
www.nuonce.net/cobalt.php



-- 
This message has been scanned for viruses and
dangerous and is believed to be clean.