Re: Need older version of mysql (current version seeminly corrupts FTS tables)

2005-02-18 Thread Gleb Paharenko
Hello. Where can I download it See: http://downloads.mysql.com/archives.php We now get table corruptions constantly (it only takes a minute before several tables get marked as crashed). I'd like to revert to the 4.0.18 Do you use official binaries? Sometimes after upgrade

Re: Weird @ in column name

2005-02-18 Thread Gleb Paharenko
Hello. Do you use mysql client program from the old release? Use mysql --version to check the version. Sehn, Timothy [EMAIL PROTECTED] wrote: I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the = strangest error: mysql use devmail Reading table information for

UTF-8 + collations

2005-02-18 Thread Andreas Steichardt
Hi! We are trying to migrate our applications to UTF-8 and so we started testing the new features of MySQL 4.1 (still using 4.0 currently). But we are facing some problems now. In our applications it could be theoretically the case that there is arabic, hebrew, japanese and korean content in

compare dates

2005-02-18 Thread Reinhart Viane
Hey list I need a query like this: Select * from activities where act_date = today or any day in the future I have made it work like this: Sselect * from activities where UNIX_TIMESTAMP() UNIX_TIMESTAMP(act_date) Problem is with this thing I have to manually add 23:59:59 to each

Re: compare dates

2005-02-18 Thread Gabriel PREDA
Let me assure you that DATETIME is the worst choice ever... because it need 8 bytes per record... TIMESTAMP uses only 4 DATE uses only 3, so does TIME YEAR is the smallest... 1 byte. You can do: SELECT * FROM activities WHERE act_date = NOW() But for optimization... you should not compute in

RE: compare dates

