MySQL Database Forum

------=_NextPart_000_008D_01C355F5.DA1B8150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have read in past postings that UTF8 is not yet working with MySQL 4.1 = on the Windows build. Can anyone verify this? If it is not yet working, can anyone give an estimate when a build will = be...

Hello. I have MySQL 3.23.41 on a RH-7.2 Linux used as local server. I'm trying to replicate the databases from server (192.168.0.1) to another linux PC (192.168.0.3). Following the manual, i grant to the master a user with file privileges, and edit both my.cnf files. The master starts fine but the slave mysql.log shows up an error: Slave...

Hi, I was wandering is there an easy way to rebuild indexs on tables I have the .frm and .MYD files. I read in the mysql manuals about backup_tables and Restore_table that rebuild the index but is there any other way to rebuild them. I'm using Mysql 3.23.53a

--=====000_Dragon621152387636_===== Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit Hello, mysql, We have 1 master and salve in my lan. If the master failed,coze the unrecoverable disaster.

HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose. Someone can help me? Thanks

The records in my database are displayed in a form as follows: %> <form action="report-ammend1.42.asp" method="post"name="form"> <table border=1> <% x = 1

Hello. I have MySQL 3.23.41 on a RH-7.2 Linux used as local server. I'm trying to replicate the databases from server (192.168.0.1) to another linux PC (192.168.0.3). Following the manual, i grant to the master a user with file privileges, and edit both my.cnf files. The master starts fine but the slave mysql.log shows up an error: Slave...

HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose. Someone can help me? Thanks

------=_NextPart_000_008D_01C355F5.DA1B8150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have read in past postings that UTF8 is not yet working with MySQL 4.1 = on the Windows build. Can anyone verify this? If it is not yet working, can anyone give an estimate when a build will = be...

--=====000_Dragon621152387636_===== Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit Hello, mysql, We have 1 master and salve in my lan. If the master failed,coze the unrecoverable disaster.

Hi List, My head is not on right today. I have something like this: main_table id name main_type 1 joe type1

hello =09I have a OpenBSD3.3 box ,defautl installed, 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 , and will= come up sometimes but can not some other times. There's error messages appers that lost connection during= query when the client connect to...

HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose. Someone can help me? Thanks

Greetings I have a table with the following table structure - mysql> desc email_table; +---------+---------------+-------------------+------+-----+---------+-------+ | Field | Type | Collation | Null | Key | Default | Extra | +---------+---------------+-------------------+------+-----+---------+-------+ | email |...

The records in my database are displayed in a form as follows: %> <form action="report-ammend1.42.asp" method="post"name="form"> <table border=1> <% x = 1

Greetings I have a table with the following table structure - mysql> desc email_table; +---------+---------------+-------------------+------+-----+---------+-------+ | Field | Type | Collation | Null | Key | Default | Extra | +---------+---------------+-------------------+------+-----+---------+-------+ | email |...

Hi List, My head is not on right today. I have something like this: main_table id name main_type 1 joe type1

hello =09I have a OpenBSD3.3 box ,defautl installed, 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 , and will= come up sometimes but can not some other times. There's error messages appers that lost connection during= query when the client connect to...

Hello List; I am developing a php-mysql application for my term project at school and this is where i seem to not going any further. I need to display alll tables that are holding records, so the user can make detailed selection over these tables.Since this is a student-grade database, there are tables for classes that have not been entered...

Hi all, I am trying to use mysql with innodb. After I set it up as follow. The db start failed. I wonder why it failed to use innodb. Does anyone can tell me? OS: redhat 7.2 with kernel 2.4.20-18.7 mysql version: 3.23.56

Hi, I would like to connect mysql from java, i have downloaded MyODBC but i have a problem. Could you please help please.

Hello List; I am developing a php-mysql application for my term project at school and this is where i seem to not going any further. I need to display alll tables that are holding records, so the user can make detailed selection over these tables.Since this is a student-grade database, there are tables for classes that have not been entered...

When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data/log.0000000001: Permission denied

Hi all, I am trying to use mysql with innodb. After I set it up as follow. The db start failed. I wonder why it failed to use innodb. Does anyone can tell me? OS: redhat 7.2 with kernel 2.4.20-18.7 mysql version: 3.23.56

Hi, I would like to connect mysql from java, i have downloaded MyODBC but i have a problem. Could you please help please.