According to perror:
perror 9
Error code 9: Bad file number
This is an operating system error code:
http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html
Out of curiosity, have you tried running myisamchk or some CHECK TABLE
commands yet?
You say it usually crashes near the same record? Could you post the
record information and also the query which is being run?
Also, is there any information in your hostname.err file? If mysqld is
bailing (and it appears that it is), it ought to be writing something
useful to the error log.
According to the output of perror:
perror 5
Error code 5: I/O error
Are you having problems with your disk? Maybe syncing or bad sectors or
even something as simple as out of space?
Best of luck,
--V
Mihail Manolov wrote:
Have you seen this before:
mysqldump: Got errno 5 on write
I have
Have you tried perror yet?
[EMAIL PROTECTED] (ping-300) 120 perror 150
MySQL error: 150 = Foreign key constraint is incorrectly formed
Cheers,
--V
Scott Purcell wrote:
Thanks,
I updated my script and all looks good. But now I get an error when tryng to
issue this command.
Any ideas?
Thanks,
To the best of my knowledge MySQL does not have a way to do this on the
fly such that a field value is contigent upon the values of other fields
in the table.
Does it have to be stored in the database at all? Seems to me that
calculated values often are best handled at query time rather than
Ever since we upgraded to 4.1.7, we've been seeing a lot of errors
similiar to this one:
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT)
and (latin1_swedish_ci,COERCIBLE) for operation 'locate'
The query which generated this particular error is this:
SELECT COUNT(*)
|
| collation_server | latin1_swedish_ci |
+--+---+
3 rows in set (0.04 sec)
and if are different set the collation in your my.cnf file.
Santino
At 8:59 -0800 30-11-2004, V. M. Brasseur wrote:
Ever since we upgraded to 4.1.7, we've been seeing a lot of errors
similiar
I provided the list below for our programmers, who also are dealing with
a switch from 3.23 to 4.1. Perhaps it would be of some help for you.
Cheers,
--V
-
We've already hit a couple of API-related problems with the new version
of MySQL. To try to make things a little easier, and
We're trying to get 4.1.7 to play nicely with our code, but something
isn't cooperating.
First of all, the MySQL installation: Version 4.1.7, compiled from
source using GCC 3.3. The source compile is required because we need a
lot of default settings to use our own paths. This is the
a recent gnu configure.
This link the gcc lib with your program.
I don't know what you are trying to link but here is a php reference.
http://bugs.php.net/bug.php?id=16826edit=1
- Original Message - From: V. M. Brasseur [EMAIL PROTECTED]
To: MySQL Listserv [EMAIL PROTECTED]
Sent: Wednesday
libmysqlclient.la
Neither seems like fun to me. Anyone have any other ideas/pointers?
--V
V. M. Brasseur wrote:
Unfortunately, the --disable-shared is intentional. For various
reasons, our programs use static libraries whenever possible rather than
dynamically linking.
Do you think the LDFLAGS
This must be a bug that was fixed in the 4.1 version. I see the same
thing as Tom, using both 3.23.49 and 4.0.20...
Oh, wait. The ever-helpful manual comes through again:
From the manual documentation on ROUND():
Note that the behavior of ROUND() when the argument is halfway between
two
If you make that column a TIMESTAMP data type and leave the default as
NULL, it will automatically use the current date/time if no value is
entered.
Please note, this will only work this way for the first TIMESTAMP column
in the table.
Also, if ever you update a row containing TIMESTAMP
I am passing on this question from a coworker:
Hello -- This has been posted on the forums.mysql.com for a week with no
replies.
We have been using Connector J 3.0.6 for more than a year at hundreds of
customer sites and on our in house servers.
When I updated the jar to 3.0.15-ga we can still
Why don't you use the mysqldump program to dump only those tables you
want and not the entire database?
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Cheers,
--V
Buchibabu wrote:
Hi,
Please let me know how to extract few tables from a dump file, which is taken with
mysqldump. I know it
to know is
there any mysql utility to extract only specified table from entire dump
Thanks
-Original Message-
From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
Sent: Friday, October 08, 2004 11:41 PM
To: Buchibabu
Cc: [EMAIL PROTECTED]
Subject: Re: How to extract Particular Tables from a Dump file
*I* understand that Unicode utf8 support does not happen until version
4.1 (I can read the manual), but there are some in the office who are
skeptical and somehow believe that there is support for it in earlier
versions (as early as 3.23, according to them).
To set all of our minds at ease,
used the
collation/sorting of MySQL against the text fields.
-Original Message-
From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 1:57 PM
To: [EMAIL PROTECTED]
Subject: UTF8 pre-4.1?
*I* understand that Unicode utf8 support does not happen until version
4.1
OpenSSH != OpenSSL. Just because you have one installed doesn't mean
that the other is. Apparently the MySQL compilation using OpenSSL
requires OpenSSH for some reason. You might want to try installing it
and giving the compile another whirl:
http://www.openssh.com/
Also, the exact output
%22btnG=Search
Cheers,
--V
Thank you for your help!
--- V. M. Brasseur [EMAIL PROTECTED] wrote:
OpenSSH != OpenSSL. Just because you have one
installed doesn't mean
that the other is. Apparently the MySQL compilation
using OpenSSL
requires OpenSSH for some reason. You might want to
try
The manual knows all:
http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html
Cheers,
--V
Monet wrote:
I was working on a table, doing some simple update on
table, query is like:
Update temp
SET Q1 = 14,
REVIEWCOMMENTS = CASE WHEN REVIEWCOMMENTS='WHO2'
THEN ''
WHEN
Your index files appear to have disappeared during your archive. You
can rebuild them though. Have a look at the Table Maintenance and
Crash Recovery section of the manual:
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
Pay particular attention to the REPAIR TABLE syntax. That will
Here is the manual. I suggest you try a search for LIMIT in the
context of a SELECT.
http://dev.mysql.com/doc/mysql/en/index.html
However what it sounds like you really ought to do is give a walk
through the tutorial.
http://dev.mysql.com/doc/mysql/en/Tutorial.html
If, after exploring these
USAGE is a synonym for no privileges. Yes, it's kind of a confusing
term which implies this user can use the system when in fact the
situation is exactly the opposite.
http://dev.mysql.com/doc/mysql/en/User_resources.html
Cheers,
--V
Mark C. Stafford wrote:
Should I care that USAGE still shows
Numeric types are simply that: numbers. They cannot be arrays.
http://dev.mysql.com/doc/mysql/en/Numeric_types.html
Incidentally, why would you need this? Maybe the group can come up with
a viable alternative for you.
Cheers,
--V
Raghudev Ramaiah wrote:
hi
i have used column types such as
Are you using the mysql client to connect? If so, you can use the -h
and -D flags:
mysql -h hostname [-u username -p -P port] -D databasename
The -D flag isn't even necessary. The command above is equivalent to
this one:
mysql -h hostname [-u username -p -P port] databasename
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server). Every
once in a while we wake up to find the too many connections error
coming up. There really aren't too many connections (we
Perhaps a casting function would help you:
http://dev.mysql.com/doc/mysql/en/Cast_Functions.html
If case-sensitivity isn't an issue, you may want to consider converting
from char(8) binary to just char(8).
Cheers,
--V
walt wrote:
We've run into a problem where binary char column types crash our
Stored procedures are in the works for MySQL 5.0:
http://dev.mysql.com/doc/mysql/en/TODO_MySQL_5.0.html
The manual is your friend.
Cheers,
--V
Jacob, Raymond A Jr wrote:
Firstly,
I do appologize for my ignorance in advance. I read the message regarding PRODUCT() and
thought to myself:A perl
Have you checked the Optimization section of the manual yet?
http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html
It's probably the best place to start.
Cheers,
--V
[EMAIL PROTECTED] wrote:
I'm running into a problem with some queries running on a dedicated mysql server (2.0
GHz, 2GB RAM).
Could you send the output of an EXPLAIN for your query?
--V
[EMAIL PROTECTED] wrote:
Have you checked the Optimization section of the manual yet?
http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html
Oh yes, as I've attempted to configure the my.cnf file for best performance. The query is
How about...
SELECT foo FROM bar WHERE LCASE(this) = that;
Although there are always other ways to do it, of course.
Cheers,
--V
Schalk Neethling wrote:
If I search a field for 'doone' and one of the fields contains 'Lorna
Doone' what is the best comparator to use as LIKE is skipping this one
You could also have done this:
TRUNCATE TABLE usarios;
That will drop the table completely and then recreate it anew (and
empty). It will give you a fresh start.
--V
Victor Pendleton wrote:
Try
alter table usuarios auto_increment = 1;
-Original Message-
From: Yusdaniel Rodriguez
Because he's a good sport and really wants to support the MySQL
development effort?
Either that or he hadn't heard of the GPL'd option, but I prefer to
believe the former. :-)
Cheers,
--V
Daved Daly wrote:
all I want to do is host some web applications locally for our internal use.
Why,
MySQL provides a number of functions for handling dates and times:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Cheers,
--V
Stuart Felenstein wrote:
I think this can be done, but tried a few times with
no success. I want a column in a table that sets a
timestamp.
Instead of
You'll probably want to have a look at section 5.10 in the manual:
http://dev.mysql.com/doc/mysql/en/Multiple_servers.html
Also, the mysqld_multi documentation may come in handy:
http://dev.mysql.com/doc/mysql/en/mysqld_multi.html
Cheers,
--V
Lou Olsten wrote:
We have successfully (and easily)
In my experience, where the my.cnf file is concerned, mysqld does not
care what you define for the value of the --datadir flag. The order of
precedence for locating my.cnf files is:
1) /etc/my.cnf
2) my.cnf in the COMPILED-IN DEFAULT datadir
3) .my.cnf in the user's $HOME
That
10:15, V. M. Brasseur wrote:
In my experience, where the my.cnf file is concerned, mysqld does not
care what you define for the value of the --datadir flag. The order of
precedence for locating my.cnf files is:
1) /etc/my.cnf
2) my.cnf in the COMPILED-IN DEFAULT datadir
3) .my.cnf
$ perror 145
Error code 145: Error 145 occurred.
145 = Table was marked as crashed and should be repaired
I think `myisamchk` needs to come into play here (both on slave and
master at this point).
http://dev.mysql.com/doc/mysql/en/myisamchk_syntax.html
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore for now the insecurity of putting a password in the my.cnf
file
This line probably should have been a good hint:
InnoDB: File operation call: 'tmpfile'.
Any idea why the server crashed in the first place? That's not the sort
of thing you want just randomly happening, I'd imagine. Although it
might make life a bit more interesting...
Cheers.
--V
Chris
Are you sure that the server is using the my.cnf file which you are
changing? After making the change, what is the output of
--print-defaults for mysqld? If it's not as expected, odds are good
that the server is getting its defaults from a different location.
--V
[EMAIL PROTECTED] wrote:
Hi
What else is in the my.cnf file? For instance, when I run `mysqld
--print-defaults` on my system I see this:
mysqld would have been started with the following arguments:
--basedir=/path/to/mysql-4.0 --datadir=/path/to/mysql-4.0/data
--port=1032 --socket=/path/to/mysql-4.0/mysql.sock
Paul DuBois wrote:
At 8:06 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore for now the insecurity of putting a password in the my.cnf file.
This is mostly a hypothetical question at the moment.
Calling
Jon Miller wrote:
I've been asked to setup a MySQL DB for critical mass usage. The programmer is
asking that I use MySQL-Max. Does this have to be installed along with the regular
MySQL version or is it a single product on it's own?
From the MySQL/downloads page for 4.0:
The Standard
Wong Zach-CHZ013 wrote:
Hi
1- Is there a command to rename an existing database ?
2- If not, how does one create a new database from an existing database ?
could you show me the steps?
Any help is appreciated.
Thanks
Have you tried the mysqlhotcopy util?
47 matches
Mail list logo