MySQL Database Forum

HI all, I want to ask whether I can do replication in the following case. innodb (master) --replication --> myisam (slave) Rgds, Ringo --

Hi. With MySQL 4.1.0 alpha when I try to set default character set to tis620 MySQL start OK but have crash every time when perform to tun query (with default_character_set=latin1 it never got error) and with MySQL 4.0.14 it can do with out any error. With MySQL 4.1.0 alpha what GUI to use for connect to MySQL server with out error (due...

I know this is the mysql mailing list but I have tried the Fuse mailing list and no one will help well what im wanting to know is how could I get more avatars show in a room like I already have it where all users that are logged in control this 1 avatar im trying to make it where every user has his/her own avatar ...

Hi. With MySQL 4.1.0 alpha when I try to set default character set to tis620 MySQL start OK but have crash every time when perform to tun query (with default_character_set=latin1 it never got error) and with MySQL 4.0.14 it can do with out any error. With MySQL 4.1.0 alpha what GUI to use for connect to MySQL server with out error (due...

hi guys... i am doing the eclipse-tomcat-jboss-mysql integration but i just cant get to see why jboss wont start properly; hes a snippet of the error i am getting: Starting deployment of package: file:/C:/jboss/server/default/deploy/mysql-service.xml 15:14:32,078 WARN Duplicate throwable nesting of same base type: class...

I know this is the mysql mailing list but I have tried the Fuse mailing list and no one will help well what im wanting to know is how could I get more avatars show in a room like I already have it where all users that are logged in control this 1 avatar im trying to make it where every user has his/her own avatar ...

hi guys... i am doing the eclipse-tomcat-jboss-mysql integration but i just cant get to see why jboss wont start properly; hes a snippet of the error i am getting: Starting deployment of package: file:/C:/jboss/server/default/deploy/mysql-service.xml 15:14:32,078 WARN Duplicate throwable nesting of same base type: class...

Hello List, How can I see the value of master-connect-retry? show variables doesn't work on it. Thanks Anticipated, Iulian

Hi , I am this error while running mysqld_safe # ./bin/mysqld_safe --user=mysql & 19413 # Starting mysqld daemon with databases from /export/home/siptech/vidhya/ifmonitor/mysql/data 030728 12:17:49 mysqld ended The daemon is not starting . what could be the problem thanks

Hello List, How can I see the value of master-connect-retry? show variables doesn't work on it. Thanks Anticipated, Iulian

$B$*@$OC$K$J$C$F$*$j$^$9!#(B $B%D%?%M%9(B@TSTI$B$G$9!#(B Hello, I am trying to install MySQL 3.23.55 on HP-UX 11.11 When I ran ./configure, I got the following messages : Configure: WARNING: sys/socket.h: present but cannot be compiled

Can I put a new charset or modify an existing one without recompiling MySQL? If yes, please tell me how. Thanks Anticipated, Iulian -- MySQL General Mailing List

$B$*@$OC$K$J$C$F$*$j$^$9!#(B $B%D%?%M%9(B@TSTI$B$G$9!#(B Hello, I am trying to install MySQL 3.23.55 on HP-UX 11.11 When I ran ./configure, I got the following messages : Configure: WARNING: sys/socket.h: present but cannot be compiled

Can I put a new charset or modify an existing one without recompiling MySQL? If yes, please tell me how. Thanks Anticipated, Iulian -- MySQL General Mailing List

Hi List Can anyone help me to do the following without the need of subselects: I have a table that contains rows where mostly, the only common field is the "name". The rest of the data fields, even though they are related to the "name", differs from row to row ( they are things like the address etc, which could have changed on the next...

Hi List Can anyone help me to do the following without the need of subselects: I have a table that contains rows where mostly, the only common field is the "name". The rest of the data fields, even though they are related to the "name", differs from row to row ( they are things like the address etc, which could have changed on the next...

hello =09I have a OpenBSD3.3 box with mysql-server 4.0.13. the= mysql-server runs normally at the beginnig . Trouble come up= these days that the mysqld server will down . There's error= messages appers that lost connection during query when the= client connect to it. =09There's errors in .err log files like this:

hello =09I have a OpenBSD3.3 box with mysql-server 4.0.13. the= mysql-server runs normally at the beginnig . Trouble come up= these days that the mysqld server will down . There's error= messages appers that lost connection during query when the= client connect to it. =09There's errors in .err log files like this:

hey there, i thought you'd like to check this out it's very special.only the banks know about it.. you're placed up for auction and financers outbid each other on getting you the best deal on your mortgage! http://srd.yahoo.com/drst/876786/*http://cheapermortgage.cn/4/index.asp?RefID=198478

What is the symbol to do for in "ALTER TABLE ... ADD CONSTRAINT symbol FOREIGN KEY ..."? In the manual, they say that "SHOW CREATE TABLE" gives the internal id of the foreign key. Trying to do so, i see that it's not true... How can I do to drop some foreign keys excepted the "DROP TABLE/CREATE TABLE" solution because my tables have a lot...

What is the symbol to do for in "ALTER TABLE ... ADD CONSTRAINT symbol FOREIGN KEY ..."? In the manual, they say that "SHOW CREATE TABLE" gives the internal id of the foreign key. Trying to do so, i see that it's not true... How can I do to drop some foreign keys excepted the "DROP TABLE/CREATE TABLE" solution because my tables have a lot...

Hello programmers: I use Version DBMS MySQL 3.23.55 runing under Windows 2000. I have coded this from a textbook; === C:\mysql\bin>type constraint.sql USE company;

Dear MySQL developers, Could some experienced Database developer please take a look at this ? It is supposed to be plain SQL2. How can it be coded under MySQL Especially all referential triggered actions.

Dear Fred, according to what I experience,=20 I do definitely run the default binaries, perhaps the daemon mysqld has to be started with an option in order to support InnoDB ? How can this be investigated ? C:\mysql\bin>mysqld -v mysqld Ver 3.23.55-max-debug for Win95/Win98 on i32

Hi Programmers, after this legal statement ALTER TABLE EMPLOYEE TYPE =3D InnoDB; I get=20 Warnings: 0 =20 and still MySQL claims to have to use Type =3D MyISAM,