Hello!
Let me introduce myself. My name is Mr. Rajesh Tavakari from
www.website-promotion-ranking-services.com, and you can contact
me at [EMAIL PROTECTED] or [EMAIL PROTECTED]
I enjoyed visiting your interesting site at http://www.mysql.com/documentation/. You
may know that having high lin
Hi everybody,
I got a problem with the "mysqldump" function.
I connect to mySql trough phpMyAdmin, select the database "xyz", which
is the only database on the server.
Then I enter the following string into the text field "Run SQL
query/queries on database xyz:":
mysqldump xyz | mysql --host=XX
If you want a MyISAM table to grow larger than 4GB you have to do
alter table tablename max_rows=1
or maybe its 'maxrows'...
Once you do that, you will be able to stuff the table as full as the OS will
let you.
Innobase will allow you to get around this by making a bunch of smaller
fil
hi all...
i have a mysql query as follows:
SELECT *,
( if((description LIKE '%keyword_one%'), 1, 0)+
if((description LIKE '%keyword_two%'), 1, 0)+
if((description LIKE '%keyword_three%'), 1, 0)+
if((description LIKE '%keyword_four%'), 1, 0) ) as keyword_score,
FROM tabl
Is there a place that outlines the advantages/disadvantages of both
MyISAM and InnoDB?
Thanks,
Chris
-Original Message-
From: Tonu Samuel [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 2:34 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Thinking of switching from My
On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote:
> There is no 4 Gb limit in MyISAM with later 3.23 versions.
>
> This limit is imposed by a filesystem only.
and RAIDed table can help to build aby size tables if only index
file doesn't get too big.
Actually InnoDB is nice thing.
On 04 Aug 2001 22:57:39 +0300, Khaled I. Hammouda wrote:
> Greetings ALL:
>
> I am developing a database application using mySQL & php for a client
> that requires data entry (at least) to be in Arabic.
>
> I am know that mySQL supports charsets, but it is not clear if it
> supports charsets tha
Hi !
> -Original Message-
> From: shawn reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 04, 2001 12:50 PM
> To: RCA Webmaster
> Cc: [EMAIL PROTECTED]
> Subject: Re: New member question
>
>
> there are a number of ways you could accomplish this.
>
> depending on how large the datab
Greetings ALL:
I am developing a database application using mySQL & php for a client
that requires data entry (at least) to be in Arabic.
I am know that mySQL supports charsets, but it is not clear if it
supports charsets that are not left-to-right, such as Arabic.
If the answer to this is obvi
there are a number of ways you could accomplish this.
depending on how large the database is, you may want to try exporting it
to csv (comma separated value) format, and then importing it into mysql,
using either the "load" command, or a third-party utility like phpmyadmin
(which is what i genera
I have just subscribed to this list, so forgive me if my question has been
answered many times before but I was not sure where else to find this
information.
I am new to mysql and am going to be using it on a website that I maintain.
My question is, is there a program/utility or easy way to conv
On Sat, Aug 04, 2001 at 09:15:52AM -0500, Gerald R. Jensen wrote:
>
> To the best of my knowledge, MySQL doesn't impose file size limits
> ... that is dictated by the O/S's file system. Switching to InnoDB
> wouldn't change that.
But InnoDB would let you use multiple tablespaces to get around an
At 18:29 04/08/2001 +0300, Hiba Muhrez wrote:
Hi,
When you unzipped the 3.23.40 distribution file you should
have the following files:
02/08/2001 00:31 128 DATA.TAG
02/08/2001 00:31 11.535.662 data1.cab
30/05/1997 11:314.557 lang.dat
02/08/2001 00:3
please,
i downloaded the mysql 3.23 from your site and i
made the unzip
and when i begin to make setup i found error:
missing setup.dll
what can i do?
please reply fast
[EMAIL PROTECTED]
yasmeen
-
Before posting, please chec
Hi,
Sorry to have bothered everyone. I was using .38. I just noticed that and
am currently building .40.
Cal
http://www.calevans.com
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 9:59 AM
To: Sinisa Milivojevic; [EMAIL PROTECTED]; [EMA
>Description:
mysql refuses connection [local/unix-socket] when client is ran under GDB,
and linked with pthread library. It doesn't need to call any pthread_*()
function, it just fails when linked with it.
>How-To-Repeat:
#include
#include
main()
{
MYSQL m;
Hi!
What InnoDB version you are using? A bad rollback
bug was fixed in version 3.23.39.
Regards,
Heikki
At 05:40 PM 8/4/01 +0300, you wrote:
>Content-Type: message/rfc822
>Content-Description: forwarded message
>Content-Transfer-Encoding: 7bit
>
>MIME-Version: 1.0
>Content-Type: text/plain;
>
On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote:
> Nick Seidenman writes:
> > Apparentlly there's a 4 GB limit to a MyISAM file when the table it
> > contains has VARCHAR, TEXT, or BLOB columns. In order to get around this
>
> There is no 4 Gb limit in MyISAM with later 3.23 versions.
I have a reproducible but it's not easy to reproduce. It involves a complex
transaction that gets rolled back instead of committed.
Cal
Innobase: Assertion failure in thread 8201 in file trx0roll.c line 887
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL
Nick:
What O/S are you running ... Windows?
To the best of my knowledge, MySQL doesn't impose file size limits ... that
is dictated by the O/S's file system. Switching to InnoDB wouldn't change
that.
Gerald Jensen
- Original Message -
From: "Nick Seidenman" <[EMAIL PROTECTED]>
To: <[EM
Ken Menzel writes:
> Hi Michael,
> Sounds like the mysqld may have been stuck in a tight loop then.
> Any ideas Sinisa?
> Try the truss once more if it happens again. I can't think of
> anything that would cause this.
> Let me know what happens, also try the truss when the server is
> running
David White writes:
> I have a problem with some data disappearing after a CREATE INDEX
> statement. Here's the sequence of events:
>
> 1. I have the tables MASTER_ACCOUNT, MASTER_EMAIL, MASTER_GROUP,
> MASTER_INDIVIDUAL, TMP_PHONE_DAY, TMP_PHONE_FAX, and TMP_PHONE_NIGHT.
> All of these are pop
Charles Mégnin writes:
> I am getting an error message
>
> Can't connect to local MySQL server through socket '' (111)
>
> trying to connect via mySQLgui on my Linux box running RH6.2
> I do have a
> /tmp/mysql.sock
> with proper authorizations
> and have no problem connecting to the serverwitho
Nick Seidenman writes:
>
> Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains
> has VARCHAR, TEXT, or BLOB columns. In order to get around this limitation I
> was looking to switching to InnoDB table types. As this looks like a
> relatively new subsystem I'm wonderi
Kevin X Lin writes:
> Hi there,
>
> I'm running into problems with functions "floor/ceiling" when I use
> Visual Basic to talk to mySQL through myODBC.
>
> My code looks like this:
> sSQL = "select floor(3.2)"
> Set rs = MySQL_conn.Execute(sSQL)
>
> I got rs.eof = true after execution of the qu
Eric Fegraus writes:
> Hello,
> I just checked the list for answer to this question and looks like there
> hasn't been one. I have a similar problem, I want to delete a record
> from a table where the value of the field is equal to the value of a
> field in another table.
>
> delete from table1
Well, sometimes I use all of the fields in the SELECT statement,
sometimes just one.
How about if I create both indexes?
How would it affect the performance? I don't care about update time as i
insert or update records at night only once a day.
Thanks for the answer
- Original Message -
Mario Witte wrote:
>
> On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote:
> > Mario Witte wrote:
> > Memory or motherboard. How many sticks of RAM do you have in the machine? Are
> > they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb
> > running at this time? (might
What is better:
CREATE INDEX ix1(field1, field2, field3);
or
CREATE INDEX ix1(field1), ix2(field2), ix3(field3);
I have a large table of some 30,000,000 records and am wondering
which indexing gives better performance and why.
How do I optimize search on this table - I'm using lots of OR st
On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote:
> Mario Witte wrote:
> Memory or motherboard. How many sticks of RAM do you have in the machine? Are
> they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb
> running at this time? (might be a hard-drive croaking while
Adam Douglas writes:
> Ahh what do you mean "all tables are not related with common columns"? They
> are not suppose to be related with a common columns. PostalCodeInfo and
> Company table are completely two different things.
>
> Yes that is correct, I've resolved the issue with PostalCodeInfo fo
On Fri, Aug 03, 2001 at 03:35:11PM -0700, L. S. wrote:
>
> Is there Embedded SQL support for MySQL?
There is some embedded work goin on in the 4.0 (development) branch of
MySQL. The manual describes how to get access to the 4.0 tree if
you'd like to check it out.
Jeremy
--
Jeremy D. Zawodny, <
On Sat, Aug 04, 2001 at 12:46:06AM -0700, Eric Fegraus wrote:
>
> I just checked the list for answer to this question and looks like
> there hasn't been one. I have a similar problem, I want to delete a
> record from a table where the value of the field is equal to the
> value of a field in anothe
Hello,
I just checked the list for answer to this question and looks like there
hasn't been one. I have a similar problem, I want to delete a record
from a table where the value of the field is equal to the value of a
field in another table.
delete from table1 where table1.column = table2.column
34 matches
Mail list logo
