Re: Deep Nesting (sql)

2002-07-07 Thread Ben Ocean
Beautiful. Thanks! BenO At 05:00 PM 7/7/02 -0500, you wrote: > >The tables will be used to enable users to enter comments concerning what > >they believe happens at individual conjunctions. For example, in astrology, > >let's say one enters a comment of what happens when the Moon enters > >Scorpi

Deep Nesting (sql)

2002-07-07 Thread Ben Ocean
Hi; I'm trying to programmatically create tables which are nested so deeply that I fear I'll be creating a gargantuan number of them. I'm seeking a means to limit this, if possible. I'm creating what I call *open source metaphysics*. Here's the scenario: The tables will be used to enable users

Deep Nesting

2002-07-07 Thread Ben Ocean
Hi; I'm trying to programmatically create tables which are nested so deeply that I fear I'll be creating a gargantuan number of them. I'm seeking a means to limit this, if possible. I'm creating what I call *open source metaphysics*. Here's the scenario: The tables will be used to enable users

Re: MySQLDump

2002-04-18 Thread Ben Ocean
At 08:46 AM 4/18/02 -0700, you wrote: >mysql>> mysqldump --databases nwhotspring > a.a; >BO> ERROR 1064: You have an error in your SQL syntax near 'mysqldump >BO> --databases nwhotspring > a.a' at line 1 > >BO> I can't even run mysqldump --help without getting that error! What am I >BO> doing wron

MySQLDump

2002-04-18 Thread Ben Ocean
Hi; I can't get a dump of a database! I'm in as every user I have and get this: mysql> mysqldump --databases nwhotspring > a.a; ERROR 1064: You have an error in your SQL syntax near 'mysqldump --databases nwhotspring > a.a' at line 1 I can't even run mysqldump --help without getting that error!

Permissions Problem

2002-02-12 Thread Ben Ocean
Hi; I get this error when I try to access a database as root: mysql> use antigo; Can't read dir of './antigo/' (Errcode: 13) What does this mean and how do I fix it? TIA, BenO - Before posting, please check: http://www.mys

Permissions Problem

2002-02-05 Thread Ben Ocean
Hi; I get this error when I try to access a database as root: mysql> use antigo; Can't read dir of './antigo/' (Errcode: 13) What does this mean and how do I fix it? TIA, BenO - Before posting, please check: http://www.mys

RE: Problems With New Installation

2001-12-24 Thread Ben Ocean
of mysqld is. Oops. Yep, that was the error. Thanks! Merry Christmas! BenO >Also, have you installed the mysql database with > mysql_install_db >in the scripts directory? > >This installs the database 'mysql' which contains all user >authentication. > >M >

Re: Problems With New Installation

2001-12-24 Thread Ben Ocean
I forgot to mention that /var/lib/mysql is owned by root and I'm in as root. I've also changed permission to mysql ownership of said directory with no luck. Any ideas? At 08:31 AM 12/24/01 -0800, you wrote: >Hi; >I've successfully installed mysql from source. However, I've run into a >problem

Problems With New Installation

2001-12-24 Thread Ben Ocean
Hi; I've successfully installed mysql from source. However, I've run into a problem with trying to create databases or users: mysql> create database cc_store; ERROR 1006: Can't create database 'cc_store'. (errno: 13) Furthermore, I can't edit the root password. What fundamental step have I mis

Compiling From Source

2001-12-22 Thread Ben Ocean
Hi; I've written this config script: #!/bin/sh cd /usr/local/mysql ./configure \ --with-libwrap=/usr/share/doc/tcp_wrappers \ --with-raid \ --with-thread-safe-client exit 0 Running the script gives me this error: /usr/local/bin/config_mysql: --with-raid: command not found *however* running mak

HELP! Hosed Database!

2001-11-26 Thread Ben Ocean
But I have a backup, if I just knew how to restore it! The instructions read: #mysqldump --opt database_name > database_name_File.txt To restore database: #cat database_name_File.txt | /path/to/mysql -u username -p database_name So, if my installation is at /apache/mysql and the database is /apac

Why Doesn't This Work???

2001-02-23 Thread Ben Ocean
Hi; I insert the following code in a file: >>> $count = sql_command("select count(id) from calendar"); $count = $count[0] + 1; $mydate = $month.','.$day.','.$year; echo $mydate; echo ""; echo $time; echo ""; echo $name; echo ""; sql_query("insert into calendar (id,

What Does This Mean?

2001-02-13 Thread Ben Ocean
Hi; I'm getting this error: >>> Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 >= 3.0.8 <<< What does it mean and what should I do about it (if anything)? TIA, BenO - Before posting, please check: http://www.m

Upgrading

2001-02-12 Thread Ben Ocean
Hi; I'm trying to upgrade to the latest distro. I thought I could simply d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm When I do I get no error messages, but no upgrade seems to occur (i.e., I get the old version number at the my