I created my first table with integer columns and am
having trouble importing csv files with MySQL-Front.
My decimal columns work fine, but not int.
I had it set up like this:
int 10 (length) NULL NULL
The error message is kind of strange. It looks like
every single value is incorrect, but it
On Fri, May 14, 2004 at 01:40:37PM +1000, Chris Nolan wrote:
Jeremy Zawodny wrote:
I think that the problem is that it's *not* a 64 bit OS. It's just an
Intel 32bit box with 4GB of memory. And sine MySQL doesn't do PAE,
it'll never see that extra memory.
Didn't InnoDB gain PAE
On Fri, May 14, 2004 at 02:16:05PM +1000, Chris Nolan wrote:
Jeremy Zawodny wrote:
On Fri, May 14, 2004 at 04:38:56AM +0200, Lorderon wrote:
Will MyISAM support transactions in the future versions? Is it
possible?
It's possible, but I don't see it happening for quite a
Hi,
I just finished reading High Performance MySQL. Congratulations to the
authors, it's a great book and I enjoyed reading it. Would be great if
someone now started to write MySQL Internals ;-)
There are some items in the book I'd like to comment or ask questions
about. I hope the list is a
On 14 May 2004, at 4:37 am, Roy Butler wrote:
Jacob,
I'd go with Reiser on SuSE.
What about Reiser on Debian?
I'd choose SuSE since Reiser is their default filesystem and they have
been an early implementor of Reiser-related patches. If you use Linux
kernel 2.4.24 (or later) and the latest
version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)
mysql DROP DATABASE xxx;
ERROR 1217: Cannot delete or update a parent row: a foreign key
constraint fails
what is this all about? how the heck can I drop the database?
Dean Hoover
--
MySQL General Mailing List
For list archives:
On 14 May 2004, at 1:14 am, Dathan Vance Pattishall wrote:
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 4:03 PM
To: Dathan Vance Pattishall
Cc: 'Tim Cutts'; 'MySQL List'
Subject: Re: InnoDB filesystem
On Thu, May 13, 2004 at 04:51:27PM
Hello,
I am not a guru in mysql. Please somebody help me, Weather what I have
done is correct or not.
I created a replication cluster in mysql using two machines. machine A
replicates to Machine B
machine B replicates to Machine A. and heartbeat is used to give a
service ipaddress.
I tested it
Dear Sir,
As MySQL is included in this distribution. I install it together with
RedHat. Do you know what do I need to do to make it start and working? I
cannot find related document from www.mysql.com.
Thanks,
Joseph
--
MySQL General Mailing List
For list archives:
Hi.
- Original Message -
From: Hans-Peter Grimm [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 14, 2004 2:53 AM
Subject: Comments/questions on High Performance MySQL
Hi,
I just finished reading High Performance MySQL. Congratulations to the
authors, it's a great book and
Hi,
I know this may not strictly be within the remit of this mailing list
but.
I am having problems with my web host, I need to use Innodb tables, however
my web host will not allow these table types (because of the obvious extra
overhead), can anybody out there recommend/currently use a
Hi,
How can I write this query?
Insert into table1 (field1) select (a.field1) from
table2 a where a.field1 not exists (select c.field1
from table1 c)
regards
Yahoo! Messenger - Communicate
What version of MySQL are you running? The answer to your question depends
on the version.
Rhino
- Original Message -
From: A Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 14, 2004 9:00 AM
Subject: Exists
Hi,
How can I write this query?
Insert into table1 (field1)
On Fri, 14 May 2004 14:00:46 +0100 (BST)
A Z [EMAIL PROTECTED] wrote:
Hi,
How can I write this query?
Insert into table1 (field1) select (a.field1) from
table2 a where a.field1 not exists (select c.field1
from table1 c)
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html
Josh
MySQL 4.0.14
regards
--- Rhino [EMAIL PROTECTED] wrote: What version
of MySQL are you running? The answer to
your question depends
on the version.
Rhino
- Original Message -
From: A Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 14, 2004 9:00 AM
Subject:
Dean,
Seems your database has a table with foreign key constraints. You need to delete
that table first and then you will be able to drop database successfully.
Hope that helps!!!
Raza
-Original Message-
From: Dean A. Hoover [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 4:13
Is there a good tutorial on installing Mysql on one machine and having Apache on
another?
I'm thinking on the server with Apache I guess you would just compile Apache with the
mysql/php and in your php scripts just point to the hostname of the mysql server?
Making sure you can talk to port
Just a thought - but do your web pages actually display all 150K records at once? YOu
may want to change how your page requests and do
limits, and just do grabs at 100 at a time, or so. UNless of course you are
processing all 150K in one big calculation of some sort - but then, I
wouldnt do
I'm thinking on the server with Apache I guess you would just compile
Apache with the mysql/php and in your php scripts just point to the hostname
of the mysql server? Making sure you can talk to port 3306.
It's not a very big problem (loads of people have done it before you).
- Make sure php
Dathan Vance Pattishall wrote:
log-bin=/var/opt/mysql/db2-binlog
skip-innodb
log-error=/var/opt/mysql/db2-errlog
This is on a separate drive?
yes, the database is the only thing on the high speed RAID. everything
else is on the other drive (also a RAID but only RAID0 with 2 drives).
any ideas
Hi All,
MySQL 4.0.18-standard on RHEL3, 2.4.21-15.ELsmp kernel.
I have a table on one a moderate traffic site, and yesterday I had my client
notify me that some of the pages were not working. Note that most of the
page content is stored in a table called pageContent.
Now, about half the pages
When I try to import my csv file in MySQL-Front, it
appears to get hung up on every integer - or perhaps
it's just every integer in the first integer field.
When it cites an error, it only lists the numerals
after the comma. For example, it says 249 for this
sample from my csv file:
In the last episode (May 14), David Blomstrom said:
When I try to import my csv file in MySQL-Front, it appears to get
hung up on every integer - or perhaps it's just every integer in the
first integer field.
When it cites an error, it only lists the numerals after the comma.
For example,
At 8:34 -0700 5/14/04, David Blomstrom wrote:
When I try to import my csv file in MySQL-Front, it
appears to get hung up on every integer - or perhaps
it's just every integer in the first integer field.
When it cites an error, it only lists the numerals
after the comma. For example, it says 249
I have database Zope
I run following command and get error
myql grant all on Zope.* to [EMAIL PROTECTED];
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'Zope'
mysql
As a consequece I try to access Zope from a web, it also shows me the
error.
how can i fix this problem?
All,
I am looking for a stepwise installation of mysql-3.23.58 on Redhat 9.
and have a hard time finding it on the MySql web site. Could someone
e-mail me the steps, please.
There should also be a section on installing databases, in order to make
sure that MySql is running and is operational
David Blomstrom [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
When I try to import my csv file in MySQL-Front, it
appears to get hung up on every integer - or perhaps
it's just every integer in the first integer field.
When it cites an error, it only lists the numerals
after the
Sorry - haven't had a chance to respond till now.
So restore == apply-log, but one works on any computer, and the
other
only works on the computer that it's node locked to.
--apply-log works also in any computer regardless of the hostname or the
license expiration date.
I'm running
Hi All,
I'm reading High Performance MySQL. In my humble opinion is an very good
book.
Congratulations to the authors.
In the chapter Load Balancing and High Availability is cited the Tony
Bourke's book Server Load Balancing.
Someone read it? is one good reference font?
I need study this
Dear All,
Hello
is it advised not to do an upgrade on a Mysql 4.x to latest MySQL?
What if the 4.x version is installed at installation time of say, RHL8, can an upgrade
then be done afterwards to latest version?
Just looking for any recommendations, etc
Thanks in advance!~
Carlos
Joshua Beall wrote:
Hi All,
MySQL 4.0.18-standard on RHEL3, 2.4.21-15.ELsmp kernel.
I have a table on one a moderate traffic site, and yesterday I had my client
notify me that some of the pages were not working. Note that most of the
page content is stored in a table called pageContent.
Now,
--- Joshua Beall [EMAIL PROTECTED] wrote:
AFAIK 112,249 is not an integer. It is a string.
If you need to have the
commas, you need to store it as a string.
I haven't got to strings yet. The table I'm making is
for display purposes, so I want visitors to be able to
see 10,212, rather than
Is there a SELECT statement, if I have a table with 50 columns, to select
every column EXCEPT the last one? Can I do this without typing the name of
all 49 columns?
If so, then what if I want to exclude the last TWO columns?
Thanks,
John
--
MySQL General Mailing List
For list archives:
At 10:17 -0700 5/14/04, David Blomstrom wrote:
--- Joshua Beall [EMAIL PROTECTED] wrote:
AFAIK 112,249 is not an integer. It is a string.
If you need to have the
commas, you need to store it as a string.
I haven't got to strings yet. The table I'm making is
for display purposes, so I want
David Blomstrom wrote
--- Joshua Beall [EMAIL PROTECTED] wrote:
AFAIK 112,249 is not an integer. It is a string.
If you need to have the
commas, you need to store it as a string.
I haven't got to strings yet. The table I'm making is
for display purposes, so I want visitors to be able to
see
Hi list,
does MySQL accept a SELECT inside another SELECT, like this:
SELECT t.Trial_ID_Code AS Trial,
CONCAT(s.Site_Primary_Investigator_Title, ,
s.Site_Primary_Investigator_Last_Name) AS 'Investigator',
CONCAT(sc.Site_ID_Number, -, s.Site_ID_Code, -, sc.Scanner_ID_Number)
AS Site,
There's a quick install guide on the MySQL site, which has most of what
you've listed:
http://dev.mysql.com/doc/mysql/en/Quick_install.html
The INSTALL-SOURCE doc which comes in the tarball covers the process in
great detail.
There may be others, those are two I've used.
Kamal Ahmed wrote:
I am evaluating mysql for use at our organization. One thing I have not
been able to determine from the documentation is -- once I've taken a backup
via mysqlhotcopy, how do I restore the database from that backup when
necessary?
William K. Jones
Chief, Database Systems Branch, DCSS, CIT
[EMAIL
You shutdown the server and copy the files back.
Jones, William (NIH/CIT) wrote:
I am evaluating mysql for use at our organization. One thing I have not
been able to determine from the documentation is -- once I've taken a backup
via mysqlhotcopy, how do I restore the database from that backup
--- PARTHA DUTTA, BLOOMBERG/ 499 PARK
[EMAIL PROTECTED] wrote:
Hello all, I would like to find out if anyone has
implemented an architecture
where a hardware load balancer is placed in front of
some MySQL servers in a
Multi-master replication scheme. I want to use the
load balancer more
--- Sasha Pachev [EMAIL PROTECTED] wrote:
Very possibly a bug. INNODB deadlocks itself during
the operation, then detects
the deadlock and aborts the transaction. If this is
indeed a bug, I am sure
Heikki would like to fix it ASAP.
There actually was a create index that was being
executed
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
In the last episode (May 14), Jim said:
What are some issues relating to using OPTIMIZE TABLE and
replication? Does running OPTIMIZE TABLE on a master DB cause the
optimizations to be passed on to the slaves?
Yes, unless you add the LOCAL flag to optimize.
In the last episode (May 14), Dan Nelson said:
In the last episode (May 14), Jim said:
What are some issues relating to using OPTIMIZE TABLE and
replication? Does running OPTIMIZE TABLE on a master DB cause the
optimizations to be passed on to the slaves?
Yes, unless you add the LOCAL
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
It does not. The command doesn't replicate.
--
Jeremy D.
Is there a way to set this dynamically?
Thanks,
Lou
Actually, if you are using 4.1.1 optimize table does get passed to the
slave. This is from the 4.1.1 change log.
ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are now
stored in the binary log and thus replicated to slaves. This logging does
not occur if the optional
Jeremy Zawodny wrote:
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
It does not. The command doesn't
At 15:57 -0400 5/14/04, Lou Olsten wrote:
Is there a way to set this dynamically?
The associated system variable is table_type, not default_table_type.
SET table_type = xxx;
SET SESSION table_type = xxx;
SET GLOBAL table_type = xxx;
Thanks,
Lou
--
Paul DuBois, MySQL Documentation Team
Madison,
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
Actually, if you are using 4.1.1 optimize table does get passed to the
slave. This is from the 4.1.1 change log.
ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are now
stored in the binary log and thus
In the last episode (May 14), Jeremy Zawodny said:
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
Actually, if you are using 4.1.1 optimize table does get passed to
the slave. This is from the 4.1.1 change log.
ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH
It surprised me at first, but then I was actually happy about it.
Donny
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 4:26 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]; 'Jim'
Subject: Re: OPTIMIZE TABLE and mySQL replication
On Fri,
Yes.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Friday, May 14, 2004 4:26 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]; 'Jim'
Subject: Re: OPTIMIZE TABLE and mySQL replication
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
Actually,
--- John Mistler [EMAIL PROTECTED] wrote:
Is there a SELECT statement, if I have a table with
50 columns, to select
every column EXCEPT the last one? Can I do this
without typing the name of
all 49 columns?
If so, then what if I want to exclude the last TWO
columns?
Thanks,
John
Hmmm. The reason I asked was that the last column in the table is TEXT, and
might contain up to 5000 text characters. I'm trying to make the query as
efficient as possible, and I don't know if that much data will make a
noticeable speed difference?
Thanks,
John
on 5/14/04 2:31 PM, Justin
On Fri, May 14, 2004 at 04:29:29PM -0500, Dan Nelson wrote:
In the last episode (May 14), Jeremy Zawodny said:
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
Actually, if you are using 4.1.1 optimize table does get passed to
the slave. This is from the 4.1.1 change log.
Reiser is good for lots of small files. ext3 would is better for
large ones. At least that's what I get from the benchmark data that I've
seen posted in various places.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Wed, 12 May 2004, Roy Butler wrote:
Jacob,
I'd
John Mistler wrote:
Hmmm. The reason I asked was that the last column in the table is TEXT, and
might contain up to 5000 text characters. I'm trying to make the query as
efficient as possible, and I don't know if that much data will make a
noticeable speed difference?
Thanks,
John
on 5/14/04
--- Randy Clamons [EMAIL PROTECTED] wrote:
Primary key names start with pk_, unique indexes
start with uk_, other indexes start wiht ix_.
That's a good tip. What if just named the primary key
pk and the foreign key fk. Would you run into trouble
if you're working with two or three tables, and
Jon,
an update statement is supposed to return the # of rows updated, so the
client must wait for a response, which means the client will wait if you
low_priority your updates. But if they are insert delayed then the
client gets a return immediately. This behavior limits the usefullness
of low
I'm trying to learn how to join tables, but I'm doing
something wrong. I've found lots of examples that look
easy, but something isn't clicking.
I think part of the confusion stems from the dynamic
tables I was creating with Dreamweaver. I thought they
were a necessary part of the equation, when
61 matches
Mail list logo