, recreated it and then copied the table in and restarted. Works
fine now. I have restored the database in this way on the new server
machine and the application works again. :-)
Next time we'll have a more reliable backup...
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory
in
MySQL, at least it's standing in the file.
I already ran mysql_upgrade.exe but it didn't change anything.
What can I do now to restore that data?
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list
On 09.11.2011 21:58 CE(S)T, Reindl Harald wrote:
Am 09.11.2011 21:46, schrieb Yves Goergen:
The old machine was an unknown MySQL version on Windows XP
pfff - unknown version? how comes?
The old MySQL installation doesn't run anymore because the OS is gone. I
could only backup the files
faster in the past.
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, c2)
VALUES ((SELECT MAX(c1) + 1 FROM t1 WHERE c2 = 5), 5);
Is it planned at all to add that? Is it really so complicated to do it
that it hasn't been done all those years?
The MySQL bug tracker was unable to filter the bugs down to less than a
few thousands, so I'm posting it here.
--
Yves
the MySQL package. The point is that this
message is plain wrong and should be removed altogether until it works
as it claims.
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http
still
don't know where the message comes from!
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
. The server is already
up and running in production. I only want to get rid of that whole load
of messages posted to syslog. I don't know where they come from to do
further analysis.
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
not exist and a database named test also does not
exist. Yet still I see this message when starting the MySQL server.
How can I get rid of it?
MySQL 5.1 on Ubuntu 10.04
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General
client which seems to be .NET-based?
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
news about Oracle, we can imagine what will happen this time.
Exactly! Nothing.
(Oh look, the MySQL guy already has an oracle.com e-mail address...)
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
that.
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is in use?
And still why doesn't it use SSL in my case?
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
to ~600
other rows to determine whether they should be included in the results
or not.
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
. ;-)
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
. The only screenshot of it shows a
database diagram. No users, tables or instances management.
Enterprise Monitor seems to be a monitor only, and it's not free.
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing
with like /silent.
Maybe even the entire MySQLd setup works this way, so you only need to
put those two installer EXEs in your application setup and run them in a
more or less unattended mode.
--
Yves Goergen LonelyPixel nospam.l...@unclassified.de
Visit my web laboratory at http
in a certain time range.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 20.07.2008 23:49 CE(S)T, Rob Wultsch wrote:
On Sun, Jul 20, 2008 at 1:33 PM, Yves Goergen
[EMAIL PROTECTED] wrote:
Hello,
I've installed MySQL server 5.0 and have written a small statistics script
that regularly checks the number of connections and queries to the server,
which I can
information about recent activity, like 15 minutes, 2 hours or so.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
://www.google.com/search?q=150+error+mysql yields
http://bugs.mysql.com/bug.php?id=6188 as it's first result.
Not so in Germany. ;) Also, I've searched for a more specific message.
Must have missed it.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
the MySQL service but it doesn't help. Is it broken? Why
is it trying to create some random table and why does that fail?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
and α. Unicode-capability is a must for my application.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
else. The same counts for uniqueness constrains.
I've asked a freind who could test the matter with PostgreSQL. He said,
it works exactly as expected. Sorting is unicode-like, selection is
precise. Why can't MySQL do that, too? Is it so hard to distinguish
sorting and selecting?
--
Yves
5.0 version?
Meanwhile, I have chosen to use utf8_bin for all my tables. This breaks
sorting for some few cases (but it hasn't really been a problem back in
the non-Unicode-MySQL days) but in exchange finds only what I want to find.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web
, i.e. sorting should be broken, comparison is correct.
PostgreSQL didn't find its own columns again, so I cancelled the test.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http
of
iterations. And the INTERSECT keyword is a much nicer and easier to read
way of doing it.
I'm using MySQL 5.0.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 11.02.2008 19:51 CE(S)T, Perrin Harkins wrote:
On Feb 10, 2008 5:30 PM, Yves Goergen [EMAIL PROTECTED] wrote:
My problem is that the sub-select in line 7 (SELECT 1) takes a rather
long time. (When I remove it, it's much faster.)
This is a known issue with EXISTS/NOT EXISTS subqueries
with
some graphics.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
additional keys list. Virtual keys must not have an additional keys list
on their own. (And they must not have logon information.) So there
cannot be a cyclic reference. This is documented in the source code and
will be enforced on the application layer later.
--
Yves Goergen LonelyPixel
are again
stored in a keylist.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
(This is not a closed-source commercial thing. It is a web application
that will be available on my website under the GPL when it's ready. It
basically already works fine, just a little slow under some conditions.)
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http
going on?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
row, but I
only want to copy a single column of it. The rest of the record must
remain intact. So I can't use that, too.
I also try to avoid DBMS-specific workarounds where I can in this
project. So maybe one day MySQL will drop the above mentioned
restriction. :)
--
Yves Goergen LonelyPixel
On 06.02.2008 08:12 CE(S)T, Chris wrote:
Yves Goergen wrote:
My goal was to copy some potentially large BLOB from one record to
another in the same table
Update table set blob2_field=blob1_field;
This does something totally different. ;) See my first posting why.
--
Yves Goergen
target table
'message_revision' for update in FROM clause
What went wrong?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
. Is this a MySQL extension over the SQL standard?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
could not find any transaction that was left open. But executing a
ROLLBACK query at the very beginning of my application also helps to
read current data. Now what can be the reason for that inconsistency?
How can I find the problem that is causing this bug?
--
Yves Goergen LonelyPixel [EMAIL
On 20.12.2007 19:42 CE(S)T, Yves Goergen wrote:
But when I set that column to NULL
with phpMyAdmin, my application still reads the old data from the
database. phpMyAdmin keeps telling me that the value is actually NULL,
which I just entered. Whereas the persistent PHP connection doesn't see
the snapshot transaction.
Yes, all tables are InnoDB.
So MySQL does support nested transaction and both SET AUTOCOMMIT = 0
and START TRANSACTION start a new transaction level, is that true?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL
, not sure whether that's correct) in the
MySQL manual. But Martijn's explanation gives me an idea what it could
be about. But then again, if MySQL doesn't support nested transactions,
I don't see how any information can be frozen until a point when the
transaction has already been commited.
--
Yves
On 20.12.2007 22:18 CE(S)T, Baron Schwartz wrote:
On Dec 20, 2007 3:33 PM, Yves Goergen [EMAIL PROTECTED] wrote:
I wasn't able to find MVCC-related information (I assume it means Multi
Version Concurrency Control, not sure whether that's correct) in the
MySQL manual. But Martijn's explanation
, I didn't know that. But now all's clear: I
won't touch autocommit mode anymore and everything works as expected.
Thanks for your help.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http
HTTP requests even get back
the same connection again. I can see the sleeping connection on my
application database from phpMyAdmin between the requests, with
reasonable sleep time values.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
.NET or PHP offer one.
This way, I can for example use natural sorting in SQLite from .NET
applications. Does MySQL also have support for this?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives
On 14.11.2007 12:50 CE(S)T, Martijn Tonies wrote:
Yves,
Did you read this reply I send earlier? I think it does what you
want without needing to lock anything, thus making it portable.
I would suggest the following --
create a table called SEQUENCES:
Yes, I've read it and actually put
european languages. Those Swedish people think they can
stand for whole Europe... ;)
Not tested my reply, though.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 13.11.2007 01:04 CE(S)T, Perrin Harkins wrote:
On Nov 12, 2007 6:47 PM, Yves Goergen [EMAIL PROTECTED] wrote:
From what I've read about MySQL's table locks and InnoDB, you cannot use
LOCK TABLES with transactions. Either of them deactivates the other one.
Beginning a transaction unlockes
(For the record... I missed the mailing list recipient - again!!)
On 13.11.2007 00:30 CE(S)T, Perrin Harkins wrote:
On Nov 12, 2007 5:58 PM, Yves Goergen [EMAIL PROTECTED] wrote:
First I find a new id value, then I do several INSERTs that need to be
atomic, and especially roll back completely
other read or write access.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(Damn I hate those lists that don't come with a Reply-To to the list!
Resending...)
On 13.11.2007 17:39 CE(S)T, Baron Schwartz wrote:
Yves Goergen wrote:
Row level locking can only lock rows that exist. Creating new rows (that
would have an influence on my MAX value) are still possible
.
Otherwise, you can get nasty behavior. See
http://bugs.mysql.com/bug.php?id=31479
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
that exclusive full
table locking is not possible with InnoDB? Or is there another way that
I don't know yet?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 13.11.2007 20:43 CE(S)T, Baron Schwartz wrote:
Yves Goergen wrote:
I assume that at this point, any SELECT on the table I have locked
should block. But guess what, it doesn't. So it doesn't really lock.
What kind of lock are you using?
-- cxn 1
set autocommit=0;
begin;
lock
; try restarting transaction
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
time. ;)
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
happens if another user does the same in that more work region?
(Of course, this example is pseudocode, I really have a PHP application
that does this.)
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list
it in a way so that I can tell the user whether the name was
not unique or there was another error. But this case should be detected
separately.
I'll have a look at those isolation levels though. Maybe it's what I'm
looking for.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory
On 12.11.2007 20:43 CE(S)T, Yves Goergen wrote:
I'll have a look at those isolation levels though. Maybe it's what I'm
looking for.
Not quite. But I'm going the LOCK TABLES way now. Locking a single table
exclusively for those rare moments seems to be the best solution.
I could also implement
On 12.11.2007 22:16 CE(S)T, Yves Goergen wrote:
Since I only need these locks for
a very short time and a single table with no transaction support, this
works fine for me.
Damn, I found out that I need table locking *and* transactions. I'm lost...
Maybe I'm really better off using a sequence
On 12.11.2007 23:31 CE(S)T, Perrin Harkins wrote:
On Nov 12, 2007 5:24 PM, Yves Goergen [EMAIL PROTECTED] wrote:
Damn, I found out that I need table locking *and* transactions.
What makes you say that?
BEGIN TRANSACTION
SELECT MAX(id) FROM table
INSERT INTO table (id) VALUES (?)
INSERT
button first...)
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
).
I hope you understand my problem. There's two potential solutions which
both don't work for me. Is there a third? Can I create this kind of
referential integrity on the DBMS level at all? Is my design bad?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http
On 03.11.2007 22:52 CE(S)T, Yves Goergen wrote:
Is my design bad?
I should explain why I do it this way at all. There's some other tables
in my system that need to keep a list of keys (i.e. user IDs) for
several actions. A message (one of the tables) has one keylist for read
access, one
.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) and especially return codes (which can be mapped to
a 1-byte value) are probably not worth the reference. Data size values
should be too distributed for this.
How large is a row reference? 4 bytes?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
On 28.05.2007 18:34 CE(S)T, Kevin Hunter wrote:
At 5:45a -0400 on 28 May 2007, Yves Goergen wrote:
Also, URLs sometimes contain things like
session IDs. They're probably not of interest for my use but it's not
always easy to detect them for removal.
Really? Why wouldn't it be easy
older rows. Do you know something for that?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(0.00 sec)
The last two show my problem. When I search for a backslash, I need to
escape it *twice*. Why that? I can't see that from the manual [1].
[1]
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web
On 23.05.2007 14:49 CE(S)T, Yves Goergen wrote:
[1]
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like
Never mind. This very page says why it is like it is. It's definitely
too hot in here today. :(
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web
wasn't added to the recipients.)
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that the error
messages are normal and don't mean a thing.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 10.02.2007 17:39 CE(S)T, Yves Goergen wrote:
ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
(and some more similar stuff)
As I found out I already asked that on a previous upgrade. Other sources
make me think that this is not an actual error but intended if the
tables
error messages mean?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is running and works perfectly. I'm not sure if I
should upgrade to 5.0.24 if this script doesn't work.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Distrib 5.0.21, for pc-linux-gnu (i686) using readline 5.0
What for do I specify the basedir and datadir (which should be enough)
if mysql_upgrade can't use it to find the files?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General Mailing
, NEW.USER_max_space, 0)
END;
But, it doesn't work...
Does somebody have an idea ?
Thanks,
Jean-Yves.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFEx9U6ckDu29zkZ3kRAmucAKC/iiJeidWM2UHDPWVu5DL4in4VvACeN42N
tracker...
I am no SSL expert, but AIUI you need client and server to use the same
(or at least somehow related) certificates.
The client needs what? Since when is it that a client needs a
certificate, too, to use an SSL-encrypted connection to a server?!
--
Yves Goergen LonelyPixel [EMAIL
connect to it with mysql/Linux with the --ssl parameter (through a
hostname with a different IP, not a named pipe). But it also doesn't use
any SSL, although explicitly specified and offered by the server. Seems
like SSL isn't really a production level thing yet.
--
Yves Goergen LonelyPixel [EMAIL
, as opposed to what the doc
says.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 21.05.2006 00:16 (+0100), Yves Goergen wrote:
Hello,
I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL
4.0 and 5.0 database server, both on Linux. In Query Browser, I can
check the options Use SSL if available but how do I know if it is
available and used? I couldn't
it's checked,
it says Could not connect to the specified instance. MySQL Error Number
0 The ping works fine, without SSL I can connect to the server.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General Mailing List
For list archives
On 21.05.2006 07:35 (+0100), paul rivers wrote:
Are you certain? Which version are you running?
I don't have it on MySQL 4.0 and on MySQL 5.0 it has the value 0 so I
guess it's not connecting through SSL.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web
of connections. What use has an option SSL if you
can if I can't find out whether it actually does SSL or not... I simply
require it to do and to not connect at all if it can't.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General
On 21.05.2006 00:38 (+0100), paul rivers wrote:
- Inspect the 'show status' variable of Ssl_accepts after a connection
attempt on an otherwise quiet mysql instance.
I have no such status variable in my server.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web
have the impression, from reading the scripts.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
servers and there is no such global
config file which all scripts seem to assume. There is one for each
server and they are located in the datadir to make it easy (following
the default setup).
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL
to be
inside the programme directory? Is there any other way to move the
datadir out there without hacking all the scripts - over and over with
each update? (Then I could just as well move the datadir each time...)
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web
that be okay?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
not reasonable.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
http://beta.unclassified.de – My web laboratory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
servers through different
hostnames, you need different IP addresses for them to listen on.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
This message represents the official view of the voices in my head.
http://newsboard.unclassified.de - Unclassified NewsBoard Forum
--
MySQL General Mailing List
to MySQL 4.0 via mysql4.mydomain and
to MySQL 5.0 via mysql5.mydomain... But I'll try to do it by
restricting access to the primary hostname/IP for now.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
This message represents the official view of the voices in my head.
http://newsboard.unclassified.de
On 10.04.2006 18:32 (+0100), Jorrit Kronjee wrote:
I'm not entirely sure what you mean. Are `mysql4.mydomain' and
`mysql5.mydomain' hostnames?
Yes, as I have explained earlier in this thread.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
This message represents the official view
to only allow certain users to connect from
localhost?
As I think about it, a local TCP forwarder would accept connections on
localhost, but MySQL won't see that, so this wouldn't work anyway.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
This message represents the official view of the voices in my
/hostname, it won't let me in. Need to test it further. I guess the
correct way would be to allow access from the external IP of the server?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
This message represents the official view of the voices in my head.
http://newsboard.unclassified.de
is only bound to
another external address.
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Does the movement of the trees make the wind blow?
http://newsboard.unclassified.de - Unclassified NewsBoard Forum
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
after the other
IP, it will only bind to this one.
Any more suggestions? Maybe someone from the dev team? Should I install
a local port forwarder?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Does the movement of the trees make the wind blow?
http://newsboard.unclassified.de - Unclassified
On 08.04.2006 23:14 (+0100), Eric Braswell wrote:
Yves Goergen wrote:
How can I enter multiple IP addresses there? This isn't documented
online. I need to bind it to one specific external address and
additionally to localhost (127.0.0.1). The other server is only bound to
another external
, but no idea how to specify a custom IP. Any hints?
--
Yves Goergen LonelyPixel [EMAIL PROTECTED]
Does the movement of the trees make the wind blow?
http://newsboard.unclassified.de - Unclassified NewsBoard Forum
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
1 - 100 of 206 matches
Mail list logo