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
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
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 query on
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 |
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
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:
+--+
|
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: mysql@lists.mysql.com
Sent: Tuesday, April 05, 2005 12:15 PM
Subject: Re: Weird Query Result
Not weird at all...
As you can see it returnet all
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
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.
this is a
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-ServerClient(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 your help?
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
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
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 problem is we also
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
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
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
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
-
job_id, integer,
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 field.
Is that
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
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
At 04:27 PM 4/4/05, Frank Bax wrote:
Cannot execute query.
snip my SQL statement
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
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
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:
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, varchar
easy so far :)
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: Mysql mysql@lists.mysql.com
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
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 on
the
[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.
I also
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
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
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
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: mysql@lists.mysql.com
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
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 of
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
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 one
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
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
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
--
MySQL
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
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 multiple
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 on
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
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
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:
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 above, put
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 warnings
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?
Do
exactly
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 'cause I
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
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)
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
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,
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
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 would
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:
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
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. I
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.
77 matches
Mail list logo