2005-02-18 Thread Reinhart Viane
Thank you very much, that indeed did the trick. Concerning datetime type: Eg. in a forum if someone posts a message the date and the time is stored and shown of that message. I suppose they use timestamp in that case? -Oorspronkelijk bericht- Van: Gabriel PREDA [mailto:[EMAIL PROTECTED]

Url http://highperformancemysql.com/

2005-02-18 Thread Anton Kornexl
Hello, the URL http://highperformancemysql.com/ is mentioned in the online available chapter 7 of the book High Performance Mysql There should be tools on this website, but i see only a message from Infektion Group. What happened ? -- Anton Kornexl -- MySQL General Mailing List For list

Re: compare dates

2005-02-18 Thread Roger Baklund
Gabriel PREDA wrote: Let me assure you that DATETIME is the worst choice ever... because it need 8 bytes per record... TIMESTAMP uses only 4 ...but TIMESTAMP has a special behaviour which may not be wanted in all cases: the first TIMESTAMP column of a table is updated automatically when _any_

select case consider the first field only, MySQL 4.18

2005-02-18 Thread Jan Bartholdy
Dear List, I have a select case question SELECT CASE WHEN `Species_1_l` 0 THEN 'intern' when 'Species_3_e' 0 THEN 'extern' ELSE '' END AS `species_1_l` from species where statsample=1820; The result is only -- species_1_l

Re: select case consider the first field only, MySQL 4.18

2005-02-18 Thread Roger Baklund
Jan Bartholdy wrote: Dear List, I have a select case question SELECT CASE WHEN `Species_1_l` 0 THEN 'intern' when 'Species_3_e' 0 'Species_3_e' is surrounded by single quotes, not backticks... thus it is treated as a string, numeric value is 0, which is never 0. BTW,

Re: compare dates

2005-02-18 Thread Gabriel PREDA
Reinhart's request was to keep it's DATE type in place instead of changing it to DATETIME... that's why I emphasized that DATE is better and he should keep it that way ! (Comming back to it if I think... a DATE column beside a TIME column would use 6 bytes... not 8 bytes as DATETIME... at 100

WG: select case consider the first field only, MySQL 4.0.18

2005-02-18 Thread Jan Bartholdy
Thanks Roger, but it does not work: SELECT CASE when Species_1_e 0 THEN 'extern' when Species_3_e 0 THEN 'intern' ELSE '' END AS `species_1_l` from species where statsample=1820; --Gives at a result 'extern'

How remove the closed connections

2005-02-18 Thread AESYS S.p.A. [Enzo Arlati]
I get an application with several thread , with each thread using it's own connection. What I mean is that the thread create a connection at the beginning and close and detroy it before it close. Under some circustances some of these threads close itself and reopen after few minutes ( for example

Re: select case consider the first field only, MySQL 4.0.18

2005-02-18 Thread Roger Baklund
Jan Bartholdy wrote: Thanks Roger, but it does not work: SELECT CASE when Species_1_e 0 THEN 'extern' when Species_3_e 0 THEN 'intern' ELSE '' END AS `species_1_l` from species where statsample=1820; --Gives at a result 'extern' What is the value of

log-warnings

2005-02-18 Thread Marcus Bointon
I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and I'm getting some infrequent warnings when importing data dumps created with mysqldump, but I can't seem to find out what the warnings are. I'm typically importing around 100,000 records at a time, so using 'SHOW WARNINGS' manually is

RE: Query problem

2005-02-18 Thread Gordon
Did you want WHERE Name LIKE 'sandy' OR (main_data.Display_In_Search = 1 AND main_data.Expiry_Date = CurDate()) OR WHERE main_data.Expiry_Date = CurDate() AND (Name LIKE 'sandy' OR main_data.Display_In_Search = 1 ) -Original Message-

RE: log-warnings

2005-02-18 Thread Thomas Sundberg
-Original Message- From: Marcus Bointon [mailto:[EMAIL PROTECTED] Sent: den 18 februari 2005 14:47 To: mysql@lists.mysql.com Subject: log-warnings I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and I'm getting some infrequent warnings when importing data dumps created

Re: Header files data types

2005-02-18 Thread Mohsen Pahlevanzadeh
Dear Michael, I have found mysql.h.Yes,It is in /usr/include/mysql My code is : CMysql::CMysql() : CCore() { MySQL *x; mysql_connect(x,127.0.0.1,root,); }//end of CMysql constructor My Makefile is : INCS=-I'/usr/include/mysql' #LIBS=-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm

Re: compare dates

2005-02-18 Thread Roger Baklund
Reinhart Viane wrote: Concerning datetime type: Eg. in a forum if someone posts a message the date and the time is stored and shown of that message. I suppose they use timestamp in that case? They could, but because of the 'magic' behaviour of TIMESTAMP a DATETIME is often used. To conserve

offline solutions for database?

2005-02-18 Thread Jordan Morgan
Hi, If a client wants an offline solution for a mysql database online, what do you think? Is that even possible? The mysql database right now is with the hosting company(with a private server hosting plan) somewhere in US while the client's physical office is in Africa. What kind of options do

RE: How to specify autoincrement primary key value

2005-02-18 Thread Denis Gerasimov
Hello, Sorry for my insistency but I would like to resume this discussion again. A few days ago Gleb answered the question I asked before about 0 PK values (look for Re: auto_increment=0 topic in the archives). I had a look at http://dev.mysql.com/doc/mysql/en/server-sql-mode.html and found

InnoDB: Problem with innobackup

2005-02-18 Thread James Green
Hi, On running the hot backup tool we receive: ibbackup: Re-reading page at offset 0 366297088 in /var/lib/mysql/data/ibdata1 ibbackup: Re-reading page at offset 0 366297088 in /var/lib/mysql/data/ibdata1 050218 15:18:01 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex

Re: Url http://highperformancemysql.com/

2005-02-18 Thread Jason Martin
On Fri, Feb 18, 2005 at 10:06:38AM +0100, Anton Kornexl wrote: There should be tools on this website, but i see only a message from Infektion Group. What happened ? Looks like the website got hacked. -Jason Martin -- Useless Invention: Motorcycle seat-belts. This message is PGP/MIME signed.

offtopic: Problem initialize MySQL DataSource for WebSphere App. Server 6

2005-02-18 Thread juleni
Hello, I have problem to configure MySQL datasource for WebSphere Application Server 6 (WAS6) from admin console. 1.) I have configured new JDBC Provider for MySQL (4.0.20a) as following: Name: MySQL JDBC Provider Class path:

MySQL constraint question

2005-02-18 Thread Gerald Taylor
I have a database thats full of ingredients that are placed in various categories. and then there are mixtures that are allowed to be labelled with a certain grade based on the quality and composition of the ingredients it is comprised from. But the formulas are not always the same, as long as

Physical limitations ... ?

2005-02-18 Thread Raph
Hi all, My 1st post in this ng ! Does anyone know what is the physical limitation of a mysql server ? I have several db on my server (freebsd,p4,mysql 4.0.22), one of them with many tables (2394), and I'm afraid to reach this pysical limit one day Please tell me that I'm far from it ;-)

