Hi,
i did it. If you have myisam tables tables rather than innodb say it.
if you have specific os, say it.
i think you should elaborate, or read carrefully dev.mysql.com/doc
Mathias
Selon °l||l° Jinxed °l||l° [EMAIL PROTECTED]:
i used start transaction before using SET AUTOCOMMIT=0; also i
Hi,
Hello.
Check the character sets with the following statement:
show variables like '%char%';
Here's the output:
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_results utf8
character_set_server latin1
character_set_system utf8
Hi!
Check the manual for ft_boolean_syntax variable.
It defines what character is used for every operator.
Space marks default operator - so you can change it.
On Jun 06, Sebastian wrote:
I created a search app with fulltext, boolean, etc. i have two forms,
one that allows the user to just
hi,
that's the same. If you use between, mysql do the rest for you :
mysql explain SELECT * FROM passengers WHERE
- reservation_date_time = '2005-01-01 12:10:00'
- AND reservation_date_time = '2005-05-01 12:10:00';
hi,
yes you did it and i failed to do so. thats why i am here.
i am using MYSQL 5.0.3 beta-standard with RedHat 9 , the test involves only
innodb as i mentioned in the very first post,
i have read docs and it says that there are 3 ways i can start a transaction
and i tried all three i.e. begin
It would appear that LOAD DATA FROM MASTER processes databases and
tables alphabetically. When a merge table is being copied, and it's name
is alphabetically before some/any/all of it's components, the process
fails with a 1017 couldn't find file error.
Has this been fixed? If so, as of which
Hello.
If you're sure that data in your dump file is in latin1 character
set, you could perform something like:
mysql --default-character-set=latin1 dump_file
Roberto Jobet [EMAIL PROTECTED] wrote:
Hi,
Hello.
Check the character sets with the following =
Hello.
I recommend you to upgrade to 4.1.12 (4.0.24) because there were a lot of bug
fixes
as of 4.0.20.
David Griffiths [EMAIL PROTECTED] wrote:
We are running 4.0.20 on two servers (AMD Opteron and Xeon).
Our slave has died twice in the last month with the following error:
Does this weird behavior remain if you're connecting trough UNIX socket
to local instance of MySQL?
Ronny Melz [EMAIL PROTECTED] wrote:
Thanks so far for your advice,
Is it possible that your application doesn't close connection properly?
that is exactly what also I think is the
Hello.
Leave --log-error option for mysqld_safe. As far as I understand it uses it for
it's own log file (different from which mysqld uses). Utilities like
strace could help you to find which process creates certain file. MySQL
supports debugging as well. See:
On Monday 06 June 2005 10:58, Gleb Paharenko wrote:
Does this weird behavior remain if you're connecting trough UNIX socket
to local instance of MySQL?
it does.
At the moment, I try to approach the problem Carl proposed and starting from
scratch. It works fine - hence the problem is not mysql,
can somebody explain the events below:
mysql is running but its not listening on 3306,...as a result clients on remote
machines are not able to connect..
The server name is spiti
confirm that mysqld is running:
[EMAIL PROTECTED] ~]$ ps -ef |grep [m]ysql
root 31515 1 0 15:30 pts/3
Hi,
Thanks for your help.
Usually to export and import dump files I use phpmyadmin, so I'm not very much
familiar with the mysqldump command-line utility :-))
In the command line that you specify below, do I have to indicate the db name ?
Thanks in advance
Regards
Roberto Jobet
Hello.
Digvijoy Chatterjee wrote:
can somebody explain the events below:
mysql is running but its not listening on 3306,...as a result clients
on remote
machines are not able to connect..
by default in PLD the 'skip-networking' option is turned on in
mysqld.conf, maybe you have the same option in
Have you tried to telnet into that port? Are you sure that it's open in your
firewall?
J.R.
can somebody explain the events below:
mysql is running but its not listening on 3306,...as a result clients
on remote
machines are not able to connect..
smime.p7s
Description: S/MIME
Hi,
We would like to upgrade our current installation of Mysql 4.0.x to 4.1 to be
able to switch fastly to the MySQL Cluster Solution.
The problem is, that we were using the TIMESTAMP type quite heavily in the
SELECTS, and we splitted the result using for example,
substring in php, so we
Hello,
I want one of my MySQL-users only update one of my columns in a table. I
used
grant UPDATE (column1) on database1.table1 to 'user1'@'localhost'
but the user1 can update other culumns too.
The mysql-db-table entries for user1 after grant command are:
- db: -
- host: -
- user: Select_priv:
You hit the nail on the head Irek,thanks the problem was skip
networking was on.
Regards
Digz
On Tue, 2005-06-07 at 17:34, Irek Słonina wrote:
Digvijoy Chatterjee wrote:
can somebody explain the events below:
mysql is running but its not listening on 3306,...as a result clients
on
Hello mysql,
Is mysqldump from 5.0 dumping a stored procedures?
If it isn't, then when (if planned)?
--
Best regards,
Juri mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
From: Wolfgang Gliese
- db: -
- host: -
- user: Select_priv: Y
- tables_priv: Table_name: table1; Table_priv: - ; Column_priv: Update
- columns_priv: Table_name: table1; Column_name: column1; Column_priv:
Update
What can I do?
I think you'd better reset the column_priv: Update in the
Hello,
I have a table that has a varchar column in which I need to change a prefix for
all records. Currently there are about 500 records and I did not want to do
this by hand. It looks like this:
[data here ]
UP05000
UP05001
UP05002
UP05003
The identifier has now changed to EN so each
Hello,
I have a problem with a database mask I use named torque. I get an
error Cannot get connection from pool
I beleive it is from the max_connections reaching their limit. I put the
line max_connections=200 in the my.cnf file but when I check the show
variables of the database through
This query (or something like it) should do the job for you:
update temp11
set description = replace(description, 'EN', 'UP');
Naturally, you need to change 'temp11' to your table name and 'description'
to the name of the column containing the data you want to change. The
replace() function is
Where are you getting this error from?
Sounds like something on top of mysql that is doing the connection pooling
perhaps.
-Original Message-
From: James Sherwood [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 12:28 PM
To: mysql@lists.mysql.com
Subject: max_connections
Hello,
This error is thrown in a mask we use called Torque, it does the connection
pooling but we have never had a problem with it such as this until now.
James
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, June 07, 2005 1:23 PM
That's on the schedule (and has been for a bit), but our slave seems to
stop replicating every week or two. Combine that with weekly pushes, and
other must-do stuff, it seems to always get dumped on the back burner.
David
Gleb Paharenko wrote:
Hello.
I recommend you to upgrade to 4.1.12
I would then gather to say that the limit (hence the error) is being
generate by Torque, which does the connection pooling, and has nothing to
do directly with max_conn.
Is there a config file or something that you can look for in torque?
-Original Message-
From: James Sherwood
Hello.
Use SHOW GRANTS statement to see all permissions which user has
and revoke unnecessary. See:
http://dev.mysql.com/doc/mysql/en/show-grants.html
http://dev.mysql.com/doc/mysql/en/grant.html
Wolfgang Gliese [EMAIL PROTECTED] wrote:
Hello,
I want one of my MySQL-users
Hello.
Yes, you should specify all necassary options
(database, login, -p switch for password).
Roberto Jobet [EMAIL PROTECTED] wrote:
Hi,
Thanks for your help.
Usually to export and import dump files I=
use phpmyadmin, so I'm not very much
familiar with the mysqldump
Yes, we have been looking into that as well, the problem is is that some
changes we have made seemed to have helped and it takes 12hours or so for
the error to occur, making it a slow process:)
James
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED];
Just feedback to the MySQL team...
Query Browser will not launch on OS X 10.3.7
Here is console log output...
console.log
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query
Browser can't open library: /usr/lib/libstdc++.6.dylib (No such file
or directory,
Hi,
thsi can be a solution, there are others :
mysql select substring(id,1,2), substring(id,3,length(id)) from mytable;
+---++
| substring(id,1,2) | substring(id,3,length(id)) |
+---++
| UP|
I have a simple php script which runs the following query:
LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n'
which generates the error:
File './mydabasename/datafile.txt' not found (Errcode: 2)
The simple php script
Hello,
I am trying to create simple reference table for some cookies I am creating. I
wanted to put in a current_timestamp each time I do an insert so I can delete
this data after 2 or 3 weeks.
Here is the insert statement:
CREATE TABLE COOKIE_REF (cookie_ref varchar(50), dat timestamp
At 03:59 PM 6/7/05, Chris wrote:
I have a simple php script which runs the following query:
LOAD DATA INFILE 'datafile.txt' INTO TABLE LocationTEMPSR12 FIELDS
TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n'
which generates the error:
File './mydabasename/datafile.txt' not found
Scott Purcell [EMAIL PROTECTED] wrote on 06/07/2005 04:29:56 PM:
Hello,
I am trying to create simple reference table for some cookies I am
creating. I wanted to put in a current_timestamp each time I do an
insert so I can delete this data after 2 or 3 weeks.
Here is the insert statement:
You do not need to set a default value if you want the current_timestamp.
Just leave the default option out when creating your table and the server
will do it for you.
CREATE TABLE COOKIE_REF (
cookie_ref varchar(50),
dat timestamp
);
OR
If you really want to put in a
OK...
Subqueries in 4.1 are totally broken. They don't use indexes. They're
evil. We're told we have subqueries but there's no way anyone on earth
could use them. To make matters worse a lot of developers are TRICKED
into using them and assume that mysql would do the right thing but its a
Thanks for your reply. I guess the root of my problem is that MySQL is
making a poor choice of index, which I presume is based on the cardinality
numbers of each index. When I run ANALYZE TABLE, these values can fluctuate
wildly -- between 16 and 26,000, for example. According to the manual,
They do use indexes if you use them to build derived tables and are
pretty fast. The only case where I see them not using indexes when I
think they should is when you use a sub-query for an IN() clause.
Kevin Burton wrote:
OK...
Subqueries in 4.1 are totally broken. They don't use indexes.
Greg Whalin wrote:
They do use indexes if you use them to build derived tables and are
pretty fast. The only case where I see them not using indexes when I
think they should is when you use a sub-query for an IN() clause.
I'm sorry.. yes.. They're not using indexes when within IN clauses
- Original Message -
From: Kevin Burton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, June 07, 2005 6:11 PM
Subject: Re: Seriously.. When are we going to get subqueries?!
Greg Whalin wrote:
They do use indexes if you use them to build derived
this is strange, when i do this..
===
mysql start transaction;
Query OK, 0 rows affected (0.00 sec)
mysql insert into tbltemp (tmp_crdd_no,tmp_serial_no,tmp_date)
values('100','100',NOW());
Query OK, 1 row affected (0.00 sec)
mysql select * from
DBA wrote:
- Original Message -
From: Kevin Burton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, June 07, 2005 6:11 PM
Subject: Re: Seriously.. When are we going to get subqueries?!
Greg Whalin wrote:
They do use indexes if you use them to
yes he is right i am doing the same. and giving full path. i have other
problems with load data infile :(
- Original Message -
From: Frank Bax [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, June 08, 2005 1:39 AM
Subject: Re: LOAD DATA INFILE - still confused
At 03:59 PM
as it turns out it was a MYSQL BUG
http://bugs.mysql.com/bug.php?id=11151error=no
thanks anyway
regards Haseeb
- Original Message -
From: °l||l° Jinxed °l||l° [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, June 08, 2005 3:32 AM
Subject: Re: LOAD DATA
Well, in fact I have read the documentation several times before posting
this note.
My problem arises because I don't know what is meant by full file path. If
you mean: 'http://www.mydomain.com/datafile.txt' that produces the error:
Can't get stat of 'http:/www.mydomain.com/datafile.txt'
Hi Friends,
I'm Ashok. I tried one c-cgi script which is get two
input data from the user (thro' browser) and store it
into MySQL Database, which is running in my m/c as a
service. It's working well in my local pc.
Now i want to host that cgi pgm into one site (where
cgi scriptings r allowed).
Ashok Kumar wrote:
Hi Friends,
I'm Ashok. I tried one c-cgi script which is get two
input data from the user (thro' browser) and store it
into MySQL Database, which is running in my m/c as a
service. It's working well in my local pc.
Now i want to host that cgi pgm into one site (where
I recently received some old database files from my ISP. I'm trying to
convert the documents to excel format. When I try to load the .frm,
.MYI and .MYD files on my OS X MySQL databases I get the following
error.
#5 - Out of memory (Needed 3024898224 bytes)
Unfortunately I can't work with
50 matches
Mail list logo