Is there a list off MySQL error-codes avalible?
Something like Oracle's oerr. program?
perror
We are having trouble with one of our MySQL databases. The error is:
Got error 124 from table handler.
chris@entropy:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index given
with that parameter. To start with a
back_log of 200, you must do:
c:\mysqld -O back_log 200
when mysqld is not running, then run mysqladmin variables to see if it
was updated.
--
Chris Bolt
[EMAIL PROTECTED]
http://www.bolt.cx/
-
Before
Of course, the SAME spam we saw before appears again. No surprise.
Does anyone still believe this will go away by itself? It won't -
it will only get worse - unless the list administrators actually
*do* something about it! The filters DO NOT WORK.
Is there any reason why the list can't just
when as root I give command
/usr/bin/safe_mysqld
It gives me following messages:
Starting mysqld daemon with databases from
/var/lib/mysql and on the next line it says
mysqld ended.
What does /var/lib/mysql/`hostname`.err say?
Is it possible to update a field with the result of a select.
For example:
Try:
SELECT @newbalance := ordr_order.total_cost - sum(ordr_payment.amount) FROM
ordr_order LEFT JOIN ordr_payment on ordr_payment.ordr_order_id =
ordr_order.id WHERE ordr_order.id = 1;
UPDATE ordr_order SET balance =
#2 All I have read on the web/books suggests that this is what to do
$result = mysql_query (SELECT title, description, url, author,
date_format(datefield, %M %D %Y') FROM documents);
This just leaves out all dates.
You may want to try:
$result = mysql_query(SELECT title, description,
Here's the simplified query:
SELECT members.name, group.id, group.name
FROM members
LEFT JOIN members AS group
ON group.id = members.group_id
WHERE members.id = 6
And here's the error I get:
You have an error in your SQL syntax near 'group ON group.id =
regarding mysql_pconnect() we haven't tried that, but the nature of
the site suggests it would need like 500 apache deamons connected
all the time. And that's a lot of sort buffers and stuff beeing
allocated for each one of those ?
Not if you disable keepalive requests, which I do on
I am looking to update a record in a table, but take the
exsisting value and adding the new value to it...
I.e.
Exsisting record = 150, new record being inputed = 250 for a
total of 400 to be entered into the database.
UPDATE table SET row = row + 250 WHERE id = #;
Our brand new, fresh install of 3.23.46 won't let us set the
password for the root user because one seems to already be set.
Even after wiping the ...mysql/data/mysql directory clean and
rerunning mysql_install_db, we still get an Enter password:
prompt when attempting to set the root user
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you Duplicate entry errors if you hit the maximum.
I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
ISAM tables also returned a Duplicate entry error when I hit
the max. Was
It puts the messages in a tree and makes viewing pertinent threads
a breeze,
My mail client puts messages in a tree and makes viewing pertinent threads a
breeze. And even with the archives:
http://marc.theaimsgroup.com/?t=10043869449w=2r=1
Doesn't look hard to me...
quickie: can auto_increment wrap?
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you Duplicate entry errors if you hit the maximum.
-
Before posting, please check:
I am a newbie at this and I cannot find the damn answer to it! I want
to display the table in an html format with PHP but I cannot get it to
work! With MS SQL Server it was sooo easy! With PHP and mySQL it's a
pain in the butt! I cannot find any documentation on this and I order 3
books
I'm using 3.22.27 and am getting an error when I submit queries.
I do a select * from table where...
And it gives me:
ERROR 1030: Got error 127 from table handler
chris@entropy:~$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
Run isamchk -r on the table.
Is there a way to raise this limit? We have some tables with columns that
are VARCHAR(200), and need to make a primary key based on combinations of
these columns (in some cases, upto 4 columns), and MySQL complains for all
of these table definitions that Specified key was too long. Max key
I have been trying to get mysqld to run under 2 ip addresses
(localhost and an external ip address). Using the bind-address
option twice doesnt seem to work, nor does lisiting 2 ip addresses
in the option. I hope mysqld has this functionality to be able to
run under certain ip addresses
I would like to find out what record in the table has
the largest amount of characters. This way I could possibly
decrease the varchar size (currently 100) to speed up the
queries.
My table is as below.
CREATE TABLE competitor (
CompetitorsName varchar(35) not null,
Website
Have you also increased your master maxfiles as well? If not, you're not
getting the number of file handles you expect you are. I'd also consider
upgrading to 4.3, as it's much faster than 3.x.
Try this --
sysctl -w kern.maxfiles=16424
kern.maxfiles is already the same as
I am currently using Slackware 8 (linux) and I have some problems. There
is mysql package in the slackware installation, which I installed it but
never manage to run it successfully. Everytime I type the following
safe_mysqld
and I get the following message:
Starting mysqld daemon
Right now MySQL is getting really backlogged but I have no idea why. There
are 169 concurrently running queries, and 153 of them are in show the status
as Opening tables. A processlist looks something like this (formatted by
Status, Seconds query has been running, and query):
Opening tables
Hello,
I was working with Mysql an nerver had any problem, the suddenly from one
moment to the other, some tables didn't work correctly any more.
Any select
command on them returns me :
1030: Got error 127 from table handler.
But if I do a select command on a other table with a join on
Thankx for reply.
But if I use Table Repair it says : The handler for te table
doesn't support Check/Repair.
What does SHOW TABLE STATUS LIKE 'tablename'; say for the Type column?
-
Before posting, please check:
I need to search a mysql database using wildcards. I know about the * and
the _ wildcards (any number of any character and 1 character of any kind,
respectively) but I need to match any number, any letter and thing like
that.
An SQL book claimed it could be done using brackets and ranges
SQL question which I am new to.
How would I count the number of times a specific entry is in field. For
instance I have a table that has the following two fields
numberhostname
1 10.1.1.1
2 10.1.1.2
3 10.1.1.3
4
I am looking build my own E-mail Server for my Domain and would like
some pointers
Is there an E-mail Server that uses MySQL
Exim, Postfix, and Sendmail can all use MySQL to varying degrees.
There are probably others.
qmail; http://cr.yp.to/qmail.html, http://www.lifewithqmail.org/
now i changed the root password just fine
but now i have to enter it every time i run mysqladmin
even mysqladmin version reqires a -p
tell me there's a simpler way
http://www.mysql.com/doc/C/o/Connecting.html
* You can specify connection parameters in the [client] section of the
A quick question: How come the mailing list software
doesn't add a reply-to header? Is this intentional to
keep replies off the mysql list, and if so why?
http://www.unicom.com/pw/reply-to-harmful.html
-
Before posting,
I want to create a table with two Primary Keys. The first key is
a category
field, and the second is auto-incremented. Example: Key
1=Chapter name, Key
2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3)
then with a new Cheaper, I want to restart the
I'am having this error code (Error 12 from table handler) when i am trying
to create an index on a table that has about 20 records (it's
not a big table)...
What does this error code means?.
chris@illusion:~$ perror 12
Error code 12: Cannot allocate memory
chris@illusion:~$
And is there some way to download the previous posts to this list? I
found one list admin function that will download up to 100 posts
concatenated into one email, but I'd like to be able to d/l them
individually, with their own subject line and threading info. I just
think it would be
Go error 127 from table handler.. fixed itself in about 10 minutes..
don't know what this is or why it happened.. anyone know?
It happened while doing an update SQL command to a table.
I'm not even sure what it means.. can't find any error codes.
Try running perror 127
update cdrequest set albumfill = hot shots II, releasedatefill
= 20010708 where requstID = 2;
i get:
You have an error in your SQL syntax near '\hot shots II\,
releasedatefill = 20010708 where requstID = 2' at line 1
I can't see any reason for the error.
Your web based interface is
I'm still testing out MySQL and I'm trying to find the my.cnf
file referred to at
http://www.mysql.com/doc/O/p/Option_files.html
...
but none of these files seem to exist on my machine.
...
MySQL came pre-installed on that machine. Is it possible (or, indeed,
normal) that the MySQL
How is that possible? Even if you do know someone's scrambled password,
when you connect to the MySQL server pretending to be that user, it will
ask you for their non-scrambled password. After you type it in,
the server will scramble it and check that the scrambled value matches
the
Is there any way -- using either MySQL directly, or (ideally)
using the DBI perl module -- to get a list of fields from a
(possibly empty) table? (If the table is nonempty, you can
just use a perl function to get the first record, and then
apply keys() to the returned reference to get the
i have a problem in query. My field type is integer.
The table is empty and i want to select max number from the
field but it display error message.Then i try to change the type
to char ,it's can but,
the max is until 9 only.is there anyone can help me.
What query? What table? What error
I am not sure if this has been addressed before, I think it would
be neat if the list admin could put a [mysql] in the subject line
for messages. I get a lot of email and it would help having that
in the subject line. it would also help me in filtering my mail.
Please let me know your
is there any way turn the following query to all ands instead of using an
or?
select f1,f2,f3 from table1 where (f1 ='monday' or f2 ='monday') and
f3='34';
SELECT f1,f2,f3 FROM table1 WHERE 'monday' IN (f1, f2) AND f3 = '34';
Lets say i have 10.000 rows in a table and im searching for only
one record(one row).
Which one is faster:
SELECT ... LIMIT 1
or just
SELECT ..
The former, since MySQL stops after finding the first row. In the second
query, MySQL prepares the entire result set even if you only
Example I have a file name stored in database as: john's - song.mp3
When I click on the link to the song in a web browser I get file not
found.
http://www.php.net/rawurlencode
-
Before posting, please check:
i have 2 mysql servers, i need to run a query that joins two tables
from two databases on the two servers, how can i do this?
You can't.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
hi all..
this error came out after i make backup for my database using mysqldump
what this error say is wrong... maybe my database is corrupt or
crash or something like that.. any command can fix this error..?.
any idea what i should do.
Please paste the output of typing DESCRIBE
Hi,
I have looked through the documentation (http://www.mysql.com/docs)
and the mailing list archives
(http://www.geocrawler.com/lists/3/Databases/8/0/)
and find no mention of a feature that I was hoping was available:
* text or varchar columns that are automatically
SELECT * FROM listaemail WHERE id LIKE %% OR nome LIKE %% OR empresa
LIKE %% OR email LIKE %% OR ativo LIKE %% ORDER BY nome;
Time: 11 Lock_time: 0 Rows_sent: 30567 Rows_examined: 30568
before anyone jumps out and points it out, it is far
from being optimized. it should (and will, as soon
Database error: Invalid SQL: select id, subid from policy where
id='2' and subid='0'
MySQL Error: 1054 (Unknown column 'id' in 'field list')
Session halted.
the output look like this..
mysql desc policy;
+++--+-+-+---+
| Field | Type
I am currently trying to examine the benefits of continuing to
use MySQL over Oracle. I need to know what MySQL's features are
vs. those of Oracle.
http://www.mysql.com/information/crash-me.php
Also I am looking for performance data.
Oracle prohibits benchmarks, so good luck finding them.
I need to build a search utility which can query records based
on multiple text parameter,
my table will have about 10 fields and users can search on
3-5 parameters in one query. is there any way to achieve this
other than doing a full table scan.
$sql4 = SELECT hits.hit_id as pixels from hits
WHERE hit_id=LAST_INSERT_ID();;
$result = mysql_query ($sql4, $connection)
or die(error # . mysql_errno() . : . mysql_error());
$row = mysql_fetch_object($result);
$pixels = number_format($row-pixels);
It's staggering the difference in
mysql select vend_city+', '+vend_state+' '+vend_zip
- from Vendors
- order by vend_name
- ;
...
4 rows in set (0.01 sec)
How do I do this in MySQL?
SELECT CONCAT(vend_city, ', ', vend_state, ' ', vend_zip) FROM Vendors ORDER
BY vend_name;
C:\mysql grant all on *.* to administrator@sara identified by delboy
Try this:
C:\mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 463668 to server version: 3.23.39-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql grant all on
3. Is this a MySQL feature / bug or do other DBs support this?
It doesn't work in Postgres.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Am I the only one getting these? Someone really needs to fix their mail
server...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 4:10 AM
To: [EMAIL PROTECTED]
Subject: No valid command found
Your message does not contain a valid
Hello,
I am still a beginner, but I am trying to learn MySQL. If you have a
date field, and you are using the date field in your where clause, I
understand how to use :
WHERE date=-mm-dd; I am trying to find out if there is anyway
to use the wildcard character % in dates
I create a table, one field is integer type.
I don't know why the following statements work :
select * from table1 where field1 = 3;
select * from table1 where field1 = '3';
In the second case, MySQL automatically casts '3' to 3.
umm when i declare a unique constraint on 2 fields in a table like so
unique (col1,col2),
if i insert data into the table will it check them individually or as a
composite?
for example if i inserted the values
col1 | col2
1, A
1, B
2, B
2,
What error did you get? Did you try using NULL for the id, or leaving the
auto_increment column out of the insert (insert into table (PartNumber, ...,
StatusQtyWorked) values (...))?
Hello,
When I submit data it will not submit data into the
database unless I put some kind of number in the ID
He wants to know the maximum, like on a search for mysql at
google it says Results 1 - 10 of about 2,580,000. He wants
to know that 2,580,000 number without doing another query.
I don't think that's possible.
Of course it is. That's what I do all the time. That's what I was
talking
Hi,
I want to compress my tables but I gets an error:
C:\mysql-data\dtim9tmyisampack wi_abbreviation.MYI
Compressing wi_abbreviation.MYD: (7221 records)
- Calculating statistics
- Compressing file
myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13)
Aborting:
Just wondering how many accesses can MYSQL handle... let's say per hour.
I have about 500 accesses per hour, 8 clicks per second... does anyone
know about this issue? thanks
It really depends on what kind of queries you're running, your hardware,
your configuration, your operating system,
Group;
There is something missing in my understanding of the php mysql_connect
statement because I am getting a parse error as follows:
http://cxkop.com/Jobs/job_list.php
Parse error: parse error in
/home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31
This is a php
mysqldump databasename | gzip databasename.sql.gz
transfer that file to the other server
mysqladmin create databasename
zcat databasename.sql.gz | mysql databasename
Hi
Is it possible to import a complete database from a server to another
one?
Thanks
Eugénio
Done, an email is now sent after an order is submitted. This is what it
I have found a large number of files which have names like this
www-bin.040
www-bin.041
www-bin.042
www-bin.043
www-bin.044
which are using up huge amounts of disk space on my server.
It looks
We do a few large daily and monthly downloads from an Oracle database
server. Is there a way to exclude these specific queries from the
update/binary log??
If the queries only affect one table or database, use the replication ignore
options listed here:
sorry im a mysql newbie...how do you bind mysql to two particular ip
addresses? i have it bound to my loopback but would like to bind it a
private ip but it doesn't seem to like the bind-address directive
more than once.
Run two separate mysql daemons with a different --bind-address
Is it possible to join two columns from different databases
Yes.
located on differents hosts?
No. Why do you want to do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
No. To rename a database, rename the directory in mysql's data dir. There is
no SQL command to rename a database.
[mysql]
is this how to change the the name of an existing populated db?
RENAME DATABASE old_name TO new_name;
TR
Why does it matter? They can't access them, so what harm is there?
I am sure that it has been asked before. I am running a
hosting company
and I am running mysql on a win2k server.
We don't want any customer to see other db's of any other customer, we
just want them to see their own
Hi,
I have mysql on NT4 (soon to be win2000). one question is that the
database files all reside under drive c. NT does not have symbolic
link
I seem to recall Microsoft making a big deal out of the fact that they
invented symbolic links and added them to Win2000. Anyone used
Try looking in mysql\data\mysql.err or running mysqld --standalone, it may
provide more information.
Hello everyone,
I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had
been running just fine, then all of a sudden stopped working.
When I try a
'NET START mysql', I get
MySQL doesn't support foreign keys. Did you bother checking the manual?
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
Hello
Does mysql support creating and dropping of foreign key constraints?
i tried it.While creating foreign key constraints it doesn't dive
any error
but while
DELETE FROM mbtable WHERE timecolumn DATE_SUB(NOW(), INTERVAL 3 MONTH);
Hello,
I've a messageboard. Now, I want to delete all messages older than 3
months. Can I use a MySQL query to delete all messages or do I have to use
mktime()?
Hi!
Does anybody know how do i change the 'root' password for mysql server?
I installation guide they say that it's done by typing
'/usr/local/bin/mysqladmin -u root -p password new-password', but how
would i know the old passsword?
Am i mising anything?
Leave out -p
Your question has been answered already.
http://marc.theaimsgroup.com/?l=mysqlm=99348999221821w=2
Hi All,
I've been reading up on how to do joins on the mysql site.
Is there not an inverse function for DISTINCT, so that I can pull out
duplicate data as opposed to DISTINCT data...or will
http://www.mysql.com/doc/
HI Everyone
I am looking for a summary/examples of the syntaxes and operators
one may use
in standard sql statements
For example
select name from epm_tble where name like 'abc%'
select x, count(*) from table_where_x_is_in group by x having count(*)1;
This is how I'd like the query to work:
insert into host (host_id, host_IP) values ((select from mail
mail_id where
mail_addr = [EMAIL PROTECTED]), '127.0.0.1')
Try:
insert into host (host_id, host_IP) select mail_id, '127.0.0.1' from mail
where mail_addr = '[EMAIL PROTECTED]';
ALTER TABLE tblname ADD UNIQUE (column1, column2);
The index will automatically be used if you use it in your WHERE clause in
that order. If you want to do fulltext searching on those columns, repeat
the query with FULLTEXT in place of UNIQUE.
Hello,
I'm trying to create a table with columns
Hi,
I am not able to connect mysql server through other
machine in a
network. I have already assign the user using the command of
Grant all on
*.* to user@ipaddress identified by password. Then, try to connect using
mysql -u user@ipaddress -h firstserver -ppassword.But, I
Hi,
How to bind mysql to specific address if I am using my.cnf file.
etc.
[mysqld]
--bind-address=xxx.xxx.xxx.xxx
Is the above syntax correct ??
Close.
[mysqld]
bind-address=xxx.xxx.xxx.xxx
-
Before posting,
Try
net start mysql
at a command prompt
Hi Team,
Pls help, I'm new to mysql.
I got the latest ver installed on NT2000 workstation. Upon I
tried the activate the daemon, under c:\mysql\bin\mysqld,
it won't work. Any advise.
Thanks Regards
KA
As a long time DB2.. Sybase.. Postgresql user upon turning to MySQL
I find only some functionalities not intuitive.
1. What command syntax to use and connect to a database on another
host.
You've got to be kidding me, it's exactly the same as Postgresql:
chris@phantasm:~$ mysql --help
...
USA: http://mysql.he.net/
UK: http://mysql.omnipotent.net/
I have been trying to access www.mysql.com but can not seem to access it.
Does anyone know a mirror site I could go to to download mysql for Windows
2000?
Thank you!
Use http://www.mysql.com/doc/R/e/Resetting_permissions.html to reset your
password.
could someone tell me how to make a clean sweep of MySQL from my
system so i can start over?
(i need to toss phpMyAdmin temporarily too
i get asked for a password at every bend and none of the ones i use'
Download and install
http://www.perl.com/CPAN-local/authors/id/J/JW/JWIED/DBD-mysql-2.0901.tar.gz
Hi,
I am a newbie and hope someone can she light on why I can't get the
DBD::mysql connection working in my perl script. The script is a test one
and very simple.
I have the mysql daemon
Just a couple of questions regarding indexes...
Can I have multiple indexes on the same column?
Yes, but it's kind of pointless.
Will this decrease performance when inserting?
Yes.
Can you create and remove indexes after the creation of the table?
Yes.
Yes, just stop the mysql service before you begin installation by running
something like
net stop mysql
from a command prompt.
Hi everyone,
I'm kinda new with MySQL and I have a question about upgrading MySQL to a
newer version on Windows 2000 OS. Is there any special command that I
http://marc.theaimsgroup.com/?l=mysqlr=1w=2
Is there an archive to this list?
My MS Access ODBC is not sending the user name to MySQL, and I don't
doubt that it is a known problem.
-
Before posting, please check:
http://www.mysql.com/doc/R/e/Replication.html
Hi all,
I'm new to this list, fairly new to PHP and mySQL and I have a question
about syncing two databases. I search all over the web for this,
including a
win32 version of rsync, but that's not suitable in my case, so
here it goes:
The default max_allowed_packet is 1 meg
http://www.mysql.com/doc/P/a/Packet_too_large.html
hi
Can anyone please help with regards to long blob data insert.
I have a data which more than 1mb which MySQL long blob field
refuse to insert.
However if my data is less than 1mb there if no
What are the types of the columns?
Hi all,
... running this query
alter table item_dettagli
add fulltext(categoria_prezzo,settore,movimento,soggetto,lingua)
I get this error:
1005 - Can't create table '.\pickwick\#sql-3d0_2.frm' (errno: 140)
Query:
alter table
http://www.mysql.com/doc/R/E/RENAME_TABLE.html says:
As long as two databases are on the same disk you can also rename from one
database to another:
RENAME TABLE current_database.table_name TO other_database.table_name;
And as the user comments say, you can use ALTER TABLE with 3.22.
Copying
Fatal error: Call to undefined function: dayname() in
/home/ccrb/ccrb-www/index.html on line 8
This indicates that I'm missing most all of the functions. Is there a
standard include that I need, or is my php installation not complete?
Here is the line of code in question:
?php
thank you.
that's sort of what i thought.
now for the silly question:
i know how to do it with 'monitor' (CLI), but where/how do you
import using phpMyAdmin, please? (this i'd love to know :) i looked
through the manual but didn't see anything for import db.
Click a database on the left
Hi there,
I'm using select queries like
SELECT * FROM table_name WHERE col_name LIKE '%some_word%'
to find rows that have col_name match to some_word. But I would also like
to find the number of word matches for each row so that I can order these
rows according to their relevances and
I have downloaded the mySql distribution as well as
2 different versions of gnu tar that available at the site.
gtar-solaris-4.1.4-sparc.gz and gtar-sparc.gz
The reason I downloaded 2 different versions of the gnu tar
is that I can't get anyone of these to deflate using gzip.
I has
That is a .sql file renamed to a .dump file, there's no difference. Import
it with phpMyAdmin or mysql -u username -ppassword dbname whatever.dump
i had some others that i browsed into phpmyadmin and they seemed to
work, but others, like this one, showed a Query error -but that
method of
What format are they in? Please paste a few sample lines.
hello,
i have some files from a Cd that are .dump files, how do i get these
db into mysql? (is it possible using phpMyAdmin).
again, these are .dump files, not .sql files.
I don't think the answer has changed since last week :-)
IMHO it's not really slow and inefficient, anyway - this script:
(clipped)
produces a table with 1 rows each containing an integer. Then we do:
mysql SELECT * FROM mytable ORDER BY RAND() LIMIT 5;
(clipped)
5 rows in set (0.08
SELECT cont.msg_id, cont.msg_text, CONCAT_WS(', ', a1.address, a2.address)
FROM CONTENT AS cont, ADDRESS AS a1, ADDRESS AS a2 WHERE cont.msg_id =
a1.msg_id AND cont.msg_id = a2.msg_id;
Many thanks to salle in efnet #mysql for teaching me this trick ;-)
Hello,
I am relatively new with MySQL
Look up myisampack in the mysql manual at http://www.mysql.com/doc/. The
only drawback is you can't modify the table.
I have a table that has massive amounts of text. Just plain text, stuff
that would compress REALLY well. Does mysql have any sort of compression
internally for the table
1 - 100 of 148 matches
Mail list logo