RE: Physical limitations ... ?

2005-02-18 Thread John Trammell
Depends a lot on your server setup and table engine choices. See http://dev.mysql.com/doc/mysql/en/table-size.html etc. -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Raph Sent: Friday, February 18, 2005 10:08 AM To: mysql@lists.mysql.com Subject:

ERROR 25 (HY000): Can't create symlink

2005-02-18 Thread Mark Uhrmacher
Hi all, I've been getting a strange error when attempting to add an index to a set tables that make up a merge table. Here is a transcript of the session: mysql alter table he_access_offline_3 add index status (status); ERROR 25 (HY000): Can't create symlink './Logs/#sql-156e_48d8.MYI'

Re: How remove the closed connections

2005-02-18 Thread Philippe Poelvoorde
AESYS S.p.A. [Enzo Arlati] wrote: I get an application with several thread , with each thread using it's own connection. What I mean is that the thread create a connection at the beginning and close and detroy it before it close. Under some circustances some of these threads close itself and

select columns in full text index

2005-02-18 Thread brian ally
I have several tables which have some columns indexed for full text searching. table 1: FULLTEXT(foo,bar) table 2 FULLTEXT(pip,pop,pup) table 2: FULLTEXT(hip,hop) I'd like to be able to query the db to find which columns are indexed depending on the table to be searched so i can then create my

backing up Databases in Mysql

2005-02-18 Thread Nestor Florez
TO back up the databases in Mysql, isn't there a way where you can just copy somefiles to another directory and in essence you have a backup? I thought I read this somewhere No I can do a dump, but I was wondering if I can just copy some lies or a directory. Thanks, Néstor Alberto Flórez

Re: select columns in full text index

2005-02-18 Thread Peter Brawley
Brian, I'd like to be able to query the db to find which columns are indexed depending on the table to be searched so i can then create my MATCH(). I'm having a heck of a time googling for this. Until MySQL implements a proper data dict, you'll have to parse the output from SHOW INDEX, where

Re: backing up Databases in Mysql

2005-02-18 Thread Jeff Smelser
On Friday 18 February 2005 11:28 am, Nestor Florez wrote: TO back up the databases in Mysql, isn't there a way where you can just copy somefiles to another directory and in essence you have a backup? I thought I read this somewhere mysqlhotcopy does this for myisam tables, there is a hot

Can't get table lock (4.0.23 and InnoDB)

2005-02-18 Thread Nick Arnett
We have something I can't figure out happening on one of our servers. It's running 4.0.23 on OSX. One of the InnoDB tables is locked even though we can't see any process that is even active that could have locked it. SHOW OPEN TABLES doesn't show it as in use or locked. We've tried all sorts

Re: backing up Databases in Mysql

2005-02-18 Thread Peter Brawley
Nestor, 1. LOCK TABLES; FLUSH TABLES; (allow reads, stall writes) 2. Copy the db dir 3. UNLOCK TABLES; 4. cd datadir mv mysql.log mysql.old mysqladmin flush-logs PB Nestor Florez wrote: TO back up the databases in Mysql, isn't there a way where you can just copy somefiles to another

Re: Url http://highperformancemysql.com/

2005-02-18 Thread John McCaskey
On Fri, 2005-02-18 at 08:08 -0800, Jason Martin wrote: On Fri, Feb 18, 2005 at 10:06:38AM +0100, Anton Kornexl wrote: There should be tools on this website, but i see only a message from Infektion Group. What happened ? Looks like the website got hacked. I guess they should have

