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 the
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 (wher
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). My
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' (Errcode:
as it turns out it was a MYSQL BUG
http://bugs.mysql.com/bug.php?id=11151&error=no
thanks anyway
regards Haseeb
- Original Message -
From: "°l||l° Jinxed °l||l°" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, June 08, 2005 3:32 AM
Subject: Re: LOAD DATA INFILE with IN
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:
Sent: Wednesday, June 08, 2005 1:39 AM
Subject: Re: LOAD DATA INFILE - still confused
> At 03:59 PM 6/7/05, Chris wr
DBA wrote:
- Original Message -
From: "Kevin Burton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
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 t
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 tblt
- Original Message -
From: "Kevin Burton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
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 tables and are
>
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 whi
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.
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,
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
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 va
"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 sta
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 (E
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 defaul
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 an
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| 050
Just feedback to the MySQL team...
Query Browser will not launch on OS X 10.3.7
Here is console log output...
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, errno = 2)
J
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]>;
Sent: Tuesday, J
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 my
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-us
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 [mailto:[E
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 (
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]>;
Sent: Tuesday, June 07, 2005 1:23 PM
Subject: RE: max_connect
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 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 do
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 E
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 records
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
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:http://lists.mysql
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
>
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: Y
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
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 cryptog
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
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.
>
>
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
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
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:
http://dev.mysql.com/doc/mysq
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
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:
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 fol
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
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 wor
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!
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 jus
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
c
49 matches
Mail list logo