At 20:32 -0500 2/21/03, Jesse Sheidlower wrote:
I recently upgraded to 4.0.10, primarily in order to be able
to change my minimum word length on the fly. But I can't seem
to set the variable! It says it's there when I "show" it, but
not when I try to change it:
---
monopoly~ $ mysql -u root -p
Ente
I recently upgraded to 4.0.10, primarily in order to be able
to change my minimum word length on the fly. But I can't seem
to set the variable! It says it's there when I "show" it, but
not when I try to change it:
---
monopoly~ $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. C
Hello,
I just joined an organization and during a migration from an old server
running MySQL MyISAM to a new server running MySQL-Max InnoDB, the data
is now taking up over 2x the space as before.
I have never converted a large db to InnoDB, always started out with it
in the first place. I expe
Hi Heikki,
Thanks for picking up on this again. After the help from
you and Mark last week, we removed ALL instances of the
lock tables from our application. We used the idea Mark
provided for getting our next sequence number without using
any locks. In the past this was the only thing we
You are less likely to run into the issue when there are no calculations
involved, but I wouldn't guarantee it. If you want to be on the safe side
when using floating pont, do not check for EQUAL to, but within a range (+/-
some small delta). As a rule of thumb, avoid floating point except for
si
Thanks a lot for your help. It works!
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Mamatha Balasubramanian"
<[EMAIL PROTECTED]>,[EMAIL PROTECTED]
Subject: Re: Can't load data using mysqlimport
Date: Fri, 21 Feb 2003 16:32:31 -0600
At 22:14 + 2/21/03, Mamatha Balasubramanian wrote:
When I
At 22:14 + 2/21/03, Mamatha Balasubramanian wrote:
When I tried loading data using the following command from command line:
mysqlimport DatabaseName tablename.txt
I got the following error:
mysqlimport: error : can't get stat of /home/./tablename.txt
However, when I used the following comma
Jungsu, Jeremy,
it can be considered as a bug that MySQL/InnoDB does not replicate the
setting
SET FOREIGN_KEY_CHECKS=0
I am working on fixing this bug in 4.0.x.
Regards,
Heikki
Innobase Oy
sql query
- Original Message -
From: ""Jeremy Tinley"" <[EMAIL PROTECTED]>
Newsgroups: mailing.
At 22:07 + 2/21/03, Ross Davis wrote:
Simply said this works:
drop table if exists detail;
create table detail
(
detail_id int not null auto_increment
, master_id int not null
, name varchar(50) not null
, primary key (detail_id)
, index master_idx(master_id)
, foreign key (master_id) refe
Ross,
- Original Message -
From: ""Ross Davis"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, February 22, 2003 12:14 AM
Subject: create fails with on delete set null
>
> Simply said this works:
> drop table if exists detail;
> create table detail
> (
> detail_i
Floating point should not be used for money or for representing any other
discrete numeric values. You will get in trouble because the floating point
value can deviate from the discrete value it is intended to represent.
Floating point introduces (small) rounding errors.
Say an account has a bala
When I tried loading data using the following command from command line:
mysqlimport DatabaseName tablename.txt
I got the following error:
mysqlimport: error : can't get stat of /home/./tablename.txt
However, when I used the following command from mysql prompt, I was able to
load the data with
Simply said this works:
drop table if exists detail;
create table detail
(
detail_id int not null auto_increment
, master_id int not null
, name varchar(50) not null
, primary key (detail_id)
, index master_idx(master_id)
, foreign key (master_id) references master (master_id) on delete cascad
Why couldn't you use float(10,2) ... just an example ... where the first
number in the parentheses is the total characters for the number and the
second number represents how many of those are right of the decimal point?)
I'm a TOTAL newbie to this stuff, I just set up my first mySql database
toda
When I try to use
mysqlimport DatabaseName tablename.txt
from command line, it doesn't work. However, if I use the following command
from mysql prompt
mysql>load data local infile "/home//tablename.txt" into table
tablename.txt
it works. Can anyone tell me how I can load data from the comma
I just finished installing Apache, php and mySql on my Windows XP machine at
home and everything seems to be running just fine!
Renee Toth
Stitchin' Up A Storm
www.stitchinupastorm.com
-Original Message-
From: Theisen, Gary [mailto:[EMAIL PROTECTED]
Sent: Friday, February 21, 2003 12:59 P
Michael,
since the 'Spamcop':
"
Recipient: <[EMAIL PROTECTED]>
Reason:Blocked - see http://spamcop.net/bl.shtml?194.251.242.203
"
has blocked email to you, I post the patch here. This patch makes InnoDB to
print a lot of diagnostic info if it notices the failure you have. It also
tries t
When you don't specify the precision for a DECIMAL column, it is assumed to
be 0. This is documented in the previously posted link.
create table pricelist (product varchar(45), cost dec(18, 2))
HTH,
Tore.
- Original Message -
From: "Bryan Koschmann - GKT" <[EMAIL PROTECTED]>
To: "gerald
Well, according to the manual decimal type is defined as
DECIMAL(M,D).
M is the width not counting sign and decimals, and D is
the number of decimal positions.
D defaults to zero, and M to 10.
try:
cost DECIMAL(10,2)
or whatever width you need.
Bryan Koschmann - GKT wrote:
My Apologies,
table na
My Apologies,
table name is pricelist with 2 colums:
create table pricelist (product varchar(45), cost dec);
then
load data infile "/home/omni/OmniPrice.csv" into table pricelist fields terminated by
',';
the datafile looks like this
Jaton Modem,15.5
Teac Floppy,7.5
Celeron 1.7,54.5
Logitech
Show us.
We have no idea how you defined your tables,
loaded your data, or structured your query.
Bryan Koschmann - GKT wrote:
Hello,
I'm creating a table where one column will be prices. How is this type
supposed to work? I tried it, loaded the data, and it cuts it off at the
decimal when I ru
Hello Group:
Please tell me, will MySQL work with a Paradox 9 client?
Regards,
David Hofer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archiv
Michael,
how do I send you email? A 'Spamcop' seems to block email to you.
Regards,
Heikki
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 10:33 PM
Subject: Re: InnoDB Cr
Michael,
your database is probably corrupt.
The normal procedure in this case is to use the my.cnf option
set-variable=innodb_force_recovery=4
and dump your tables and recreate the whole tablespace.
But, please do not do that yet. I will send you a new version of
/mysql/innobase/ibuf/ibuf0ibu
> I'm creating a table where one column will be prices. How is this type
> supposed to work? I tried it, loaded the data, and it cuts it off at the
> decimal when I run a query. How can I get this to store correctly?
Use a column type such as DECIMAL.
http://www.mysql.com/doc/en/Column_types.html
Hello,
I'm creating a table where one column will be prices. How is this type
supposed to work? I tried it, loaded the data, and it cuts it off at the
decimal when I run a query. How can I get this to store correctly?
Thanks,
Bryan
-
Thank you!
I suppose I should have tried it first, I was just assuming there was
something more to be done. Works great!
Thanks,
Bryan
On Fri, 21 Feb 2003, KH Chiu wrote:
|All you need to do is set up a MySQL user that allow the Windows box to
|access the MySQL database.
|
|Regards,
|
On 21 Feb 2003, at 14:23, Chris Corwin wrote:
> What I want to know is how do I find these "double year" records?
You can find the problem userID-dueYear combinations like this:
SELECT userID, dueYear, COUNT(*)
FROM dues
GROUP BY userID, dueYear
HAVING COUNT(*) > 1;
You can eliminat
Blah blah blah ...
Original Message
Received: (qmail 14594 invoked from network); 21 Feb 2003 19:30:26 -
Received: from unknown (HELO web.mysql.com) (213.136.49.183) by
mail.fibrespeed.net with SMTP; 21 Feb 2003 19:30:26 -
Received: (from lists@localhost) by web.mysql.co
On Thursday 20 February 2003 02:17 pm, Ajay Patel wrote:
> I have a host table where I save the platform model. The platform model
> can be saved in various ways. For example,
>
> Sun Enterprise 250 (2 x UltraSPARC 164MHz)
> Sun Enterprise 250 (2 x UltraSPARC-II 400MHz)
> Sun Enterprise 250 (2 x U
Greetings,
I'm fairly new to MySQL--so I'm not sure if what I'm asking is simple
or not.
I have a table that has "duplicate records", but not really: the dupes
are not necessarily exactly like the originals, it seems.
In any case, I have this table...
CREATE TABLE `dues` (
`id` int(11) NO
Michael T. Babcock wrote:
I've got a nice MySQL crash that happened during the night last night and I
can't seem to get it to come back online for me without --skip-innodb.
Follow-up with mysql's bug report:
MySQL support: none
Synopsis:InnoDB Crashing on Startup
Severity:critical
P
Moving the database is childs play. I'm sure other tools allow you to do
this, but when I recently started working with MySQL, I found PremiumSoft
MySQL Studio (30 day trial, $78 to purchase) from http://www.mysqlstudio.com
It is a pretty decent tool, and among other things includes a Backup/data
Hi Gary,
Where I work we use Windows2000/Apache/MySQL/PHP in development and
Linux/Apache/MySQL/PHP in production. We move any database stuff via mysqldump with no
problems what so ever. BTW, the reason we went with Linux in production is that MySQL
performance seems to be vastly superior on Li
This type of presentation must be produced by code - either your application
(i.e. in your PHP code) or by a report generator.
SQL statements always return data in a tabular format, i.e.
(Topic, Question)
1,1
1,2
1,3
1,4
2,1
2,2
...etc.
In your presentation loop (PHP), remember the "previous" va
Stéphane Pinel wrote:
I've installed 3.23.53 on a MacOS X box.
verything seems to be OK except:
when I use mysql like this :
/usr/local/bin/mysql test
..no problem.
but if I want to use any option like :
/usr/local/bin/mysql test -u
This is not valid usage.
/usr/local/bin/mysql -u roo
Joe Stump wrote:
I would assume the Win version comes with mysqldump - just
mysqldump -uuser -ppassword -hhost database. You *might* be able to copy the
data directory (someone else should chime in on this).
I known copying the data dir from Linux to Linux isn't a problem with
MyISAM tables,
I would assume the Win version comes with mysqldump - just
mysqldump -uuser -ppassword -hhost database. You *might* be able to copy the
data directory (someone else should chime in on this).
--Joe
--
Joe Stump <[EMAIL PROTECTED]>
http://www.joestump.net
"Label makers are proof God wants Sys Admi
Hi all,
I have PHP & MySQL installed on a Win2000/IIS system. I may be moving (due
to requirements at work) to a Linux/Apache system in the near future.
I'm wondering if it's a hassle, or even possible, to move the MySQL database
from the windows/IIS box to the Linux/Apache box? Any corruption,
I've installed 3.23.53 on a MacOS X box.
verything seems to be OK except:
when I use mysql like this :
/usr/local/bin/mysql test
..no problem.
but if I want to use any option like :
/usr/local/bin/mysql test -u
I get a zillion lines that start with
"./bin/mysql Ver 11.18 Distrib 3.23.53, fo
I've got a nice MySQL crash that happened during the night last night and I
can't seem to get it to come back online for me without --skip-innodb.
Version 3.23.55 compiled from sources with egcs-2.91.66. Configure at end.
I'll be trying to watch my E-mail even though its authenticated via an In
I was wondering if anybody out there knows of data cube software which makes
use of MySQL for its database/SQL engine? For a variety of reasons, we won't
use Microsoft SQL server, and Oracle is right out -- too expensive. Other
solutions (Sybase, etc.) are also unpalatable for various reasons. Our
On Friday 21 February 2003 17:53, fwellers at vcampus dot com wrote:
> I am trying to start replication from a 4.0.9 solaris master to a 4.0.8
> linux slave. I am already sucessfully replicating this master to another
> sun slave. I followed the same procedures on the linux box but no joy.
>
> The
On Thursday 20 February 2003 17:59, you wrote:
> > > C:\mysql>mysql -u b R
> > > ERROR 1044: Access denied for user: 'b@localhost' to database 'r'
> >
> > I guess no. In 3.23.55 by default lower_case_table_names=1 on Windows, so
>
> all
>
> > table and database names are converted to lower case.
>
Does anyone know when the release date for the mysql 4.0.11 version? I
was just about to rebuild everything (apache,php,etc), but if it's next
week, I'd rather wait for it.
Thanks,
Wendy
-
Before posting, please check:
http:/
Changing one local variable, IMO, shouldn't replicate.
I would much rather have a REPLICATE command that I could place before any SQL
command that causes it to replicate. This keeps local variables local, but in
the event I need to replicate a change to all my slaves without going to each
one, I
Hello,
I am trying to start replication from a 4.0.9 solaris master to a 4.0.8 linux slave.
I am already sucessfully replicating this master to another sun slave.
I followed the same procedures on the linux box but no joy.
The error log keeps saying :
030221 10:08:56 mysqld started
030221 10:08:5
Version: Mysql 4.0.10-gamma
Description: Mysql hangs and possibly can not recover from a query on an innodb
table.
How to Repeat :
drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT
Jim,
> TERMINATED BY ' ' to indicate that the fields are space deliminated
> LINES TERMINATED BY '\n' to indicate that each line is terminated by
> new lineagain I'm thinking here that
> I may need to use a '\r' instead.
As a rule of thumb, depending on where your logs come from:
a)
This is the most weird thing I have EVER tried. I went away for the weekend
and when I got home they were gone!!
Setting: Linux Redhat 7.2
Database Mysql 3.23.22
www: apache
Here is the chain of events as I recall them
thursday: I upgrade SSL on my machine
friday: I go away for the weekend
satur
I've do a whole load of log parsing/loading/analysis. And I mean A WHOLE
load :)
I found it better to use a pre parse (script/binary/program) to filter the
logs then dump out the SQL.
That way you can do some filtering and error checking on the logs before
they get near the dB.
Though for my app
Steff,
> We have our connection set to Autocommitt=1, and No table locks
> are ever explicitly being done on this table anyplace in any of our
> code modules.
in MySQL you have to do LOCK TABLES on EVERY table you use inside a LOCK
TABLES. You cannot lock just some table and use others unlocked.
> I'm trying to work out how to import Checkpoint FW1 firewall logs into
> mysql.
>
> Each line of the logs consists of 27 space deliminated fields.
> Of the 27 fields, I want to ignore about 11 of these fields when I do
> the LOAD command on the log file.
>
> I've already figured out I want to use
>Description:
When connecting to mysql from a java client the mysql process is restarted.
Connecting from the "mysql" client is no problem.
The machine is an HP rp2470 with 2*CPU and 2GB memory.
Note that I don't have gcc installed on the machine, is this a requirement?
>From the error log:
mysq
Hi,
Sorry for my english ;-)
I've made some benchs on a SUN v880 with Solaris 8 (4 cpus). I must
enable direct IO on the file system whitch support the dataspace (for
innodb tables). If not, i've problems with threads (no more instances of
mysqld). Why ? i don't know, i just notice it.
Best rega
On Wed, 19 Feb 2003 10:43:49 -0600
Frank Gates <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Earlier I asked Mark about XA and Connector/J. He said that it was
> dropped from the 3.0 releases because MySQL doesn't natively support XA,
> but when it does he will add it back in. Mark suggested that I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 20 Feb 2003 [EMAIL PROTECTED] wrote:
> # cc -V
> Compaq C V6.4-014 on Compaq Tru64 UNIX V5.1A (Rev. 1885)
> Compiler Driver V6.4-215 (sys) cc Driver
> # cxx -V
> ksh: cxx: not found
> I couldn't find standard sour
Hi Srinivas,
could it be that you're compiling a really prehistoric version?
Upgrade.
Thomas Spahni
On Fri, 21 Feb 2003, Biruda Raju Srinivasa Raju wrote:
> Hi,
>
> Here is th efollowing error i'am gertting when trying to run configure gor
> mysql
>
> configure --prefix=/usr/local/mysql --witho
On Fri, Feb 21, 2003 at 01:41:40PM -, Campbell, David wrote:
> > Can you identify any major differences in system and/or database
> > tuning? Perhaps you are using default config settings on the new
> > server, but tuned settings on the old?
>
> I have tuned MYSQL using my.cnf settings.
Hello all
I'm trying to work out how to import Checkpoint FW1 firewall logs into
mysql.
Each line of the logs consists of 27 space deliminated fields.
Of the 27 fields, I want to ignore about 11 of these fields when I do
the LOAD command on the log file.
I've already figured out I want to use:
Since you are comparing a string to a number, it probably can not use
the index.
Perhaps you should be more careful with your queries.
Gatica, Mario Alberto wrote:
I found the following error with mysql server version 3.23.52.
mysql> select snb,id_servicio from Abonados_Servicios where
snb="1144
> Can you identify any major differences in system and/or database
> tuning? Perhaps you are using default config settings on the new
> server, but tuned settings on the old?
I have tuned MYSQL using my.cnf settings.
Of the two benchmarks one comes from the tests we ran and the others are
On Thu, Feb 20, 2003 at 02:38:45PM -, Campbell, David wrote:
> MYSQL Ver 8.23 Distrib 3.23.54,
> sun-solaris2.8 [binary install]
> Sun E4500
>
> Hi we have some seriously bad benchmarks for MYSQL performance on a new
> cluster - The problem seems to be IO, but the box is doing nothing:
Can
Hi,
Here is th efollowing error i'am gertting when trying to run configure gor
mysql
configure --prefix=/usr/local/mysql --without-server
and after this i ran make, which drove me to the following error
make[2]: *** [mysql.o] Error 1
make[2]: Leaving directory
`/usr/src/redhat/SOURCES/MYsql/mysq
Basically,
I have this table, about 7 columns, with a primary key.
At the monent I have a html form and a php script that allows users to iput
into the table.
What I also want them to do it being about the select a certain record eg
via the primary key number or even by the campaign column (named
Hi Scott,
Can you please explicitly state what you want to be done otherwise it
seems that all you need to do is get the records from the database,display
them to the user and include something like a checkbox or radio button
that the user can select to show the records he wants deleted.
Then all
I am looking for a set of examples of the relevant form pages and the php
backends that connect to eitehr a YSQL or MSSQl database where the user can
select certain records and then delete or update them. I ma having a
nightmare designing one and examples always help me.
Does anyone know of any or
Hi,
I have got mysql-version.src.rpm downloaded and when i was trying to install
it
rpm --rebuild
** I got the following error***
*** Can some one drag me out of this error***
..
..
...
reating cache ./config.cache
checking host system type... i686-pc-linux-gnu
checking
hi,
Thanks for the mail.
Ive got the link from Mr.Zak Greant-MySql Company.
The link is bugs.mysql.com
But Im not getting any result for my search here!!!:-))
Regards
Sunil Gavaskar
Egor Egorov wrote:
On Thursday 20 February 2003 17:39, Sunil Gavaskar wrote:
I need to know the link for M
On Friday 21 February 2003 09:16, kk wrote:
> You may have to wait until version 4.1 if I am not mistaken.
You are not mistaken. Subselects will come in 4.1
>
> - Original Message -
> From: "geeta varu" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, February 21, 2003 4:09
On Thursday 20 February 2003 17:39, Sunil Gavaskar wrote:
> I need to know the link for Mysql Bug Database.
> I tried a lot in google...but not yet got it.
> somebody send me the link plz...
There is no bugs tracking database for MySQL.
--
For technical support contracts, goto https://ord
Steve,
> Can't connect to local MySQL server through socket '' (111)
> When I type 'mysql -u
> ddj -p' on a commandline, I can connect fine.
With mysql (the command line tool), you connect on the local host
(i.e. server and client are running on the same machine). With
MySQLGUI, you seem to
Julius,
>> When running script under Windows NT as "mysql -h host -u user
>> --password=password to
>> MySQL and send the script I have stored in "scriptfile.sql". However
> if I
>> try the same thing under Windows98 it does not work. It connects to
> the
>> server then gives a MySQL prompt ins
Not sure if this can be done with just a MYSQL Query or if it needs to be
done in conjunction with a PHP script. What I am trying to do is build a
dynamic FAQ section with PHP. Here are the two tables
Topics
===
TopicID
TopicTitle
TopicDESC
FAQS
===
FAQID
Question
Answer
Topic
Jianping Zhu wrote:
I and using mysql-jdbc to do some program.
I can insert record to my db by following code:
-
stmt.executeUpdate("insert into apidbusers values('id',
'jp','zhu','em1','jian180')");
--
Hello, everyone.
I'm using MySQL replication(Version 4.0.10)
Master and slave have FOREIGN KEY constration.
and I back up data with mysqldump.
but mysqldump does not produce table and record invalid order for FK.
So,when I restore data, I execute "SET FOREIGN_KEY_CHECKS = 0;" on master.
But,
76 matches
Mail list logo