Hi people,
I have a small problem. I forgot the password for user root in my
personal MySQL instance. I'm a Linux user and running Debian Sarge on my
computer. I have few other DBs which I created and which I have access
to (still I remember the passwords) but are not having access to MySQL
databa
any suodo columns are there Like Rowid, rownum in mysql
--
Thanks & Regards,
veerabhadra rao narra,
+91-988-556-5556
--
Thanks & Regards,
veerabhadra rao narra,
+91-988-556-5556
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
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
three
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;
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
latin5_turkish
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 M
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
>>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 compl
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
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.
> 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
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 -> 19
14 matches
Mail list logo
