MySQL Database Forum

Hi I have a varchar field to search. There are 5k records. I'm using: WHERE name LIKE '%outer banks%' It seems to be very slow. I was reading about full text searches. Maybe I could do something like: WHERE MATCH ('name') AGAINST ('outer banks')

I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql> CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no "smart" way of doing this? version ...

Hi List Me again. I'm trying to return from multiple tables, the records that have field "information_sent" between two dates. The tables are all related by means of the id of the entry in the main table, ie.. main id entity_name ...

I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like mysql> CHECK TABLE reports.* which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no "smart" way of doing this? version ...

Hi all, i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ? If so , any clarifications may help. think in advance -- MySQL General Mailing List

Hi all, i want to know if the system parameter somaxconn affect the capabalities of MySQL to maintain more than five thousands of HTTP connections ? If so , any clarifications may help. think in advance -- MySQL General Mailing List

I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: "Cannot connect to localhost port..." my machine is not connected to internet. I also have firewall installed on my machine, but this should not matter. Any suggestions why I may be getting this error.

Hi all, I have a table with the following data: +--------+-----------+----------------------------------+ | lpcval | smiles_id | crhash | +--------+-----------+----------------------------------+ | 0.81 | 996 | 0597b6f84e0feaf9596869284e6e0660 | | 0.86 | 996 | 53a88ef9f72a77eeb47da15969e6fbc0 |...

I have tried to install mysql 4.0.14 and previous version on my machine. After installation when I try to run mysql, i get error: "Cannot connect to localhost port..." my machine is not connected to internet. I also have firewall installed on my machine, but this should not matter. Any suggestions why I may be getting this error.

Hi, 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

Hi all, I have a table with the following data: +--------+-----------+----------------------------------+ | lpcval | smiles_id | crhash | +--------+-----------+----------------------------------+ | 0.81 | 996 | 0597b6f84e0feaf9596869284e6e0660 | | 0.86 | 996 | 53a88ef9f72a77eeb47da15969e6fbc0 |...

Hi, i am really new to mysql so plz dont hit me if i am wrong. Here the problem: i have 2 tables. Voters(IP,Maprated) Maps(Name,Info)

------=_NextPart_000_0013_01C352C0.6B0A6E30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, Is it possible in MySQL to use UPDATE to update fields in one table = with data from another table? For example, the following code seems to be the answer but fails with a syntax error in MySQL:

Hi, 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

Hi, i am really new to mysql so plz dont hit me if i am wrong. Here the problem: i have 2 tables. Voters(IP,Maprated) Maps(Name,Info)

------=_NextPart_000_0013_01C352C0.6B0A6E30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, Is it possible in MySQL to use UPDATE to update fields in one table = with data from another table? For example, the following code seems to be the answer but fails with a syntax error in MySQL:

Hi, 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

Hello, DB novice checking in here with a basic design question. I have a table called 'nms_apps' which stores information about all of our applications which we have developed/maintained for our client. One column which I would like to use is called 'used_by', which would store information about which business sections (Financial...

For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K) to complete a shutdown. The fast shutdown flag is not set (innodb_fast_shutdown=0), so I assume it is doing a purge and merge... but in the meantime, I don't have any access to the server -- clients simply can't connect. This is a real problem, since it renders the...

Hello, DB novice checking in here with a basic design question. I have a table called 'nms_apps' which stores information about all of our applications which we have developed/maintained for our client. One column which I would like to use is called 'used_by', which would store information about which business sections (Financial...

For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K) to complete a shutdown. The fast shutdown flag is not set (innodb_fast_shutdown=0), so I assume it is doing a purge and merge... but in the meantime, I don't have any access to the server -- clients simply can't connect. This is a real problem, since it renders the...

------=_NextPart_000_0011_01C355D2.C79798C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I installed the 4.1 alpha release, which I probably shouldn't have, but = I did because the 4.0 was giving me access denied error (before I found = your mailing list). However my problem got complicated...

------=_NextPart_000_001C_01C355D3.9595F8C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable the configure command for courier-imap is the ff: ../configure --prefix=3D/usr/lib/courier-imap --with-authmysql = --without-pgsql --with-mysql-libs=3D/usr/local/mysql/lib =...

------=_NextPart_000_0011_01C355D2.C79798C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I installed the 4.1 alpha release, which I probably shouldn't have, but = I did because the 4.0 was giving me access denied error (before I found = your mailing list). However my problem got complicated...

------=_NextPart_000_001C_01C355D3.9595F8C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable the configure command for courier-imap is the ff: ../configure --prefix=3D/usr/lib/courier-imap --with-authmysql = --without-pgsql --with-mysql-libs=3D/usr/local/mysql/lib =...