want to do. Anyway, the ini file work fine.
Fred
-Original Message-
From: Mike Baranski [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 4:28 PM
To: Dinkler, Fred; Philip Daggett
Cc: Mysql List (E-mail)
Subject: Re: MySQL: my.cnf in Windows 2000
Just go (in windows explorer) t
Problem under Win2000 with any file having a .cnf extension.
That extension is reserved by Win2000 as a system (Speed Dial) file
and will automatically hide the extension from you.
You can't search for it and it will not show it. IF you create a my.cnf
file, it appears as "my"
I use 'WINNT\my
In my experience, most "large corporate" databases
are not implemented with RI enabled. The RI constraints
often interfere with user workflows (incomplete data or
data entered out of sequence) and adds processing overhead
that adds up to serious cycle drain for lengthy runs.
\\|//
One real-world example:
RBOC changes an area code for certain prefixes.
If you haven't decomposed the phone number into separate fields,
e.g. your phone number is a single field ala
"--" you have a really
interesting job ahead of you to accomplish the update.
Especially if you are a telecom
UNIX version of Y2K problem...
\\|//
(@ @)
---oOO---(_)---OOo
||
| Fred Dinkler |
| SVP Technology |
| DFII Atlanta |
| Office: 01.770.596.1443|
||
-
Rodney -
You can't execute a query across two connections simultaneously.
If you must split the tables between two hosts, network then together
at the file system level so that the database directories are accessible
by one instance of MySQL. Then connect and query that instance...