Hi,
I just installed Redhat 7.1 will all the options (full install)
When I try to connect to MySQL I am getting this error
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check
Hi!
There was some confusion in the making of the
4.0.0 binaries. The Intel rpm contains InnoDB-.43
which does not support foreign keys, while the
source distribution and the Intel .tar.gz binary
contains .43b which supports foreign keys. Sorry
for the confusion!
Some things are broken in all
On Tue, Oct 23, 2001 at 08:08:08AM +0200, Michal Zejdl wrote:
Blank shot - have you enough FD?
sql
I really think so...
ulimit -a:
max user processes 32768
open files 32768
And within /etc/my.cnf:
[safe_mysqld]
open-files-limit=32768
set-variable=
On Mon, Oct 22, 2001 at 11:42:23AM -0600, Steve Meyers wrote:
If you use a good 64-bit hash, I doubt you'll run into any
uniqueness problems. MySQL will support that as a 64-bit BIGINT.
You especially should not have any problems if you hash each column,
then do the primary key across the
Placed At : BOM
Durga Prasad@SATYAM
10/23/2001 01:06 PM
Hi all,
Is it possible to have an external file as an attachment in MySQL?
An example would be a .gif, .doc, .ppt, .ram etc.
If there is no way directly have MySQL table to store an
Chris Book writes:
My actual data has represented as , so I need to set it up this way. I
would prefer to work with the files the way they are now rather than
re-export my data a different way, since that machine is inconvenient right
now.
I can export data using the same params, and
I get this error message when trying to log in to remote MySQL database
server...
what does this mean?
how can I solve this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have created a mysql based intranet and it has occurred to me that I
need to find out how to manage the log files but I cannot find them.
I downloaded the binary
mysql-3.23.41-pc-linux-gnu-i686.tar.gz
and installed to /usr/local/mysql
where should I look? Are they turned off by default ???
Hi all,
can someone look at my very untidy code and maybe give me some pointers.
Searching for values by the hour.
etc
for ($i = 0; $i = 23; $i++)
{
$query = select count(num) as mycount from dundeefw where date=$date
and action=1 and time=hour($i);
// Execute query
$result =
Thanks man, I tried that but still no hope..
when I did a ps -ef | grep mysqld there is nothing in my output!
Pleas.. somebody make this thing work.
- Original Message -
From: Pankaj Gautam
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001
On Mon, 2001-10-22 at 23:49, Neil Zanella wrote:
Hello,
I would like to know if it is possible to issue a command from the
mysql command line interface which will read SQL commands contained
in a file and execute them immediately without having to cut and
paste them one gpm buffer size
hi,
I encountered a problem about indexing. I want to add index on timerecord
field in table gw (shown as below) to speed up query relating with time.
However, I use explain command (explain select * from gw where timerecord =
'010902') to analyze the performace. As a result, it seems the
select hour(ts), count(ts) from dundeefw
where date=$date and action=1
group by hour(ts)
Assuming ts is your timestamp column ...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Leon Noble [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 05:45
To: [EMAIL PROTECTED]
Subject:
Description:
Using the following statement on empyt innobase tables crashes the
MySQL-Server:
select MAX(col3) from crashTable where col1 = 1 and col2 = 7;
How-To-Repeat:
CREATE TABLE IF NOT EXISTS crashTable (
col1 SMALLINT UNSIGNED NOT NULL,
Hi!
Thank you for a detailed bug report.
This bug is already fixed in the source release
3.23.43b available from http://www.innodb.com
You can look at latest bug information at
http://www.innodb.com/bugfixes.html
Regards,
Heikki
Description:
Using the following statement on empyt
Hi,
I'm new to MySQL and indeed SQL in general (coming from an MS Access and
Flat Text File background).
I have data in text form at the moment of the following fields:
ID (Auto increment)
ARTIST (Text up to 255 characters long)
DESCRIPTION (Text up to 255 characters long)
PRICE (Decimal up to
[EMAIL PROTECTED] writes:
Description:
The following is the error message:
#scripts/mysql_install_db
Could not load program ./bin/my_print_defaults:
Dependent module libz.a(shr.o) could not be loaded.
Could not load module libz.a(shr.o).
[skip]
Hi!
This is a known deficiency
Dear,
Is the mysql XA compliant ?
Is there a JDBC driver which support the possible XA compliancy of mysql?
Kind regards,
Luc Gevaert
ComCor Belgium
tel: +32 (0)3 309 95 30
GSM(B): +32 (0)479 27 47 20
Fax(B): +32 (0)3 309 05 47
E-mail: [EMAIL PROTECTED]
Thanks Tom,
That has worked an absolute treat.
thank you very much
Leon.
-Original Message-
From: Haapanen, Tom [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 10:54
To: 'Leon Noble'
Cc: [EMAIL PROTECTED]
Subject: RE: Very untidy
select hour(ts), count(ts) from dundeefw
where
Hi!
Try our 3.23.44 binary for Linux as soon as it is out, and let us
know if the problem persists.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_,
OK, I have a tricky SQL syntax problem I would like to share.
For simplicity's sake, I'll use an analogy. I have two tables, of students
and grades, each with a ID column for use in joins, corresponding to a
student's ID.
The student table has an average grade column which shows that
Hi,
SELECT * FROM students,grades WHERE students.ID=grades.ID AND grades.grade
students.average_grade
This doesn't work. It gets me all the occasions where a student has beaten
his average. But I only want students who have never gone below their
average! In other words, I want to select
This might work ... but I don't have a suitable database to test with ...
select * from students,grades
where students.id=grades.id
and min(grades.grade - students.average_grade) 0
group by students.id
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: David Hugh-Jones
Kyle,
Need a bit more info, what version of mysql? Have you granted the other
host(s) permission to use mysql? are you using mysqladmin to stop and start the
daemon?
cheers,
m!
Kyle B wrote:
Hi all,
I am going to try and describe my problem as best as possible. here it goes.
Am
My perl app that loads the tables reached 2gb and bang! It is only halfway
done! I had converted from Oracle which doesn't give a second thought as
long as the tablespace is large enough.
Has anybody turned on raid for the windows version?
Turning this feature on in Unix appears simple, but
By reading the online manual-split.tar, I try to do some examples but one
doesn't work.
(For this time, I didn't configure mysql).
To (re)-product this error:
CREATE TABLE shop (
article INT(4) UNSIGNED ZEROFILL DEFAULT '' NOT NULL,
dealer CHAR(20) DEFAULT '' NOT
Hi Kyle,
I know that various verions of FreeBSD had thread problems from 4.1
and down. Is it possible for you to upgrade to FreeBSD 4.4 or 4.3?
3.0 is very old and has many bugs, (unless you have been patching
it!). After upgrading to 4.4 you can install MySQL from ports in
several different
SELECT id_team,
sum(IF(m.id_visitor = t.id_team,m.visitor_score,
m.home_score)) AS But_pour,
sum(IF(m.id_visitor != t.id_team,m.visitor_score,
m.home_score)) AS But_contre
FROM tab_teams t, tab_matchs m
WHERE
Hi,
I have been bashing my head for a couple of hours now trying to
create an enum field which will hold a true or false (1 or 0)
value, but I always get an error when I try to create the enum
field.
What is the SQL syntax to create such a field in phpMyAdmin?
I tried to use the building
On Sunday 21 October 2001 22:59, Chip wrote:
I just installed mysql-3.23.43, apache-1.3.22, and php-4.0.6 all from
source this evening (on freebsd-4.4-r). When I try to run safe_mysqld I get
this;
mysqld started
Fatal error: Can't change to run as user 'mysql' ; Please check that the
user
Wouter de Jong wrote:
/proc/sys/fs/file-max:
32768
And what about file-nr and others (*-nr)?
sql
--
Ing. Michal ejdl e-mail: [EMAIL PROTECTED]
Sokolovsk uheln, a.s. tel.: +420 168 46-5418
David Hugh-Jones writes:
The student table has an average grade column which shows that student's
average grade last year. The grades table has a column for subject (e.g.
English, Math) and a column for the grade achieved.
Suppose I want to select all my students who have performed very
McGrotty, Charles writes:
I have been bashing my head for a couple of hours now trying to
create an enum field which will hold a true or false (1 or 0)
value, but I always get an error when I try to create the enum
field.
An ENUM can only hold strings, so you're probably missing
the quotes
I stored a sql string in a file and when I launch it, it doesn't perform
because the string is truncated before the end.
Does mysql limit the length of an sql string ?
How do I do to execute my all sql string ?
-
Before
On Tue, 2001-10-23 at 10:52, Ken Guest wrote:
On Mon, 2001-10-22 at 23:49, Neil Zanella wrote:
Hello,
I would like to know if it is possible to issue a command from the
mysql command line interface which will read SQL commands contained
in a file and execute them immediately
M. Alageswaran wrote:
Thanks man, I tried that but still no hope..
when I did a ps -ef | grep mysqld there is nothing in my output!
-ef is for HP-UX (I think). For Linux you want 'ps ax |grep mysqld' note
there is no dash in front of the ax.
b.
kmlau wrote:
I encountered a problem about indexing. I want to add index on timerecord
field in table gw (shown as below) to speed up query relating with time.
However, I use explain command (explain select * from gw where timerecord =
'010902') to analyze the performace. As a result,
[EMAIL PROTECTED] wrote:
Hi all,
Is it possible to have an external file as an attachment in MySQL?
An example would be a .gif, .doc, .ppt, .ram etc.
If there is no way directly have MySQL table to store an attachment, is there
any work around?
Any guidance will be appreciated.
To store
Hi !!!
And coming to your problem, I belive it got fixed in the latest release.
Regards, venu
-Original Message-
From: Mark Arnold [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 6:20 PM
To: [EMAIL PROTECTED]
Subject: Experience with mm.mysql-2.0.x ?
Hi,
did
Hi Tom
I'm raring to try this out but whenever I try a GROUP BY on a select with a
join, I seem to get
ERROR : Invalid use of group function
E.g.
select * from words,pairs where words.word=pairs.word1 and pairs.word2=15451
and min(pairs.count/words.count) 0.8 group by word2;
ERROR
Martyn Wendon wrote:
Hi,
I'm new to MySQL and indeed SQL in general (coming from an MS Access and
Flat Text File background).
I have data in text form at the moment of the following fields:
ID (Auto increment)
ARTIST (Text up to 255 characters long)
DESCRIPTION (Text up to 255
TOMASSONI Dominique wrote:
I stored a sql string in a file and when I launch it, it doesn't perform
because the string is truncated before the end.
Does mysql limit the length of an sql string ?
Not that I have ever run into. But ODBC does.
What command are you running? E.g. on linux
Alas, my version won't let me use min() in a where clause - it only seems to
let me use it in the select clause. Is there a workaround?
mysql select * from words where min(count) 50 group by count;
ERROR : Invalid use of group function
d
On Tuesday 23 October 2001 8:17 am, Haapanen,
Rafal Jank wrote:
Hi!
Is there a possibility to rotate mysql error log without stoping the server?
I was waiting for someone else to respond. But some possibilities are 1: use
the apache program 'rotatelog'. Not sure how you would do this.
In Linux you can rename the file while the server
Put the min clause in a having statement
ex.
select * from words group by count having min(count) 50;
-Original Message-
From: David Hugh-Jones [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 4:25 PM
To: Haapanen, Tom
Cc: [EMAIL PROTECTED]
Subject: RE: selecting rows where
Hello and a big thank's to all mysql team for your wonderfull
product.
I use a mysql table to store my apache's logs.
The table is like
CREATE TABLE IF NOT EXISTS log (
ip char(12) not null,
date datetime not null,
...
PRIMARY KEY ( date, ip )
);
Some times, people double click on a link
Description:
*** merge.rejectTue Oct 23 11:51:23 2001
--- merge.resultWed Oct 3 12:21:17 2001
*** a b
*** 9,12
! 1 Testing
! 1 Testing
! 1 Testing
! 1 Testing
--- 9,12
! 3 t1
! 3 t2
! 2 table
! 2 table
***
Is the mysql XA compliant ?
No.
Is there a JDBC driver which support the possible XA compliancy of mysql?
No. Some application servers (Jboss for example) provide wrappers for
non-XA-compliant databases (which there are many), but you can end up with
corrupted databases, as the full
Hi all,
I wonder if anyone has experience with this.
my servers are both setup with mysql. Im following the HOWTO on the MySQL
website to set them up to replicate the data. Ive completed every step but
I get this error in the logs on the slave system:
Slave thread: error connecting to
Neil,
I did a quick test of your data and this is what I got to work.
SELECT item.item, titles.title FROM item LEFT JOIN titles ON
item.title_id = titles.title_id;
The left join selects all the items from the 'left' table even if there
are no matching entries in the 'right' table. A bit of a
Hi List members,
I'm new to MySql and am working through Paul DuBois' book: MySql. In going
through his tutorials, I've downloaded his distribution that contains
pre-written mysql commands and data to make the manual entry easier. The
problem is that I can't seem to run any of his scripts. He
I understand that you only have one table. The query I gave you joins the same table
against itself, and aliases it to a, b, and c. The only question was whether the
depth is always the same.
Steve Meyers
Hi
I have one table and the depth is not always the same.
Anyway thanks :)
On Tue, Oct 23, 2001 at 05:05:04PM +0100, Stuart Otway wrote:
Hi all,
I wonder if anyone has experience with this.
my servers are both setup with mysql. Im following the HOWTO on the MySQL
website to set them up to replicate the data. Ive completed every step but
I get this error in
At a previous job, we tested a 32-bit hash function by running it
against hundreds of thousands of unique URL's stored in our
database. We found one collision. A 64-bit hash is billions of
times better (4 billion, to be exact).
Good to know. I wonder how many collisions I'd find if
At a previous job, we tested a 32-bit hash function by running it
against hundreds of thousands of unique URL's stored in our
database. We found one collision. A 64-bit hash is billions of
times better (4 billion, to be exact).
Good to know. I wonder how many collisions I'd find if
Steve Meyers wrote:
At a previous job, we tested a 32-bit hash function by running it
against hundreds of thousands of unique URL's stored in our
database. We found one collision. A 64-bit hash is billions of
times better (4 billion, to be exact).
Good to know. I wonder how
I am not understanding why having a hash and the full url in the
database would not take care of the collisions. Even if you had
10 collisions for a 16 bit hash (say), if your query was:
SELECT ... WHERE hash=thehashvalue AND url='theurl' you would get
very fast lookups on the hash and
Hi!
I changed now ha_innobase.h so that InnoDB allows
keys up to 7000 bytes in length. The change will be
in MySQL-3.23.44 and 4.0.1.
Regards,
Heikki
http://www.innodb.com
Steve Meyers wrote:
At a previous job, we tested a 32-bit hash function by running it
against hundreds of
At 08:31 22/10/2001 -0700, [EMAIL PROTECTED] wrote:
Hi!
So why won't WinMySQLAdmin work for a different user? The user in the
my.ini file does exist in mysql.user with Host='%' and %_priv ='Y'. The
error file contains 'MySql: ready for connections' but none of the other
tabbed pages have any
Hi,
Using
$ gcc -v
Reading specs from /usr/local/lib/gcc-lib/alphaev56-dec-osf4.0d/3.0/specs
Configured with: /misc/gcc-3.0/configure
Thread model: single
gcc version 3.0
on
$ uname -a
OSF1 unix V4.0 878 alpha
I get this:
Making all in mysys
make[2]: Entering directory
On 23-Oct-2001 Steve Meyers wrote:
At a previous job, we tested a 32-bit hash function by running it
against hundreds of thousands of unique URL's stored in our
database. We found one collision. A 64-bit hash is billions of
times better (4 billion, to be exact).
Good to know. I
Description:
while doing mysql-test-run --local it fails on the binary test with
the following message:
/usr/compile/mysql-3.23.43/client/.libs/lt-mysqltest: At line 34: Result length
mismatch
---
*** r/binary.result Wed
I've recently setup MyODBC and MS Access to use a ODBC profile that
is global to everyone. What I did was make a new user in MySQL and then
create a MyODBC User DSN. I made the links to MySQL in Access using this
profile. The problem I'm having is this, when you initially go into MS
Hi,
I know this problem has already been reported (but I don't remember the
solution :( ) :
I encounter the following error after installing gcc 3.0.1 and trying to
compile MySQL 4.0 :
mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x14): undefined reference to
`__cxa_pure_virtual'
Hi,
I think that will solve the problem, I created a tablespace without any
problems and now I will start porting the data over.
Thanks
Butch
-Original Message-
From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 10:41 AM
To: [EMAIL PROTECTED];
Dear list members,
We are running Mysql 3.23 on Redhat Linux 7.1.
We have an emergency. This is the first time we have ever had a problem. Our
production database suddenly crashed. I have tried to repair the tables with
myisamchk commands, -r, -o, etc and nothing works.
Here is the
David Potter [EMAIL PROTECTED] writes:
We are running Mysql 3.23 on Redhat Linux 7.1.
Which version on MySQL, and where did you get it?
--
Trond Eivind Glomsrød
Red Hat, Inc.
-
Before posting, please check:
David Potter wrote:
Dear list members,
We are running Mysql 3.23 on Redhat Linux 7.1.
We have an emergency. This is the first time we have ever had a problem. Our
production database suddenly crashed. I have tried to repair the tables with
myisamchk commands, -r, -o, etc and nothing
Hi!
On Oct 23, David Potter wrote:
Dear list members,
We are running Mysql 3.23 on Redhat Linux 7.1.
We have an emergency. This is the first time we have ever had a
problem. Our production database suddenly crashed. I have tried to
repair the tables with myisamchk commands, -r, -o,
Sergei Golubchik [EMAIL PROTECTED] writes:
Hi!
On Oct 23, David Potter wrote:
Dear list members,
We are running Mysql 3.23 on Redhat Linux 7.1.
We have an emergency. This is the first time we have ever had a
problem. Our production database suddenly crashed. I have tried to
Chances are, you need to type
myisamchk -o *.MYI
as you only want to run myisamchk on the Index file, which is typically the
.MYI file.
you probably typed myisamchk -o *
which is wrong.
Try it out.
Garrett
On Tuesday 23 October 2001 05:10 pm, you wrote:
Hi!
On Oct 23, David Potter
On Tuesday 23 October 2001 13:50, David Potter wrote:
Dear list members,
We are running Mysql 3.23 on Redhat Linux 7.1.
We have an emergency. This is the first time we have ever had a problem.
Our production database suddenly crashed. I have tried to repair the
tables with myisamchk
On Tuesday 23 October 2001 14:15, Garrett Marone wrote:
Chances are, you need to type
myisamchk -o *.MYI
as you only want to run myisamchk on the Index file, which is typically the
.MYI file.
you probably typed myisamchk -o *
which is wrong.
Heh. I think you're right. It does look like
I'm trying out MySQL-Front on a Win2k machine and it is having a problem
opening some of my InnoDb tables.
I can open any of my InnoDb tables if I explicitly specify the database
name in the Connection window. But if I leave the database name blank I'll
see the database tree in the pane on
I'm doing just general feasibility studying of embedding MySQL in a
networking product, and I have a question that I haven't been able to
find the answer to after a fair bit of looking
- is there some way to insert data that is already in INT UNSIGNED
form directly into a table, without
Hi
I posted the question below a little over a week ago and I have not had any
responses. Can anyone let me know if my email lacked detail and that's why
I've had no responses or whether this is a bug? I can create a complete
script that creates the tables, populates them and runs the
Hello,
After logging into mysql and selecting a database, I type select * from
song into outfile 'data123.txt'; but receive the following error message:
ERROR 1045: Access denied for user: 'avelino@localhost' (Using password: YES)
mysql
I made sure the user has full permissions to the
At 6:59 PM -0700 10/23/01, Bob Purvy wrote:
I'm doing just general feasibility studying of embedding MySQL in a
networking product, and I have a question that I haven't been able
to find the answer to after a fair bit of looking
- is there some way to insert data that is already in INT
-Original Message-
From: kmlau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 9:42 AM
To: 'Bill Adams'
Subject: RE: pls help for index problem
Thanks yr promptly reply !!
It seems no any change(improvement) by running explain again after erase
quotes. I also ran the
At 10:43 PM -0400 10/23/01, Avelino F wrote:
Hello,
After logging into mysql and selecting a database, I type select *
from song into outfile 'data123.txt'; but receive the following
error message:
ERROR 1045: Access denied for user: 'avelino@localhost' (Using password: YES)
mysql
I made
Hi
-Original Message-
From: Adam Douglas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 12:55 PM
To: 'David Turner'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail);
'[EMAIL PROTECTED]'
Subject: MySQL with MyODBC Access
I've recently setup MyODBC
Hi. I am trying to have type in a story into a form textfield and
submit it using PHP into blob formatted field mysql database.
When I submit, all the returns are removed and all the text runs
together like on ebig paragraph. Is there a way to have mysql or PHP
recognize the returns and empty
Hi,
I have this mysql statement:
select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs
where counts 10 and datesent between '2001-09-24' and '2001-10-24' and
(returncode 0 and returncode 10) group by hpnumber order by counts DESC
and i Get this following error:
Unknown column
Hello,
I managed to set the file permission and managed to send the output to the
mysql database directory used. Do you know if there is a way to make mysql
write to a remote directory? Is there a global or local configuration that
can be specified where mysql will write to?
Regards,
Avelino
On Tue, Oct 23, 2001 at 01:43:32PM +0300, Heikki Tuuri wrote:
Hi!
Thank you for a detailed bug report. This bug is already fixed in
the source release 3.23.43b available from http://www.innodb.com
Is there now a test case for it in the MySQL test suite, too?
Jeremy
--
Jeremy D. Zawodny,
On Wed, Oct 24, 2001 at 10:54:38AM +0800, Z Julian wrote:
I want to use journaled file system on my computer. Can you give me
some advice? Furthermore, could journeled file system improve the
performance of mysql? If yes, which journeled file system is better
for mysql? Thank you~~ :)
Are you sure it doesn't have the line feeds in the database? Neither MySQL nor PHP
will strip them out, unless you do some fancy work to make it do that. I would guess
that your real problem is that when you display it in your HTML, it shows up without
returns. This is standard HTML
87 matches
Mail list logo