, 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"
Visit my web lab
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 o
gs 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"
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing Lis
much faster in the past.
--
Yves Goergen "LonelyPixel"
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
here:
UPDATE t1 (c1, 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
while installing 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"
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http:
a file I could start something with. So I still
don't know where the message comes from!
--
Yves Goergen "LonelyPixel"
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
x27;t want to install things. 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"
Visit my web laboratory at http://beta.unclas
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"
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing Lis
ble to also have this in the MySQL Workbench
client which seems to be .NET-based?
--
Yves Goergen "LonelyPixel"
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
usiness, regarding
recent bad 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"
Visit my web laboratory at http://beta.unclassified.de
--
MySQL
SSL thing looks pretty unfinished like that.
--
Yves Goergen "LonelyPixel"
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
ication data in plain text over the network before I can
even verify that SSL is in use?
And still why doesn't it use SSL in my case?
--
Yves Goergen "LonelyPixel"
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
27;s probably fast, but it is applied to ~600
other rows to determine whether they should be included in the results
or not.
--
Yves Goergen "LonelyPixel"
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
clean
it again to see things more accurately. ;-)
--
Yves Goergen "LonelyPixel"
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
an E/R modeling tool. 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"
Visit my web laboratory at http://beta.unclassified.de
--
MySQL Ge
ODBC driver setup
could be packaged and run as external application 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"
rking most 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
command. I mean
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 unsubsc
;s fixed, too. :)
http://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" <[E
uot; ADD FOREIGN KEY ("MessageId", "SearchRevision")
REFERENCES "message_revision" ("MessageId", "RevisionNumber") ON DELETE
CASCADE;
Now the last command produces this error:
#1005 - Can't create table '.\unb2test\#sql-770_2.frm'
icode, right? So it could sort a, ä and à but not
ā, ă 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]
ance to see it in a MySQL 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 "Lonely
tly, I only want to get that back,
nothing 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 di
uage layer to do it right. I only
know that SQLite stores in UTF-8 but otherwise doesn't care about
Unicode, 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" <[EMAI
doing a lot 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 archi
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/
if there's a way to explain all this better 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]
ust not be part of a user's
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.
--
I have quoted last time is mainly the main
query's last condition in the WHERE clause. It handles access coming
from tags. The first half of the condition handles access coming from
the message's own ReadAccessKeylist.
(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://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
's additional keys, which 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]
them, then SELECT will pick
some columns (and thereby execute my sub-select expression) and finally
HAVING filters again. Since in my theory there is no single row, SELECT
has nothing to do. But obviously it has.
Some suggestion what's 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]
rite the entire 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.
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
ostgreSQL's and
SQLite's reference. 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]
HERE "MessageId" = 7 AND "RevisionNumber" = 6
SQL error: [SQLSTATE:HY000, 1093] You can't specify target table
'message_revision' for update in FROM clause
What went wrong?
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web labo
nection in my application, so it
must be that one. Most of the time, further 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 &qu
ON does not finish my transaction. (But then,
what does?) Interesting view, 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
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
currency Control, 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
transac
not end 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
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 connec
g persistent
database connections in my application helps to always read current data.
I 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
h enables you
to use a custom function to sort strings, like .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 h
e for
european/western 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 ar
tive transaction. This requires a
second connection to the database which probably causes more
implementation work for my web application.
I don't need LOCK TABLES anymore now. And at last, I can say that this
is indeed not a simple topic as I've thought and maybe I've read most of
t
test my application the next 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]
have some table locking, tested, working. Very nice. Thank
you for this one. :)
> ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
--
MySQ
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
t I need). May I now conclude 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
st in MySQL 5. Even if you're using non-transactional tables.
> 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 Ge
(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
gt; -- your tables are now unlocked.
> The manual isn't very clear on the interaction between LOCK TABLES and
> transactions, it's true. But this is what I've found.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta
y need locking an entire table
for every 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]
(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
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
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 I
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
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 be
endent. I'd
like to do 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 &
d, ...)
COMMIT
What 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.unclassifi
n that
value (not row!) shall be set to NULL.
Regarding it this way, my hope to get this done with RDBMS means shrinks...
(Sorry for double sending, I hit the "Reply" 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]
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 re
upported (and undocumented) by MySQL 5.0. Also, MySQL requires
uncommonly high privileges to create a trigger which is not an option in
the field (I'm planning to release my application for use on common web
space).
I hope you understand my problem. There's two potential solutions which
both don&#x
that contain "#" or "--" or "/* ... */" inside a
string. So I would highly recommend not using those.
--
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 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.
>
nal access log files when I've updated the UA
parser.)
IP addresses (IPv4) 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 &q
seful to delete 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]
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" <
%' |
+--+
|1 |
+--+
1 row in set (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/refm
some data?
(Resending because the list 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]
nal tables don't
allow that. But as you see, I already found out 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
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 intend
is Debian Linux 3.1, previous MySQL
version was 5.0.17, installed from the binary release.
What do the above 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]
inux max version of MySQL.
--
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]
efore it has seen any MySQL.
'mysql --version' says:
mysql Ver 14.12 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 "LonelyPix
Debian 3.1 Linux
system. The server 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
F
least it looks
like the MySQL server doesn't require a "CA", 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]
ut I can
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.
-
et.
So I need yet another account for your bug 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-encrypte
y Browser without the SSL checkbox. When 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
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
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 PROTECTE
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]
ow me the
encryption status 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]>
htt
I said, there are two MySQL 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]>
nobody has thought about doing that
before. At least I don't 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]
her datadir is obiously 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]
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]
is true that MySQL wants all its databases 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" &
ess different MySQL 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 - Un
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]>
"Th
part to connect 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 mes
k.
Granting access only for connections from "localhost" when connecting to
the server actually from the same host but through its external
IP/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 s
w server.
Or is there another way 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 PROTECTE
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 i
e 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.unclas
27.0.0.1). The other server 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
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
> my.cnf:
>
> bind-address =
>
> Will probably do the trick.
Thank you, that's what I was looking for.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
"Does the movement of the trees make the win
1 - 100 of 171 matches
Mail list logo
