Eko Budiharto wrote:
Hi,
I would like to ask about the size that can be handled by mysql. How big if I
use innoDB? How big with myISAM?
Quoting from the manual "65536 terabytes"
http://dev.mysql.com/doc/refman/5.0/en/table-size.html
Try 5 minutes of searching the manual next time.
Hi,
I would like to ask about the size that can be handled by mysql. How big if I
use innoDB? How big with myISAM?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Hi,
When I try to repair a database that has been marked as crashed, I get the
following error:
| db.table | repair | info | Key 1 - Found wrong stored record at 885548
|
| db.table | repair | error| Not enough memory for blob at 885648 (need
842150190) |
| db.table | repair | inf
Or you can name it by your name JesseSql as long as you are in control :-)
...then no one would attempt claim "Hey! thats my S-Q-L don't touch it". Its
all yours.
-Melvin
Jesse <[EMAIL PROTECTED]> wrote: I guess perfectionism in a lot of what I do is
a problem I've got to deal
with. But I h
hahaha, I see. Thank you very much.
Regards,
Gu Lei
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "åˆóã" <[EMAIL PROTECTED]>;
Sent: Friday, June 09, 2006 11:02 AM
Subject: Re: mysql-5.0/Docs
At 10:45 +0800 6/9/06, å^óã wrote:
>Thanks a lot.
>
>
>
>In MySQL Internal
At 10:45 +0800 6/9/06, åóã wrote:
Thanks a lot.
In MySQL Internals Manual:
"At this moment, internals.xml has over 100
pages of information, including some details
about the formats of MySQL files that you won't
find anywhere else, and a complete description
of the message formats that
Sorry everyone, forgot to put in my setup detail!
SQL version: 5.0.22-community-nt
Windows 2000 Professional 5.0, SP 4
Dan, I tried your suggestion, but no luck :(.
explain select straight_join * from l,d where (l.sId = d.dId) and
(d.sId in (1,2)) \G
*** 1. row *
Thanks a lot.
In MySQL Internals Manual:
"At this moment, internals.xml has over 100 pages of information, including
some details about the formats of MySQL files that you won't find anywhere
else, and a complete description of the message formats that the client and
server use to communicate
At 9:52 +0800 6/9/06, åóã wrote:
Hello:
In MySQL Internals Manual:
"With the BitKeeper downloads, /Docs is nearly
empty. The important files are only present if
you do a regular source-file download, or if you
do a separate 'bk clone' for 'mysqldoc' instead
of 'mysql-5.0' (in which cas
Hello:
In MySQL Internals Manual:
"With the BitKeeper downloads, /Docs is nearly empty. The important files are
only present if you do a regular source-file download, or if you do a separate
'bk clone' for 'mysqldoc' instead of 'mysql-5.0' (in which case this major
directory is mysqldoc/Docs i
Hello
That version is quite old and is an alpha version. I think you can download a
release for production use.
Gu Lei
- Original Message -
From: "murthy gandikota" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 08, 2006 9:04 PM
Subject: ERROR 2013 (HY000): Lost connection to MySQL serve
I was doing a full text search and had a question on why two different
entries got the same score:
Here is my select statement
SELECT
id,
pubyear,
MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines to
surveyors, and survey protocols (MLM)' ) AS score,
title
FROM tblbook
Ian, I ran into a similar situation not too long ago when setting up
replication. I don't recall if the error message was identical but was
certainly close.
My problem was that we had customized our original server (and
mysqldump) to allow 16 MB "packets", which is essentially a setting
gove
table master has alast_dat, a date that is not updated. pk is reg_id.
table detail has date_update, inserting each transaction. fk is reg_id.
is there an update command that will take max date from detail table and
update alast_dat?
tia,
.V
--
MySQL General Mailing List
For list archives: h
On 6/8/06, Frances <[EMAIL PROTECTED]> wrote:
Daniel da Veiga wrote:
> On 6/8/06, Frances <[EMAIL PROTECTED]> wrote:
>
>> what's event viewer? (searched google for error 1067, so opened .err
>> file, this is what is says (at the bottom, long file):
>>
>> 060607 22:37:33 [Note] mysqld: Shutdown c
I am creating a new table from the fields of an existing table.
create table newtable select a+b+c col1 from oldtable
I don't want to create newtable ahead of time because it will have around
200 fields in it and it gets clobbered every time I run the query.
The problem with the create table
Sorry, forgot to send to the list aswell. My reply is at the bottom.
> -Original Message-
> From: Ian Barnes [mailto:[EMAIL PROTECTED]
> Sent: 08 June 2006 09:58 PM
> To: 'Kishore Jalleda'
> Subject: RE: Importing 3Gb File
>
>
>
> > -Original Message-
> > From: Kishore Jalleda [
I guess perfectionism in a lot of what I do is a problem I've got to deal
with. But I hate saying it one way and looking stupid when talking with
"real guru's". :-)
Thanks,
Jesse
- Original Message -
From: "Peter Lauri" <[EMAIL PROTECTED]>
To: "'Jesse'" <[EMAIL PROTECTED]>; "'MySQL
Barry, You Give Ass (en castellano basico seria Das ocote, para escribir
eso mejor no escribas nada)
Barry escribió:
Nenad Bosanac schrieb:
Hi all
I made mistake i n my last post so now
i make it true.
I have problem in MYSQL query tool.
Well i put on foreign key on delete no action
bu
Thank you very much James, i flush the privilegies and restart the mysql
service and all result fine :-)
I can access from anyhost
Aron L.
James Barros wrote:
Can this use log in from localhost successfully?
Try flushing privileges again?
If that failed, I'd drop the user and recreate?
( The
On 6/8/06, Jay Pipes <[EMAIL PROTECTED]> wrote:
Jesse wrote:
> I have been using Microsoft SQL Server for a while, and I'm now trying
> to switch all our applications over to use MySQL. Microsoft SQL Server
> is pronounced "Sequel Server". Is MySQL pronounced "My Sequel", or is
> it pronounced
On 6/8/06, murthy gandikota <[EMAIL PROTECTED]> wrote:
I've checked the dump file I created with mysqldump on a database sfg, and
it has statements like the following:
DROP VIEW IF EXISTS `advAPI`;
CREATE ALGORITHM=UNDEFINED VIEW `sfg`.`advAPI` AS select
`sfg`.`advertiser`.`advertiserid` AS
`ad
Jesse wrote:
I have been using Microsoft SQL Server for a while, and I'm now trying
to switch all our applications over to use MySQL. Microsoft SQL Server
is pronounced "Sequel Server". Is MySQL pronounced "My Sequel", or is
it pronounced "My S-Q-L"? I mean, generally speaking?
What Jimmy
I've checked the dump file I created with mysqldump on a database sfg, and it
has statements like the following:
DROP VIEW IF EXISTS `advAPI`;
CREATE ALGORITHM=UNDEFINED VIEW `sfg`.`advAPI` AS select
`sfg`.`advertiser`.`advertiserid` AS
`advertiserid`,count(`sfg`.`cust`.`custid`) AS `api` from
On 6/8/06, Ian Barnes <[EMAIL PROTECTED]> wrote:
Hi,
I am trying to import a 3.2Gb sql dump file back into my sql server (
4.1.12)
and im coming across the following error:
mysql: Out of memory (Needed 178723240 bytes)
mysql: Out of memory (Needed 178719144 bytes)
That error comes up after ab
Hi Mike,
On Jun 8, 2006, at 10:52 AM, mos wrote:
At 03:09 AM 6/8/2006, Rob Desbois wrote:
Douglas,
If you are selling a product which requires your users download
MySQL or requires you distribute it with the product, you need a
commercial licence.
$595?! Ouch indeed...it's much cheaper if
Hi
The following happened when I tried to create table. Can anyone please help?
mysql> create table sfgbackup.advEmail select * from sfg.advEmail;
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrup
Hi,
I am trying to import a 3.2Gb sql dump file back into my sql server (4.1.12)
and im coming across the following error:
mysql: Out of memory (Needed 178723240 bytes)
mysql: Out of memory (Needed 178719144 bytes)
That error comes up after about 30 minutes worth of import and I would guess
abou
Nenad Bosanac schrieb:
Hi all
I made mistake i n my last post so now
i make it true.
I have problem in MYSQL query tool.
Well i put on foreign key on delete no action
but next time when i edit that table
it said that is on delete is restrict.
Why is that ?
I use MYSQL Query tool and
At 06:49 AM 6/8/2006, Jochem van Dieten wrote:
On 6/8/06, mos wrote:
At 08:15 PM 6/7/2006, you wrote:
I believe that if you are only using MySQL for your company's
internal needs, whether from a web server or for deployment to other
company-owned locations, you don't need a commercial license.
At 03:09 AM 6/8/2006, Rob Desbois wrote:
Douglas,
If you are selling a product which requires your users download MySQL or
requires you distribute it with the product, you need a commercial licence.
$595?! Ouch indeed...it's much cheaper if you're not using InnoDB,
although obviously that's a
Hi all
I made mistake i n my last post so now
i make it true.
I have problem in MYSQL query tool.
Well i put on foreign key on delete no action
but next time when i edit that table
it said that is on delete is restrict.
Why is that ?
I use MYSQL Query tool and my database is
INNODB.
I
Hi all,
unluckily, I made a bad typing error:
Joerg Bruehe wrote:
this is in reply to various questions that have reached us after the
recent security fix, contained in MySQL 4.1.20, 4.0.22, and 5.1.11-beta:
of course, this must read 5.0.22
I apologize for any confu
yo digo My eSe Qu eLe, but spanish aren't usefull for you
for SQL Server I say "Mierda" (shit in english...)
Good by friends..
Open source for everybody...
the knowledge belongs to the humanity.. ..
Chris Sansom escribió:
At 7:38 -0500 8/6/06, Jimmy Guerrero wrote:
"The official way to pro
Taras, I'm guessing you're using version 4.1 or earlier. This is a
known issue with MySQL prior to 5. 4.1 and earlier would only use one
index per instance of a table per query, leading to poor performance
with OR statements in many cases. In other words, it uses an index to
optimize one of
I wrote:
> My problem isn't quite the same as the original poster's, but I
suspect the solution may be the same. However, I'm having trouble
> running the myisamchk command.
I'm using the Unix Terminal in Mac OS X, with MySQL 5.0.19, and it
won't let me get beyond a certain point in the
MySQL 5.0.19 running in Apache 2 on Mac OS X 10.4.6
I've been dipping my newbie toe into the murky waters of full text
searching, but not with a great deal of success. I have a complex
search set up which searches nine tables (potentially a whole bunch
more, but for the present purpose...), fi
Gerald,
- Original Message -
From: "Gerald L. Clark" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Thursday, June 08, 2006 8:40 AM
Subject: Re: correct syntax
Mike Blezien wrote:
Hello,
we need to query one of database tables that sore usernames,
Mike Blezien wrote:
Hello,
we need to query one of database tables that sore usernames, and many of
them have spaces in them that need to be removed. what would be the
correct function to identify each username column value that has a
space(s) in them?
TIA,
Mike(mickalo)Blezien
How abou
[snip]
"The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my
sequel"), but we don't mind if you pronounce it as "my sequel" or in
some
other localized way."
[/snip]
[localized way]
The best darned database since the dawn of computing.
[/localized way]
--
MySQL General Mailing List
F
Hello,
we need to query one of database tables that sore usernames, and many of them
have spaces in them that need to be removed. what would be the correct function
to identify each username column value that has a space(s) in them?
TIA,
Mike(mickalo)Blezien
--
MySQL General Mailing List
F
At 7:38 -0500 8/6/06, Jimmy Guerrero wrote:
"The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my
sequel"), but we don't mind if you pronounce it as "my sequel" or in some
other localized way."
Miss Quill?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Hi,
I am getting this error. Can anyone please help?
mysql> create table sfgbackup.advEmail select * from sfg.advEmail;
ERROR 2013 (HY000): Lost connection to MySQL server during query
Bye
[EMAIL PROTECTED] mgandikota]$ mysql -V
mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)
Thanks
Mur
Jesse wrote:
This may be a really stupid question, but I hate looking stupid if I
can avoid it. :-)
I have been using Microsoft SQL Server for a while, and I'm now trying
to switch all our applications over to use MySQL. Microsoft SQL
Server is pronounced "Sequel Server". Is MySQL pronounce
Hello,
I'll take the easy way out and quote
http://dev.mysql.com/doc/refman/5.0/en/what-is.html
"The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my
sequel"), but we don't mind if you pronounce it as "my sequel" or in some
other localized way."
Thanks,
Jimmy Guerrero
Sr Product M
[snip]
This may be a really stupid question, but I hate looking stupid if I can
avoid it. :-)
I have been using Microsoft SQL Server for a while, and I'm now trying
to
switch all our applications over to use MySQL. Microsoft SQL Server is
pronounced "Sequel Server". Is MySQL pronounced "My Se
Btw, better to ask and look stupid, then not to ask and be stupid... But
this question does not give you a stupid look, more a look of a person
seeking perfection :)
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 08, 2006 7:31 PM
To: MySQL List
Subject: How
I say: My S-Q-L
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 08, 2006 7:31 PM
To: MySQL List
Subject: How To Pronounce MySQL
This may be a really stupid question, but I hate looking stupid if I can
avoid it. :-)
I have been using Microsoft SQL Server fo
This may be a really stupid question, but I hate looking stupid if I can
avoid it. :-)
I have been using Microsoft SQL Server for a while, and I'm now trying to
switch all our applications over to use MySQL. Microsoft SQL Server is
pronounced "Sequel Server". Is MySQL pronounced "My Sequel",
[snip]
SET @sql=CONCAT('SELECT SUM(IF(SUBSTRING(updated,1,10)=CURDATE(), 1, 0)) AS ',
char(39),
CURDATE(),
CHAR(39),
' FROM tablename GROUP BY group by psDealer' );
PREPARE stmt FROM @sql;
[/snip]
Very clever Peter! Thanks for your he
On 6/8/06, mos wrote:
At 08:15 PM 6/7/2006, you wrote:
I believe that if you are only using MySQL for your company's
internal needs, whether from a web server or for deployment to other
company-owned locations, you don't need a commercial license.
Unfortunately that's not what MySQL AB licensi
Hi everyone,
Should be an easy question, but I couldn't find the answer anywhere.
Firstly, I can't figure out why the REF column shows NULL, and secondly I
don't know why the key length is 5.
I have the following db:
table l
(
aId int unsigned not null auto_increment primary key,
sId smallint
Hi,
this is in reply to various questions that have reached us after the
recent security fix, contained in MySQL 4.1.20, 4.0.22, and 5.1.11-beta:
The problem was a possible "SQL injection" risk, if the application sent
data using some multi-byte character sets, due to an incorrect parsing
Hi,
MySQL 5.1.11-beta, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/and mirror sites.
Note th
> Unfortunately that's not what MySQL AB licensing person told me. The
> license is more strict than that. If your company distributes an
> application that uses MySQL database inside the company (even inside
> the same building), and you don't give the other dept the source code
> (so it falls out
Douglas,
If you are selling a product which requires your users download MySQL or
requires you distribute it with the product, you need a commercial licence.
$595?! Ouch indeed...it's much cheaper if you're not using InnoDB, although
obviously that's a pretty major trade-off.
>
<
-- O
Hi, List!
I've recently upgraded to MySQL 4.1.20 and now I'm facing a strange
problem. Periodically my queries hang up.
mysql> show processlist;
...
| 155 | root | localhost | db | Query | 33385 | Locked | UPDATE
queue SET status='-1', processor_id=NULL |
| 156 | root | localhost | db |
57 matches
Mail list logo