Hello,
I am doing packet capturing and I want to store the packet headers and
payload in a MySQL database. I have decided the datatypes for all the fields
except for the packet "payload". I want to know if I can store the payload
particulars in a file and then point that file to the table fi
Philippe Poelvoorde wrote:
Gleb Paharenko wrote:
Hello.
What transaction isolation level do you use? By the
way - there's a fresh bug related to SELECT ... FOR UPDATE:
http://bugs.mysql.com/bug.php?id=9512
tx_isolation is set to : REPEATABLE-READ (which is the default)
I've stripped everything u
Heikki,
See inline.
Heikki Tuuri wrote:
James,
- Original Message - From: "James Green"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, April 04, 2005 1:28 PM
Subject: Innodb: Alter table progress
Hi,
Is there any way of checking the progress of an "ALTER TABLE" que
James,
- Original Message -
From: "James Green" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, April 05, 2005 11:06 AM
Subject: Re: Innodb: Alter table progress
Heikki,
See inline.
Heikki Tuuri wrote:
James,
- Original Message - From: "James Green"
<[EMAIL
Rhino, I've answered only to you and not to the list too, because I've already
posted the same words answering to another mailing list user :-)
My first problem is that the txt files I need to import have a fix structure
without separators. After the field of 595 characters, there is another
field
Hello,
I'm using MySQL 4.0.20 on Linux and I am experiencing some problems with a
query result.
I have the following table structure:
mysql> desc gen_Lloyds_vessel;
+-+--+--+-+-++
| Field | Type | Null | Key | Def
Hello.
Among other things check that you correctly process lock timeouts.
>
> Well, I'm sure it's a bug hidden somewhere in my apps, i've check with
> another connexion and it worked ;)
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spon
Not weird at all...
As you can see it returnet all rows where "iImo" equals 0... that is becuase
of the CAST applied...
iImo is int(11) thus MySQL is casting 'FOOBAR' and the result is 0.
Try:
mysql> SELECT CAST('FOOBAR' AS UNSIGNED);
MySQL will yell:
+--+
| C
Mattias Håkansson wrote:
Hello,
I'm using MySQL 4.0.20 on Linux and I am experiencing some problems with a
query result.
I have the following table structure:
mysql> desc gen_Lloyds_vessel;
+-+--+--+-+-++
| Field | Type
Yes, It's pretty obvious now. Thank you all for the help.
Mattias Håkansson
- Original Message -
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 05, 2005 12:15 PM
Subject: Re: Weird Query Result
> Not weird at all...
> As you can see it returnet all rows where "iImo
phpMyAdmin 2.5.4 + MySQL 4.17 + PHP 5
When the weclome picture is being shown, i try to login with root ,but error
message is occurred.
That is as follow:
#1251 - Client does not support authentication protocol requested by server;
consider upgrading MySQL client
Thanks for all and need your hel
> That is as follow:
> #1251 - Client does not support authentication protocol requested by server;
> consider upgrading MySQL client
>
Hi Zhu, have a look at
http://dev.mysql.com/doc/mysql/en/old-client.html
Basically, you should keep on using the pre 4.1 authentication
mechanism if you have to
Hello all,
Following my previous mail about FULL OUTER JOIN, i tried to deal with
UNION but i get some weird problems.
I've created two temporary table, here their content :
mysql> select * from T3;
+-+-+--+
| ver_ref | server | ver_real |
+-+-
Hello all,
Following my previous mail about FULL OUTER JOIN, i tried to deal with
UNION but i get some weird problems.
I've created two temporary table, here their content :
mysql> select * from T3;
+-+-+--+
| ver_ref | server | ver_real |
+-+-
Hello.
What is the output of:
# /usr/local/mysql/bin/mysqlbinlog --database=backuptest
--start-datetime="2005-03-30 15:00:00" /data/mysql/logs/dbne1-bin.173
seth <[EMAIL PROTECTED]> wrote:
> hello,
>
> I'm trying to restore a table from a full back up and then a binlog.
> thi
Hello.
I think, you should recreate an InnoDB tablespace on a new
server and import the data exported with mysqldump. If you
remove the database directory and InnoDB files, on startup
server recreates InnoDB tablespace and then you should be able
to import the data from the old server.
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
>
>>dear sir,
>>nice to meet you.
>>now i have installed the MySQL-Server&Client(4[1].0.15).but i cannot
>>connect mysql server when i make a change.
>>what is the wrong with what i do?l
>>can i get yo
Hello.
I can't find a similar bug in the bug database (if you could search
more, please do it). As far as I know the OpenBSD-current has MySQL 4.0.24
in it's ports tree. Upgrading most probably will solve the problems.
Frank Bax <[EMAIL PROTECTED]> wrote:
> Cannot execute query.
>
I wonder how somebody can approve such a query and tables.
1) There is no indexes, thats the main reason for the time and cpu consuming.
At least,
the fields used in the joins MUST be indexed.
2) varchar(255) on ALL fields? That's unlikely, in-cre-di-ble. Right type for
the right
data, int for
Not sure what you are asking. MySQL can store actual files in a blob
field, but it sounds like you only want to store a reference to a file.
The only way to store a reference to a file is to store it's path name.
If you want to store the file on a different machine, you would need to
store more
Hello everybody
I'm designing a database for our new Application and have some
problems with the following:
We have a table Jobs in which we store all kind of Jobs.
Looks like this:
tbl_jobs
-
job_id, integer,
name, varchar,
description, varchar
easy so far :)
The problem is we also
j llarens wrote:
2) varchar(255) on ALL fields? That's unlikely, in-cre-di-ble. Right type for the right
data, int for numbers, float for money, char for fixed string, and certainly NOT 255 for
lenght! If its necesary such amount of characters, TEXT or BLOB must be used, but only if
it is necesary.
Hi,
> I'm designing a database for our new Application and have some
> problems with the following:
>
> We have a table Jobs in which we store all kind of Jobs.
> Looks like this:
>
> tbl_jobs
> -
> job_id, integer,
> name, varchar,
> description, varchar
>
> easy so far :)
> The probl
Hello,
I recall this problem again. No answer still. If I need to talk to
other list(probably internals) just let me know.
-
I would like to describe the following problem and get an opinion
from list members.
I have simp
Just turn your subquery into another join
SELECT C2.City, N.Distance
FROM Cities C
INNER JOIN Nbc N ON C.CityID = N.PrimaryCityID
INNER JOIN Cities C2 ON C2.cityID = N.CityID
WHERE C.City = 'Los Angeles'
AND N.Distance <20
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
G
I do not recommend trying to install a new language if you don't need to.
Windows Scripting Host, DAO, and ADO are already installed on most windows
machines and are the "native" way of dealing with tasks that the other
scripting languages (like PERL) take care of on other platforms.
My alterna
On Apr 5, 2005 3:15 PM, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi,
>
> > I'm designing a database for our new Application and have some
> > problems with the following:
> >
> > We have a table Jobs in which we store all kind of Jobs.
> > Looks like this:
> >
> > tbl_jobs
> > -
> >
Chris <[EMAIL PROTECTED]> wrote on 04/02/2005 12:35:57 AM:
> Tom Crimmins wrote:
>
> >On Friday, April 01, 2005 19:27, Chris wrote:
> >
> >
> >
> >>Hi all,
> >>
> >>I've got 3 or 4 queries UNIONed together in a single query. I want to
> >>GROUP the UNIONed result, by one field, and SUM() another
Hello,
Am I gaining anything by using a timestamp instead of using dateTime and
calling now(), for example, increased performance, better indexing, etc.
I guess another way to ask this is does the MySQL internals handle a
timestamp more efficiently than a dateTime.
Thanks
Michael
--
MySQL Gene
Here is my novice question:
I need to find duplicates in "Batch" category when I issued this query:
SELECT * FROM QA WHERE Batch=439584414;
Result:
90577
1 26615334JulieAnt25 5 5 439584414
2004-10-03 00:00:00 2004-10-03
00:00:000 905
At 04:27 PM 4/4/05, Frank Bax wrote:
Cannot execute query.
Can't find file: './donor/list_lst.frm' (errno: 9)
- -
I got the same error last week on a different table. Today I notice that
there is a table in another database on same system producing the same
error. I attempted to ac
Hi Scott,
Here is my novice question:
I need to find duplicates in "Batch" category when I issued this query:
SELECT * FROM QA WHERE Batch=439584414;
Result:
90577
1 26615334JulieAnt25 5 5 439584414
2004-10-03 00:00:00 2004-10-03
00:00:000
IMO, dateTime doesn't parse now() the same way that timeStamp does. If you
use now() in a dateTime field, I have found that it doesn't always write the
time to the record, while using now() with the timestamp always does.
As far as your other questions, the indexing and increased performance, I
ha
Hi
Can somebody help me to figure out why this deadlock happen?
Thanks
=
050405 9:12:17 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 50 seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reser
From: "DePhillips, Michael P"
> Am I gaining anything by using a timestamp instead of using dateTime and
> calling now(), for example, increased performance, better indexing, etc.
> I guess another way to ask this is does the MySQL internals handle a
> timestamp more efficiently than a dateTime.
I
> > > I'm designing a database for our new Application and have some
> > > problems with the following:
> > >
> > > We have a table Jobs in which we store all kind of Jobs.
> > > Looks like this:
> > >
> > > tbl_jobs
> > > -
> > > job_id, integer,
> > > name, varchar,
> > > description
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "Mysql"
Sent: Tuesday, April 05, 2005 10:05 AM
Subject: Duplicated records
> Here is my novice question:
> I need to find duplicates in "Batch" category when I issued this query:
>
> SELECT * FROM QA WHERE Batch=439584414;
On Apr 5, 2005, at 6:41 AM, Nico Alberti wrote:
That is as follow:
#1251 - Client does not support authentication protocol requested by
server;
consider upgrading MySQL client
Hi Zhu, have a look at
http://dev.mysql.com/doc/mysql/en/old-client.html
Basically, you should keep on using the pre 4.1
news <[EMAIL PROTECTED]> wrote on 04/04/2005 12:59:53 PM:
> Greetings everyone,
>
> I haven't been able to find any piece of information on temporal
databases
> and MySQL except the code from the TAU Project which seems to be
> experimental at best. Not even discussions on the mailing lists or o
[EMAIL PROTECTED] wrote on 04/04/2005 01:14:23 PM:
> Hello all,
>
> mysql 4.0.20
>
> I'd like to know how one can do a "full outer join".
> I've read some workaround with a UNION, but i need the join only on a
few
> columns, while UNION will make double tuple if one column is not the
same.
>
Sorry for the confusion. I don't mean a duplicated records, but to
find duplicated Batch where two different operators worked on a single
batch (one started off, then another one to finish the batch) and a
single reviewer to review a batch. I need a list that lists duplicated
Batches with differen
My responses blended in
Jason Johnson <[EMAIL PROTECTED]> wrote on 04/04/2005 02:19:12 PM:
> The premise of the query is to return required continuing education
> hours for the entire membership of the organization. Limited to one
> member when providing a membership ID.
>
> The query is a
I'm not sure what may have changed, but what you are searching on is
really a partial value of a field. You wouldn't normally think of \r\n
as characters, but they are are, just like a or b.
Whenever you are searching on a partial value, you should use LIKE and
%.
SELECT * FROM table_name WH
Hello Brent,
Thanks for reply.
But I would like to know if we have desired behavior in latest
versions of MySQL or it is a bug.
--
Best regards,
Andrewmailto:[EMAIL PROTECTED]
Tuesday, April 5, 2005, 11:46:57 AM, you wrote:
BB> I'm not sure what may ha
I do the following;
1. I kill the mysqld-process on the server.
2. I start mysqld_safe by typing; "mysqld_safe --skip-grant-tables &"
3. Logged in as root, I type this shell> mysqladmin -u root
flush-privileges password "my_wanted_password"
4. I try to login as root to the MySQL-server, by
- Original Message -
From: "Olivier Salzgeber" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 05, 2005 9:01 AM
Subject: problem with table design
> Hello everybody
> I'm designing a database for our new Application and have some
> problems with the following:
>
> We have a table Jobs in
Andrew,
you can tell the answer from Brent's info (not obvious in your mail, as
you put your new text above the quote):
Am Di, den 05.04.2005 schrieb Andrew um 18:05:
> Hello Brent,
>
>Thanks for reply.
>
>But I would like to know if we have desired behavior in latest
>versions
I may add that I also tried;
1. I kill the mysqld-process on the server.
2. I start mysqld_safe by typing; "mysqld_safe --skip-grant-tables &"
3. Connect to the mysqld-server by doing; "shell> mysql -u root"
4. Inside, I write; UPDATE mysql.user SET
Password=PASSWORD('my_new_password') WHERE
Oh, that's an entirely different problem than the one I understood from your
original question.
Your new explanation is clearer but I'm still not sure I follow all of it.
The formatting/wrapping of the example makes things a bit fuzzy too. Am I
right in assuming that on the first row of the result
Well, to be more specific, I would like to list *ALL* duplicated Batch
rather than to count them.
SELECT ID, Batch, KeyDate, OperatorID, QAID, NTID
FROM QA
WHERE Batch in (duplicates);
On Apr 5, 2005 12:43 PM, Rhino <[EMAIL PROTECTED]> wrote:
> Oh, that's an entirely different problem than the on
Hi Shawn,
I really meant temporal and not temporary. Temporal as in TSQL2. Databases
that on the one hand accumulate all changes to data over time along with
accurate time information and on the other hand provide varying degrees of
transparency in querying this data based on the theory of instant
Scott,
To find dupe batch values
SELECT batch, COUNT(batch) AS Cnt
FROM qa
GROUP BY batch
HAVING Cnt > 1;
Peter Brawley
http://www.artfulsoftware.com
-
Scott Hamm wrote:
Sorry for the confusion. I don't mean a duplicated records, but to
find duplicated Batch where two different op
Hi,
I've got a dump file from my main DB (MySQL 4.1.10a), when I load it
with "source backup.sql" I can see some warnings around. Is there any
way to log those warnings, or to stop on warnings ? (show warnings
only show warnings for the _last_ query if there is any).
Thanks for your help
--
MySQ
Yes, I understand that. But, unless you have a version of MySQL that
supports subqueries (V4.1 or later), it's a two step process. The first
query I gave you will identify all of the batches that are duplicates by
their batch number:
select Batch, count(*) as count
from QA
group by Batch
having co
Julian Pellico <[EMAIL PROTECTED]> wrote on 04/04/2005 06:38:57 PM:
> Hello,
>
> I'm using MyISAM tables in mysql and in order to make a certain
> operation appear atomic, I need to insert records into 2 tables in a
> certain order. In particular, in one of the tables is a key that maps
> to mult
Hello
I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a
using precomiled Debian packages on Debian Woody although I read the
comments regarding upgrading on dev.mysql.com.
After starting the new server and running "mysqlcheck -r -v -A", I
experienced the following problems o
It has been a rough day today. I am using mysql with coldfusion. Something
somehwere on my site is causing mysql to take up 100% of the cpu. This causes
coldfusion to lock. Is there any sort of query log I can look at to see what
queries have run in, say, the last hour? If I see what queri
Could it be that you are using a pre-4.1 client with a post-4.1 server? Do
exactly what you did before except try this:
UPDATE mysql.user SET Password=OLD_PASSWORD('my_new_password') WHERE
User='root'
You will need to FLUSH PRIVILEGES again. If this doesn't work at least we
have eliminated ano
Use the general query log.
http://dev.mysql.com/doc/mysql/en/query-log.html
Thanks,
Brian Stanton
Systems Administrator, Belo Interactive
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 2:11 PM
To: mysql@lists.mysql.com
Subject: somethi
On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Could it be that you are using a pre-4.1 client with a post-4.1 server? Do
> exactly what you did before except try this:
>
> UPDATE mysql.user SET
> Password=OLD_PASSWORD('my_new_password') WHERE User='root'
Did the abov
X y <[EMAIL PROTECTED]> wrote on 04/05/2005 03:51:02 PM:
> On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > Could it be that you are using a pre-4.1 client with a post-4.1
server? Do
> > exactly what you did before except try this:
> >
> > UPDATE mysql.user SET
> >
Mister Jack <[EMAIL PROTECTED]> wrote on 04/05/2005 01:38:00 PM:
> Hi,
>
> I've got a dump file from my main DB (MySQL 4.1.10a), when I load it
> with "source backup.sql" I can see some warnings around. Is there any
> way to log those warnings, or to stop on warnings ? (show warnings
> only show
On Apr 5, 2005 10:49 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> X y <[EMAIL PROTECTED]> wrote on 04/05/2005 03:51:02 PM:
>
>
> > On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > >
> > > Could it be that you are using a pre-4.1 client with a post-4.1 server?
I wrote; mysql> UPDATE mysql.user SET
Password=OLD_PASSWORD('the_new_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> \quit
Then; shell> mysql -u root -p
Enter password: the_new_password
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Is this 'caus
Classification: UNCLASSIFIED
Caveats: NONE
All,
I'm getting the not-so-mysterious error in my slave log file as follows:
[ERROR] Error reading packet from server: log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master
(server_errno=1236)
[ERROR] Got fatal error 1236
Here's a question for you guys: is it possible to have a replicated
table of type MERGE?
Scenario:
Server: WWW1
Table: A.local_table (MASTER)
replicates to:
Server: MEMBERS
Table: B.www1 (SLAVE)
and
Server: WWW2
Table: A.local_table (MASTER)
replicates to:
Server: MEMBERS
Table: B.www2 (SLAVE)
wh
Hi...
I need to increase my max_connection variable on mysql DB.
Her value now is 100... I must to increase to 500.
(Mysql 3.23.49 on Red Hat 8. My server is a IBM Pentium 4, 1.6 Ghz, HD 40G, 1G
of RAM)
What do I have to do for balance my DB and my server in this case?
Which others elements or
I have a dozen, very large CSV files that I would like to put into a
MySQL database, with 1 table per file. Does anyone know of a PHP (or
other) script that can read the first few lines of a CSV file and
create an appropriate CREATE TABLE statement based on the data it
finds? (Even better, it
I have a situation where FedEx will be sending me back a base64 string, or a
XML based base 64 map, the language this site was coded in, or will be, has
no base 64 tools. My tests in writing my own decoder show it to be too slow
to handle the decode.
Can I shove the base64 string into mysql as a
I have loaded a large *.csv spreadsheet into mysql and one number, the
grand total, changes from 16996941 on the Excel spreadsheet to 8388607 in
the mysql database. The numbers surrounding this number are correct at
all stages. I have reloaded, checked formatting and done various other
th
You could use the CSV table type:
http://dev.mysql.com/doc/mysql/en/csv-storage-engine.html
Or use the LOAD DATA INFILE to import all data:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
--rengolin
--- Richard Miller <[EMAIL PROTECTED]> wrote:
> I have a dozen, very large CSV files that I wou
Sounds like the type for the field you're storing the number is not capable of
holding a number sized as 16996941. What's the field type you're storing the
number in?
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:31 PM
To: mysql
Maybe a review of http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html
will shed some light?
-Original Message-
From: Renato Golin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:48 PM
To: Richard Miller; Mysql
Subject: Re: CSV-to-SQL?
You could use the CSV table t
Maybe a review of http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html
will help?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 9:31 PM
To: mysql@lists.mysql.com
Subject: Changed Number
I have loaded a large *.csv spreadsheet
On Tuesday, April 05, 2005 20:31, [EMAIL PROTECTED] wrote:
> I have loaded a large *.csv spreadsheet into mysql and one number, the
> grand total, changes from 16996941 on the Excel spreadsheet to
> 8388607 in the mysql database. The numbers surrounding this number
> are correct at all stages.
Hi,
A new version of MySQL Community Edition 4.1.11 Open Source database
management system has been released. It 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 that not all mirror sites may be
With regard to the charactor set,
session values are not same to global values.
How to make session to global values?
Thank you in advance.
I use Debian Sarge as my Linux distribution on two servers who replicate MySQL.
Every time I upgrade the MySQL package my replication dies.
Any ideas why?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
78 matches
Mail list logo