(assuming those entries were already in 'db'
and 'user') work fine, but 'localhost' no longer works after the reboot.
Cheers,
-Richard
Moon's Father wrote:
Add skip-name-reslove in my.cnf and restart mysql immediately.
On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods
[EMAIL PROTECTED
'
and 'user') work fine, but 'localhost' no longer works after the reboot.
Cheers,
-Richard
Moon's Father wrote:
Add skip-name-reslove in my.cnf and restart mysql immediately.
On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote
I have a server that runs only MySQL. It services several other servers
inside a firewalled intranet. All connections to the MySQL database are
done using static IP addresses.
Recently I had to start monitoring the firewall traffic on this
intranet, and discovered the MySQL server is
[EMAIL PROTECTED] wrote:
Point to an internal dns server
We don't have one.
Is somebody with a weird hostname connecting to your server via ssh ?
Nope. This is occurring while the server's intranet is totally unmanned.
-Richard
--Original Message--
From: Richard S
Awesome! Thanks very much - exactly what I was looking for. I'm in the
field and was under the gun, otherwise would have checked the manuals first.
Again, thanks.
-Richard
Hassan Schroeder wrote:
On Wed, Oct 22, 2008 at 7:40 AM, Richard S. Huntrods
[EMAIL PROTECTED] wrote:
Recently I
SIGNED MESSAGE-
Hash: SHA1
Richard S. Huntrods wrote:
I need to access a specific directory from within tomcat, but I'm having
a specific problem and require some advice.
I have a link to a file in the servlet, something like
https://myserver.com/special-directory/file.zip;
If I create
I need to access a specific directory from within tomcat, but I'm having
a specific problem and require some advice.
I have a link to a file in the servlet, something like
https://myserver.com/special-directory/file.zip;
If I create the directory as follows:
Very Sorry!!!
I sent a Tomcat request to this list by mistake. Please ignore it.
Thanks,
-Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've submitted this problem three times now, and been ignored all three
times. I guess bugs are simply not popular. Since the problem described
below is 100% repeatable, I will now escallate it from problem with
delete/insert to BUG IN MYSQL.
Cheers...
I've distilled the problem I'm having
Miguel,
miguel solorzano wrote:
At 16:05 3/1/2004 -0700, Richard S. Huntrods wrote:
I've submitted this problem three times now, and been ignored all
three times.
Sorry for this inconvenience but I suggest you in the next time to
use the MySQL's forums for to report bugs instead
Udo,
Thanks - I found the bug in the database. Looks like it's been fixed in
4.0.17 (the bug was reported in 4.0.14 and I'm running 4.0.15).
The bug was also not in my Solairs system - using 4.0.5a.
Thanks,
-Richard
Ugo Bellavance wrote:
-Message d'origine-
De : Richard S
My problem with deletes/inserts corrupting the database table has been
resolved. I was using version 4.0.15, and the very bug I experienced was
reported for version 4.0.14. As of 4.0.17, it is fixed. Interestingly,
the bug does not appear in 4.0.5a on my Solaris box.
Which brings me to my more
I've distilled the problem I'm having with DELETE/INSERT to an even
simpler test case.
Here's the SQL - it can be used with any database, not just the special
expdb I created. I run this script followed by running mysqlcheck
expdb.
#
USE expdb;
DROP
I've isolated this problem down to a single table and SQL script that
demonstrates the problem repeatably.
There are 4 SQLl scripts here - one to create remove the database, one
to create the database and user entries, one to create the table, and
one to access the table. It is the 3rd that
I'm having a strange problem with trying to delete records with MySQL.
System: Win XP home, Mysql 4.0.15. Implementation with this version
since 10/01/2003 with no problems.
Normal access: MySQL JDBC driver (used to be the MM driver, now obtained
from MySQL), Java SDK 1.4.2_01. Problem has been
Stefan,
Stefan Hinz wrote:
Richard,
set-variable = max_allowed_packet=16M
Yikes!!! I knew that running default configuration gave you SOME
values, but I didn't know they were so small. I've placed the
my-medium.cnf as my.cnf in /etc on the Sparc 20, and also in C:\ on
the
Stefan,
H. On the solaris machines (both), there is currently NO my.cnf
file anywhere, yet MySQL has been working just fine. I imagine default
values are being used for everything. I'll have to select one of the
.cnf files from support-files. I'll let you know how it works.
-Richard
Sefan,
Stefan Hinz wrote:
Richard,
H. On the solaris machines (both), there is currently NO my.cnf
file anywhere, yet MySQL has been working just fine. I imagine default
values are being used for everything. I'll have to select one of the
.cnf files from support-files. I'll let you
I am having a strange problem reloading data into one copy of MySQL.
Details:
production server: MySQL - Ver 8.38 Distrib 4.0.5a-beta, for
sun-solaris2.8 on sparc
development system: MySQL - Ver 8.38 Distrib 4.0.5a-beta, for
Win95/Win98 on i32
test system: MySQL - Ver 8.38 Distrib 4.0.5a-beta,
machine).
Still, it may be a concern to the MySQL developers - not that there are
memory limitations, but rather that they resulted in error messages that
were both incorrect and not indicative of the real problem.
-Richard
Richard S. Huntrods wrote:
I am having a strange problem reloading
I have been running MySQL on a W2K platform for over a year now. The
system is normally accessed through servlets, using the mm jdbc driver.
I have a number of standalone java programs that also access the
database using the mm driver. These have always worked quite well,
until today.
One
I have been running MySQL on a W2K platform for over a year now. The
system is normally accessed through servlets, using the mm jdbc driver.
I have a number of standalone java programs that also access the
database using the mm driver. These have always worked quite well,
until today.
One of
Mark,
Mark Matthews wrote:
Richard S. Huntrods wrote:
I have been running MySQL on a W2K platform for over a year now. The
system is normally accessed through servlets, using the mm jdbc
driver.
I have a number of standalone java programs that also access the
database using the mm
Benjamin,
Benjamin Pflugmann wrote:
Hi.
I guess your problem comes from the fact that SQL has no concept of
internal order. If you do not specify an ORDER BY clause, the order or
records returned is undefined, i.e. random.
That's what I was figuring. I asked because I wanted it
DLN,
Thanks. Interestingly enough, pulling records without a sort was rather
random (rather, influence by the last sort) - but once I placed a primary
key on the table, the order of unsorted records is always constant, even
after a sort (based on numerous tests yesterday and today with the
Greetings!
If you do not have an index on any column in a table, how does mysql
handle repeated queries (i.e. SELECT * FROM report;)
I am noticing that if I run the following three queries, I get different
results for the third query:
SELECT * FROM report;
SELECT * FROM report ORDER BY
Ingvar,
I have not used mysql data dumps directly to restore my databases, but I
take the mysqldump output and massage them a bit, then use them for
restores.
Basically, the mysqldump output is missing the use xxx command to
change to the target database. I have a perl script that does that
Arjen,
Arjen G. Lentz wrote:
Hi,
Thanks for the great reply!
- Original Message -
From: Richard S. Huntrods [EMAIL PROTECTED]
Basically, the mysqldump output is missing the use xxx command to
change to the target database. I have a perl script that does that (and
extracts
Greetings!
I am having a real silly problem - probably something simple I've
forgotten.
I have been running mysql 3.23.39a on both Windows and Solaris for 5
months now, no problems.
I just upgraded the windows machine to mysql 4alpha, and had a problem
with passwords. I have one key user
I fixed the problem I just posted with MySql new installs not seeing
my passwords.
I had simply forgotten to flush the permissions after I set the
password.
mysqladmin -u root flush-privileges
Cheers,
-Richard
-
Before
30 matches
Mail list logo