On Thu, 26 Sep 2002, Bence Szabo wrote:
> Are there any experiences with it? (Our planned system about 5M records
> and intensive web based queryes, I don't know exactly estimated how many
> concurrent sessions)
Bence,
that's where MySQL shines. But beware of the file size limit inherent to
you
I load a table whit the query:
LOAD DATA INFILE 'a.txt' INTO TABLE table FIELDS TERMINATED BY '\t' LINES
TERMINATED BY '\n';
the file:
211ppp222
222ooo333uuuo
and more
the problem is, the last field in the table is '|' or 'uuuo|'
the final ('\n'
Hello,
I'm new to MySQL. I've been able to query the database via PHP and display
it within a html page. I would like to out put the results to a flat file
tab delimited instead of onto a new page.
Thanks for any help.
DBA / Unix Administrator
Patrick Fowler
Wynit, Inc.
6847 Ellicott Drive
Ea
Hi,
This is my first mail to mysql list, so sorry if it is a well known (answered)
question. I read lot of articles, lists before and I can not decide what
about the stability of mysql when I use tables with large numers of records
and many sessions?
Are there any experiences with it? (Our plann
ok guys
i ve actually done it fo myslf ... :'(
mysql s all screwedup ...
i reinstalled it last night and myadmin too ... now ...
ive created two users and databases n ...
wolla
i cnt even login ... :'(
i feel like banging my head against da walls
vat in earth is with this thi
msg Mittwoch, 25. September 2002 21:07 by Pete Harlan:
> > If not, i know that ext3 can have ten of thousands files in a directory.
> > But commande like 'ls' will become slower and slower ...
> > Is this also slowing mysql ?
>
> I believe it would have to. There is a patch somewhere (I don't kno
In also belive that MySQL is very good in a single environ ment. You can try
out some very good GUI front end clients like MySQL-Front and SQLyog. Since
MySQL-Front has been discontinued, SQLyog is a very good option.
Insane
- Original Message -
From: "Gerben Gieling" <[EMAIL PROTECTED]>
Hi Phobe,
As the MyIsam tablehandler stored the tables as files on the file system the OS
specific case sensitivety for file names comes into place here.
On a Unix system you have to use the correct cases for the table names, on a Win*
System the cases of the table names does not matter.
The s
Dear Joseph,
Thank you for your quick reply. The MERGE function may do the trick but then
I would have to type the name of the 50 tables ! The idea was to avoid
having to type evey single table. Also, what will happen if new tables are
created ? I'll have to re-merge them all ?
P.L.
>From: J
When I am trying to install mysql-shared-4.0.3 on a redhat 6.2 system with kernel
2.2.19, i get following dependenci problem I need glibc 2.2, i need the mysql-shared
in ordre to get the php-mysql modul to work.
How can i fix this problem?
/Klaus
-
I thought you might be interested in a bug that I traced to my having used
the wrong case for the table name. This had me baffled for a while because
the behaviour was not consistent, sometimes the error was duplicate key,
other times wrong column count
CORRECT BEHAVIOR =
Pascale Lunal wrote:
> Oops: sorry if this message appears twice but my connection broke down
> just when I clicked 'send'.
>
> Hello,
>
> I am currently writing a search query in PHP to:
>
> 1. search in MySQL database (not in one table but in all the tables of
> the whole database),
>
> 2.
Hi,
According to InnoDB's page, the largest innodb database is currently a
bit over 1TB. This is in Mytrix's database (Mytrix provide site
tracking services for your website, see www.mytrix.com).
With a default page size of 16KB, you get a theoretical maximum database
size of about 60 TB. You
Oops: sorry if this message appears twice but my connection broke down just
when I clicked 'send'.
Hello,
I am currently writing a search query in PHP to:
1. search in MySQL database (not in one table but in all the tables of the
whole database),
2. search when more than one searchterm is en
>Description:
MySQL kills itself several times a day due to the following assertion
failure :
InnoDB: Assertion failure in thread in file ha_innodb.cc line 2014
>How-To-Repeat:
-
>Fix:
-
>Submitter-Id:
>Originator:Jedi/Sector One
>Organization: 42 Networks
>MySQL support: none
>Syno
Hello all,
This discussion appeared recently:
>| Can I use MySQL to store pictures as part of a record?
>| Should I just try to store the name of the picture?
>Yep but it depends on the size of the pictures.
Let me describe a scenario we have here in genomics research, which is
extremely deman
Hi!
It sounds like a simple UNION ALL thing, but I think I don'tunderstand well
what your problem is. Can you give an example?
Daniel
At 12:59 2002.09.26. +0800, you wrote:
>Dear all
>i had two tables, tableA & Table B.
>I want to create a permanent table call Table C which the first two field
Dyego,
the user should submit a repeatable test case if he suspects that a
transaction only partially went to the database. Has he checked that the
return value from his SQL statements was ok, and none was rolled back?
About the reliability problems he had with Windows 2000: he could try
upgradi
I have installed the php-mysql package and can now connect to the database.
There is however another error which I do not undertand.
Warning: No MySQL-Link resource supplied in
/usr/local/www/vantweststamps/databaselogin.php on line 15
Connected successfully
,Line 15 is
mysql_close();
If I the
Iod,
- Original Message -
From: ""iod iod"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 8:14 AM
Subject: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using
>
> We have been using InnoDB with MySQL (MySQL-Max-3.23.52-1) for transacti
I have tried this but some queries that run on Access failed to run on
MySQL. I had this problem with INNER JOIN
Thanks
Emery
- Original Message -
From: "Gerben Gieling" <[EMAIL PROTECTED]>
To: "Michael T. Babcock" <[EMAIL PROTECTED]>; "David Lloyd"
<[EMAIL PROTECTED]>
Cc: "Adam Parker"
Juha,
select dep.Ref, dep.ActionDate as Departure, arr.ActionDate as Arrival,
dlv.ActionDate as Delivery
from
Table1 dep left join Table1 arr on (dep.Ref = arr.Ref and arr.Timestamp =
'ARR')
left join Table1 dlv on (dep.Ref = dlv.Ref and
dlv.Timestamp = 'DLV')
where
Do anyone has a idea how to Insert (create SQLQuery) from onetable to an
other table as
decripted under:
Here is the orginal Table:
Table1:
Ref | Timestamp | ActionDate
---+-+
001 | DEP + 2002/01/02
hi List,
I am trying to do a master-slave replication on mysql-3.23.42. My master is
sitting on a FreeBSD machine and the slave is running in a Red Hat Linux 7.1
machine.
>From the log, the master-slave connection is okay, but the slave seems
unable to read the binary content from master. My Serv
Hope this helps u
CREATE TABLE photo( name VARCHAR(50) NOT NULL, pic MEDIUMBLOB, picname
varchar(50),
INDEX(name),
FOREIGN KEY(name)
REFERENCES person(name) ON DELETE CASCADE
) TYPE = INNODB ;
INSERT INTO photo(name , pic, picname) values( 'raman',
load_file('e:/mysql/images/
The combination of Access front end with MySQL or PostgreSQL works
great. However there is a disadvantage in using Microsoft Office
applications. If you use Visual Basic code to program the behaviour of
your front end (You probably will). The front end will run great until
the next major update of
101 - 126 of 126 matches
Mail list logo
