be
worth noting that the server daemons on the OSX box and Linux box had no
problems and kept chugging along.
I would doubt that it matters, but the master for this machine is
running MacOS Jaguar.
Thanks,
-jeff
--
Jeff Kilpatrick
Oklahoma Medical Rese
Michael-
That seems to be correct. I've been able to do this using PuTTY as the
client. Just forward the local 3306 to the server's 3306 and connect to
localhost:3306. Be sure to log to the server via ssh before attempting
a connection.
-jeff
On Thu, 2003-03-13 at 13:09, Tam, Michael wrote:
>
Charles-
So, you have a table unique with respect to people (a person appears at
most once), and a table with interests (some number of interests are
associated a person in the first table. This is a one-to-many
relationship. You need to join on the person in the first table.
Something like
SE
n my PHP form?
>
> Thanks,
> Charles
>
>
>
> On Saturday, March 15, 2003, at 11:30 AM, Jeff Kilpatrick wrote:
>
> > Charles-
> >
> > So, you have a table unique with respect to people (a person appears at
> > most once), and a table with inter
How are you dumping the database? It doesn't seem like you should have
problems going either direction, especially to a case-insensitive
filesystem.
Copying databases with something like
$ mysqldump | mysql -h
works for me, even if it is fairly slow.
-jeff
(formerly kilpatjr_at_lupus.omrf.ou
Jeff-
Actually, thsee sound like the binary log files used primarily for
replication. If you're on host doctorpants, they'll be
doctorpants-bin.001
doctorpants-bin.002
doctorpants-bin.index
and so forth. If you don't want a write query log and aren't doing
transactions, remove the binlog option
Does the mysql user have permission to write to /var/lib/mysql?
-jeff
On Tue, 2003-03-25 at 20:31, [EMAIL PROTECTED] wrote:
> >Description:
> Just installed the rpm files for Linux x86 downloaded from the web.
> After installing rpm files, server won't start. The error (from the log) is:
>
ble with the rpm, a source build may or
may not be what you're looking for. I'd go that route, but any of my
co-workers can attest to the fact that I'm an obsessive compiler.
-jeff
On Wed, 2003-03-26 at 15:49, Saul wrote:
> >From: Jeff Kilpatrick <[EMAIL PROTECTED]>
Hello Ramanan-
First off, make sure you create tables of type InnoDB, Berkeley, or
Gemini. [My]ISAM tables don't do transactions.
The simplest way to do a transaction is
mysql> BEGIN;
mysql> # successful edit
mysql> COMMIT;
or
mysql> BEGIN;
mysql> # failed edit, or dropped connection implies
my
Sunil-
Seems the easiest way to restrict the size of everything except
privilege tables is to use nothing but InnoDB tables. You can set the
default table type using --default-table-type=InnoDB when launching
mysqld.
If you're not keen on that, you may want to look into using a quota on
your mys
It's also interesting to note that it's possible to split innodb data
between multiple files to have databases larger than the OS's max file
size.
-jeff
On Thu, 2003-03-27 at 14:17, Dathan Vance Pattishall wrote:
> ISAM tables are cut off at 4gb of data
> MYISAM / INNODB /BDB have a filesystem lim
What's your log say?
Should be in /var/lib/mysql/.err
-jeff
On Fri, 2003-03-28 at 18:32, Joseph Bannon wrote:
> I installed mysql 4 today and ran mysqld_safe. Here is
> what I get back...
>
> [EMAIL PROTECTED] admin]# Starting mysqld daemon with
> databases from /var/lib/mysql
> 030328 05:22:3
This is not flamebait. I'm not trying to be disagreeable or a jerk.
Just a thought.
What about IMAP?
-jeff
On Wed, 1969-12-31 at 17:59, mazur wrote:
> ---
> ** ORIGINAL MESSAGE FROM:Jeremy Zawodny <[EMAIL PROTECTED]>**
> ** ORIGINAL MESSAGE SENT:Tue Apr 0
13 matches
Mail list logo