Re: InnoDB: Problem with innobackup

2005-02-18 Thread David Griffiths
James, We've had this issue twice (every 4 months) - running on 4.0.20 - due to an old kernel (we just upgraded the kernel after the last issue). Do you have a replicated (slave) database? We shut down the master and then the slave (a few minutes after the master to let all changes propigate),

Lots of searches

2005-02-18 Thread gunmuse
We want to be able to search through 1 million words looking for matches and a count of how many times they have been searched. Example. Words like: guns shotguns longguns long guns shot guns So I want to search all million words for the use of the word 'gun' Then it would return me

LIMIT clause as Stored Procedure Parameter

2005-02-18 Thread Scott Klarenbach
I can't seem to pass in the LIMIT clause variables into a stored procedure i.e. Select * from table limit param1, param2; I get a syntax error compiling the procedure, but when I replace param1 and param2 with hard coded ints, ie, 10, 10, it compiles and works fine. Is this functionality not

Re: LIMIT clause as Stored Procedure Parameter

2005-02-18 Thread Paul DuBois
At 11:15 -0800 2/18/05, Scott Klarenbach wrote: I can't seem to pass in the LIMIT clause variables into a stored procedure http://dev.mysql.com/doc/mysql/en/select.html says: The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two

aggregate count and group by

2005-02-18 Thread Jim Grill
Hi, I need some SQL guru help on this one. I'm trying to re factor an existing application where a number of clicks grouped by keyword for two different time periods are needed. For example, a user picks a date range and the application selects a count for how many times a keyword appears in a

Re: Lots of searches

2005-02-18 Thread Brent Baisley
There's nothing you can do except get really fast hard drives. Since you are searching for random parts of words you can't use an index. So you're stuck with doing a full table scan. Your entire table probably won't fit in memory, so you will be reading from disk. Thus, fast disk drives in a

Re: Url http://highperformancemysql.com/

2005-02-18 Thread David Logan
John McCaskey wrote: On Fri, 2005-02-18 at 08:08 -0800, Jason Martin wrote: On Fri, Feb 18, 2005 at 10:06:38AM +0100, Anton Kornexl wrote: There should be tools on this website, but i see only a message from Infektion Group. What happened ? Looks like the website got hacked. I

Re: ERROR 25 (HY000): Can't create symlink

2005-02-18 Thread Ady Wicaksono
Hi Mark, There's perror to check what happen, so when you have Error 17 you check from your bash shell like this # perror 17 Error code 17: File exists Gotcha ! The reason is file exists :) Good luck Mark Uhrmacher wrote: Hi all, I've been getting a strange error when attempting to add an

List of tables.

2005-02-18 Thread Mohsen Pahlevanzadeh
Dears,Problem of my Makefile is solved. But i have a new problem: I need to create an array of my DB's tables. I have saw mysql_list_tables() function,But it returns a result of sql. Please help me... Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

auto_increment not working?

