Re: Restrict MySQL server 4/5 to single IP

2006-04-09 Thread Yves Goergen
On 09.04.2006 01:03 (+0100), Eric Braswell wrote: Does that make sense? Did I misunderstand? That's exactly what I'm doing right now. In my test network: MySQL 4.0 - 192.168.0.32 (mysql4.myhost) MySQL 5.0 - 192.168.0.33 (mysql5.myhost) But what I wanted to do is: MySQL 4.0 -

Re: Restrict MySQL server 4/5 to single IP

2006-04-09 Thread Eric Braswell
But what I wanted to do is: MySQL 4.0 - 192.168.0.32 and 127.0.0.1 MySQL 5.0 - 192.168.0.33 I'm going to assume you are using some kind of Unix-like platform. When you connect to localhost, you are actually connecting by default through a Unix socket file, not TCP/IP, because it is

Re: Restrict MySQL server 4/5 to single IP

2006-04-09 Thread Yves Goergen
On 09.04.2006 20:02 (+0100), Eric Braswell wrote: I'm going to assume you are using some kind of Unix-like platform. Correct, it's a Debian Linux x86. When you connect to localhost, you are actually connecting by default through a Unix socket file, not TCP/IP, because it is much faster.

Re: Restrict MySQL server 4/5 to single IP

2006-04-09 Thread Jorrit Kronjee
Yves Goergen wrote: On 09.04.2006 01:03 (+0100), Eric Braswell wrote: Does that make sense? Did I misunderstand? That's exactly what I'm doing right now. In my test network: MySQL 4.0 - 192.168.0.32 (mysql4.myhost) MySQL 5.0 - 192.168.0.33 (mysql5.myhost) But what I wanted to do is:

RE: history not working -- it's a bug!

2006-04-09 Thread Andrew
I installed 5.0 and 5.1-beta on three different system (all are Fedora Core 4), and each time when I use the command-line client, I can not use the familiar up-arrow feature that normally lets you scroll through queries issued during previous command-line sessions. My history is completely

Re: Reserevd Error -7776 -- Urgent

2006-04-09 Thread Daniel Kasak
C K wrote: Dear Friends, I have linked tables from MySQL through ODBC DSN in Access 2003. when I go for updating any record in any linked table then it gives me error as follows: Reserved Error (-7776); there is no message for this error. What will be the problem? Please help. Is this error from

Re: New MySQL Transaction Engine Announced

2006-04-09 Thread Greg 'groggy' Lehey
On Friday, 7 April 2006 at 9:52:46 -0500, mos wrote: In case anyone is interested in where MySQL is going with transactions http://www.computerworld.com.au/index.php/id;1262876365;relcomp;1 Before anybody goes overboard here based on the Subject: line, read the article. This is not New

database backup and restore

2006-04-09 Thread murat .
Dear all, I have mysql 4.1.11 on my current server, i need my database restore another server.. (another server mysql version is 4.1.11 same.) And now... I just created new my database to new server following command: CREATE DATABASE dbname DEFAULT CHARACTER SET latin5 COLLATE

New to TRIGGER and CALL. Example gives errors.

2006-04-09 Thread Daevid Vincent
I'm trying to follow the example in the manual to create a trigger: http://dev.mysql.com/doc/refman/5.0/en/using-triggers.html #DROP TRIGGER upd_check; delimiter // CREATE TRIGGER upd_check BEFORE UPDATE ON starkeys FOR EACH ROW BEGIN IF NEW.skey 1 THEN SET NEW.skey = 1;

Effective-dating

2006-04-09 Thread Douglas Sims
Does anyone know of a thorough discussion of effective dating on the web, particularly with respect to MySQL, or have any opinions you could share? I've worked with effective-dated tables in MS SQL Server and never been particularly awe-struck by how well it works. I can think of

Re: Restrict MySQL server 4/5 to single IP

2006-04-09 Thread Eric Braswell
Jorrit Kronjee wrote: You seem to be best off with a setup where you've got the MySQL5 UNIX socket disabled, MySQL5 bound to one specific IP address, MySQL4 listening on 127.0.0.1 and a simple port forwarding rule to MySQL4. Then your clients won't have to change anything and they can migrate