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

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

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 Scorpio.

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!

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 wrong? BO TIA, BO

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:

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:

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

RE: Problems With New Installation

2001-12-24 Thread Ben Ocean
, 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 -Original Message- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: 24

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

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

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 "br"; echo $time; echo "br"; echo $name; echo "br"; sql_query("insert into calendar

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:

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