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
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
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
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
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
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]
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
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_
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
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,
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
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'
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
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
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
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-
-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
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
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
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
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
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
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.
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:
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
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 ;-)
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:
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'
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
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
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
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
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
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
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
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
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),
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
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
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
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
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
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
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
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
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),
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
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
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
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
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
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
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
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
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
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:
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;
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: 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
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
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
61 matches
Mail list logo