2005-02-18 Thread Scott Purcell
Hello, I am trying to get auto_increment to begin at a certain integer. CREATE TABLE USERS ( user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(50), firstname varchar(50), middlename varchar(50), lastname varchar(50), email varchar(100),

Re: auto_increment not working?

2005-02-18 Thread daniel
I am not really experienced on this, but i have noticed that simply truncating an innodb table doesnt reset the autoinc key, u have to redump the table. I cant see what you are trying to do here ALTER TABLE users auto_increment = 590; set it to start @ 590 ? Hello, I am trying to get

Re: auto_increment not working?

2005-02-18 Thread courtot
it doesn't work with innodb table. http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html InnoDB does not support the AUTO_INCREMENT table option for setting the initial sequence value in a CREATE TABLE or ALTER TABLE statement. To set the value with InnoDB, insert a dummy row with a value

RE: Need older version of mysql (current version seeminly corrupts FTS tables)

2005-02-18 Thread Steven Roussey
See: http://downloads.mysql.com/archives.php Thank you. Nice link to have around. Key 3 is the FTS key. The others are a UNIQUE KEY (#1) and a KEY(#2). Do you have the same values for full-text parameters (ft_mit_word_len for example)? Not at first. I had noticed that not long after I sent

Re: ERROR 25 (HY000): Can't create symlink

2005-02-18 Thread Mark Uhrmacher
Hi Andy, I see that. Unfortunately, I have no idea why mysql is trying to create a symlink to a symlink it just created. Does anyone have any idea why mysql would do that? Thanks, Mark Ady Wicaksono wrote: Hi Mark, There's perror to check what happen, so when you have Error 17 you check from

Re: List of tables.

2005-02-18 Thread Peter Brawley
Mohsen, not sure what you mean here, to get a list of tables in a db you have to issue an sql request, which is all mysql_list_tables() does (http://dev.mysql.com/doc/mysql/en/mysql-list-tables.html). PB Mohsen Pahlevanzadeh wrote: Dears,Problem of my Makefile is solved. But i have a new

Re: List of tables.

2005-02-18 Thread Mohsen Pahlevanzadeh
Dear Peter, I need to name of each table,But mysql_list_tanles() creates a sql result. Can i make an array from those names?Each element of that is a name of table. Please guide me. regards Mohsen, not sure what you mean here, to get a list of tables in a db you have to issue an sql

Re: log-warnings

2005-02-18 Thread Marcus Bointon
On 18 Feb 2005, at 14:24, Thomas Sundberg wrote: I would approach this problem by isolating the where the problem occurs. I.e. Remove, comment out, half of you insert queries and see if the problem still exists. If it does, then remove yet another half of the remaining part leaving only 1/4 of

RE: Lots of searches

2005-02-18 Thread gunmuse
The memory deal gave me an idea. A little hotcopy to a Memory table once a day and perform the search from there. Since the search is a nicity for the users and not critical to be 100% accurate or up2date. How do you do a hotcopy with php then? Never even seen it done. Thanks Donny Lairson

Index key on yearweek(date)

2005-02-18 Thread Hany Nagaty
Hi all, I'm a bit new to MySQL, it's my first email to the list. Well, my question is: Can I have a key on a function of the column. I have some table with a date column in it. I wish to have a key on yearweek(datecolumn). I don't want to allow having duplicate weeks in the table. Thanks for

MYSQL_RES ......

2005-02-18 Thread Mohsen Pahlevanzadeh
Dears,mysql_list_tables returns name of tables.(tables of a DB) It returns MYSQL_RES type. I want to split it to an array. I'm newbie in SQL,Please guide me. I'm working C. yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: MYSQL_RES ......

2005-02-18 Thread mel list_php
Hi, I think you can find all the information you are looking for there: http://dev.mysql.com/doc/mysql/en/c.html You have a description of all the functions : http://dev.mysql.com/doc/mysql/en/c-api-functions.html For example: http://dev.mysql.com/doc/mysql/en/mysql-fetch-row.html MYSQL_ROW row;

download mysql 4 in rpm for Redhat 9.0

2005-02-18 Thread sam wun
Hi, I realised that install mysql 4 thru rpm is the best way for a smooth installation. Can anyone please point me to a site where I can download mysql 4 rpm for Redhat9? Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

REPOST: one long lived connection or one connection per query

2005-02-18 Thread Tommy McNeely
(REPOST: I never got my original post, or any answers, so I am reposting, assuming it was lost in the mail) Hi, I apologize in advance, I am sure this question has been asked dozens of times, but my searches came up empty. I am building an IRC based application bot (using libmysql) .. that will

cannot add a foreign key

2005-02-18 Thread Sergei Skarupo
Hello everyone, I'm trying to add some foreign keys to the database... It works fine for one table but not for another. I need to make them both children of a third table. I'm using mysqld-max 4.0.16 on RedHat Linux. This is the statement that I ran: alter table signal_segments add

RE: cannot add a foreign key

2005-02-18 Thread Sergei Skarupo
That's what it was... I was doing this in a test database and forgot that I changed some values manually before. Thanks, Sergei -Original Message- From: Ady Wicaksono [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 10:55 PM To: Sergei Skarupo Subject: Re: cannot add a