A quick google search revealed the following link:
http://bugs.mysql.com/bug.php?id=3139
Looks like it's one of those things related with Windoze! hence I would
start by checking if the OS is updated with latest patches.
HTH
Manoj
- Original Message -
From: "Nirmal Shah" <[EMAIL PROT
050609 16:33:59 mysqld started
050609 16:34:00 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
InnoDB: E
Hi,
I am running mysql 4.1.10 on windows 2000 professional
operating system.
Recently i upgraded the mysql version from 3.23.54 to
the current version.
Problem: the mysql server stops frequently. Upon
checking the mysql logs i have found the following
error lines:
050607 16:23:15 InnoDB: Operatin
I use Mysql 4.0.22.
When I press "show innodb status",I got the error message:
ERROR 1105: Unknow error
what's the problem?
Is the innodb enable in 4.0.22 by default? How can I check if the innodb
enable or not?
_
与联机的朋友进行交流，请使用
ANNOUNCEMENT:
A RFD (REQUEST FOR DISCUSSION) has been posted for the creation of a
new Usenet newsgroup: comp.databases.mysql
The proposal and related discussion can be read in the Usenet group
news.groups ... feel free to weigh in and make any suggestions you
may have.
Message-ID: <[EMAI
Ashok Kumar wrote:
> Hi Peter,
> If i give the localhost/IP addr, How can i set the
> security previleges in my server/system( i have
> installed apache server to run the scripts). as i told
> earlier i'm using win2000 os, its expecting lot of
> securitie prevleges. i can't find those settings. if
I think MySQL has a little ways to go yet before I would subjectively call
it best.
I posted twice to the list with questions about porting my application that
runs on (SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere, MS Access, and
DB2) to MySQL. No one on the mysql list, or the internals lis
Greg Whalin wrote:
Granted, Kevin's tone was a bit harsh, but his sentiments should be
encouraged (frustration w/ a lack of feature). The concept that
people should be happy with what they get for a free product only
serves to keep the quality of free products below what they could be.
It w
Jeff Smelser wrote:
Thats funny.. looks like it will be added to 5.1.. Dunno why they think fixing
it is adding a feature..
WOW! That's just insane! This seriously has to be fixed in 5.0 or sooner...
The thing is that MySQL has both promised this feature and is claiming
that 5.0 is now
Import via odbc ?
I used an app called sqlyog to import via odbc.
On 09/06/2005, at 9:45 AM, Kirk wrote:
Is anyone familiar with how to dump a database from Microsoft sequel
server
to mysql? I know nothing about Microsoft products and am looking for a
utility or similar to do the conversion.
Kirk wrote:
>Is anyone familiar with how to dump a database from Microsoft sequel server
>to mysql? I know nothing about Microsoft products and am looking for a
>utility or similar to do the conversion. Maybe Microsoft has something
>built in? Although I doubt it.
>
>
There are tools around -
Is anyone familiar with how to dump a database from Microsoft sequel server
to mysql? I know nothing about Microsoft products and am looking for a
utility or similar to do the conversion. Maybe Microsoft has something
built in? Although I doubt it.
TIA
Kirk
--
MySQL General Mailing List
It's not a bug at all. You just hit one of the features of enum :)
If you want to order alphabetically as you describe cast the enum name
to a string like this
select col from t order by concat(my_enum);
-Eric
Daevid Vincent wrote:
Please tell me there is a way to fix this "bug" in mysql V
Please tell me there is a way to fix this "bug" in mysql Ver 12.22 Distrib
4.0.18, for pc-linux-gnu (i686)
I have a column defined like so:
Type
enum('Schedule','Report','Admin','Search','General','License','Access')
If I SELECT, and ORDER BY Type, it is ordering in the order defined by the
the
Hello.
Error 2013 means: "Lost connection to MySQL server during query". See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
rtroiana wrote:
Hi All,
>
>
>
>I had posted a query few days back that I couldn't connect to mysql
database
>from a network machine. So for that
A long time ago when I was doing support for Lotus Notes, I was told that
the customer who 'complains' about legitimate bugs may be the most valuable
type of customer of all. This is because they care enough to vent. Who
knows how many unhappy customers one has if none ever complain? What if
al
Dear All, I have two tables entity1 and entity2; the second one should
contain only data with the same "PLZ" as listed in table "entity1".
Unfortunately, I am able to insert in table entity2 data in the field "PLZ",
different from those in the field PLZ in the table "entity1".
What is going wrong
Here are the string functions. LIKE and RLIKE are useful for partial
string searches:
http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html
RLIKE uses a variation of regular expressions. Here is the syntax MySQL
uses:
http://dev.mysql.com/doc/mysql/en/regexp.html
This section descr
[snip]
Maybe a good question to ask is where can I find documentation on:
MySQL WHERE where_definition
Specifically, all the options available for the 'where_definition'
[/snip]
http://www.mysql.com/select should do it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
[snip]
Tried that but no luck.
What I want is a search that will look for '15' (for example) in the
field BOOKING.
So if I enter '1' in my search field, it will find all instances of
BOOKING
with a '1' in it.
Conversely, if I enter '12345' in my search field, it will find all
instances of BO
Maybe a good question to ask is where can I find documentation on:
MySQL WHERE where_definition
Specifically, all the options available for the 'where_definition'
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 3:40 PM
To: mysql@lists.mysql.com
Subj
Tried that but no luck.
What I want is a search that will look for '15' (for example) in the
field BOOKING.
So if I enter '1' in my search field, it will find all instances of BOOKING
with a '1' in it.
Conversely, if I enter '12345' in my search field, it will find all
instances of BOOKING w
You can try
if($queryID = mysql_query("SELECT *
FROM WhInventory
WHERE Booking like ('%15%')
ORDER BY Booking",$dbLink))
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June
Hi All,
I had posted a query few days back that I couldn't connect to mysql database
from a network machine. So for that I added two entries in my firewall
exceptions.
I added the Port 3306 and mysqld, so firewall should allow any connection to
database from external computer. My problem wa
I need to come up with a high availability, high performance MySQL
server setup. I have two database servers half way across the country
from one another being replicated through a VPN. These db servers serve
two very busy web sites with multiple applications accessing the db.
During busy tim
Although it was nice to hear a few versions ago that they were thinking
about adding this, I did not think it was absolutely necessary. There are
many other ways to handle embedded queries. You can also offload some of
the server side work by doing so. Depends on how you use it I suppose.
As far a
Using MySQL 4.0.24 with PHP 4.3.11
I have the following code:
if($queryID = mysql_query("SELECT * FROM WhInventory WHERE Match(Booking)
AGAINST ('" . mysql_escape_string($form['booking']) . "' IN BOOLEAN MODE)
ORDER BY Booking",$dbLink)) {
Which works fine if I have an exact entry but fails f
[EMAIL PROTECTED] wrote:
Michael's last answer:
SELECT u.UserID
FROM Users u
LEFT JOIN BuddyList bl
ON u.userID = bl.buddyID
AND bl.userID = '$userid'
WHERE u.isactive =1
AND bl.userID is null;
Should do all of what you want except exclude the original user (so that
[snip]
I personally find the idea that just because a product is free that
people are not allowed to...
[/snip]
I was just trying to fling a little humor on to the situation, not start
a flame war about who is right and what rights they do or do not have. I
too believe that criticism, in the prop
Angelo Zanetti <[EMAIL PROTECTED]> wrote on 06/08/2005 01:38:42 PM:
> Let me rewrite what it's meant to do as i mgiht not have been clear.
> ok for a single user I want to get all the users (from the user table)
> that aren't a buddy for that user.
> users
> 1 bob
> 2 tom
> 3 mike
> buddylist
Chris wrote:
Thank you for your detailed response.
You're welcome.
It seems my problem is trying to define the path to my data file and this is
where I seem to be missing something.
No, the problem is permissions. As I explained previously, a relative
path (one without a leading /) means
Let me rewrite what it's meant to do as i mgiht not have been clear.
ok for a single user I want to get all the users (from the user table)
that aren't a buddy for that user.
users
1 bob
2 tom
3 mike
buddylist
1 2
1 3
2 1
2 3
3 1
//therefore if i searched for mike it would return tom as he is
Jay Blanchard wrote:
[snip]
On Wednesday 08 June 2005 11:16 am, you wrote:
[snip]
Thats funny.. looks like it will be added to 5.1.. Dunno why they
think
fixing
it is adding a feature..
[/snip]
The best open-source database on the market today? Free
Constant improvements to database? Free
Angelo Zanetti wrote:
thanks shawn it seems to be working but i forgot to add that i need it
for a single user ID, in other words it must bring back all user ids in
the user table if they do not exist for that user in the buddylist.
so what i've tried is this:
SELECT u.* FROM users u LEFT JOIN
On Wednesday 08 June 2005 11:49 am, you wrote:
> Easy there boss, I was just responding to the thread and meant no
> offense. I saw the whole thing as funny.
Oh.. email sucks that way..
My apologies as well..
Jeff
pgpvHgJLsGjaw.pgp
Description: PGP signature
> [snip]
> Thats funny.. looks like it will be added to 5.1.. Dunno why they think
> fixing
> it is adding a feature..
> [/snip]
>
> The best open-source database on the market today? Free
> Constant improvements to database? Free
>
> Ability to complain when we don't get what we want? Priceless
[snip]
On Wednesday 08 June 2005 11:16 am, you wrote:
> [snip]
> Thats funny.. looks like it will be added to 5.1.. Dunno why they
think
> fixing
> it is adding a feature..
> [/snip]
>
> The best open-source database on the market today? Free
> Constant improvements to database? Free
>
> Ability to
In the last episode (Jun 08), Ying Lu said:
> By the way, I am using 4.0.18-log on i686.linux2.6.10.
> >I did the following two explain select ... According to whether I put
> >the single quotation mark or not, I will get totally different results:
> >
> >1. Without single quotation mark:
> >
> >e
Greetings,
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain SELECT * FROM test T1 force index (idx_test)
WHERE *T1.STUDID = 099 AND T1.Prog_link = *;
On Wednesday 08 June 2005 11:16 am, you wrote:
> [snip]
> Thats funny.. looks like it will be added to 5.1.. Dunno why they think
> fixing
> it is adding a feature..
> [/snip]
>
> The best open-source database on the market today? Free
> Constant improvements to database? Free
>
> Ability to compla
By the way, I am using 4.0.18-log on i686.linux2.6.10.
Greetings,
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain SELECT * FROM test T1 force index (idx_t
I would increase your myisam_sort_buffer_size considerably just for
this operation. You've got your key_buffer set high, but your sort
buffer is comparatively low for creating a big index.
One way you can tell how far along the index is, is to look at how
quickly the index file is growing and
thanks shawn it seems to be working but i forgot to add that i need it
for a single user ID, in other words it must bring back all user ids in
the user table if they do not exist for that user in the buddylist.
so what i've tried is this:
SELECT u.* FROM users u LEFT JOIN buddylist bl ON u.userID
Angelo Zanetti <[EMAIL PROTECTED]> wrote on 08/06/2005 17:06:51:
> Hi guys.
>
> I'm having a problem deciding whether a left join is suitable for what i
> want to do.
>
> I have two tables
>
> A Users
> -userID
> -isactive
>
> B BuddyList
> -userID
> -buddyID
>
> what i want to do is to get a
[snip]
Thats funny.. looks like it will be added to 5.1.. Dunno why they think
fixing
it is adding a feature..
[/snip]
The best open-source database on the market today? Free
Constant improvements to database? Free
Ability to complain when we don't get what we want? Priceless
--
MySQL General
On Wednesday 08 June 2005 10:56 am, you wrote:
> In the last episode (Jun 08), Jeff Smelser said:
> > On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
> > > Subqueries in 4.1 are totally broken. They don't use indexes.
> > > They're evil. We're told we have subqueries but there's no way
> >
Angelo Zanetti <[EMAIL PROTECTED]> wrote on 06/08/2005 12:06:51 PM:
> Hi guys.
> I'm having a problem deciding whether a left join is suitable for what i
> want to do.
> I have two tables
> A Users
> -userID
> -isactive
> B BuddyList
> -userID
> -buddyID
> what i want to do is to get all the
In the last episode (Jun 08), Jeff Smelser said:
> On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
> > Subqueries in 4.1 are totally broken. They don't use indexes.
> > They're evil. We're told we have subqueries but there's no way
> > anyone on earth could use them. To make matters worse
Hi guys.
I'm having a problem deciding whether a left join is suitable for what i
want to do.
I have two tables
A Users
-userID
-isactive
B BuddyList
-userID
-buddyID
what i want to do is to get all the users from A that don't exist as a
buddyID for a user (buddyList) also the user must be act
Hi,
Another question, to help me better understand MySQL indexing:
In MyISAM, does DISABLE INDEX followed by insertions and then
ENABLE INDEX freeze the original index and batch-updates it, or does
it drop it completely and recreate it from scratch?
--thanks, Roi
--
MySQL General Mailing List
Hi.
I need to index about 300 million 20-byte records, but it takes
forever (it isn't finished yet, after almost 24 hours, so I don't have
actual numbers).
I'm using RHEL, kernel 2.6.9, Mysql 4.1.11, MyISAM table, on a dual
Xeon with 4GB RAM and IDE disks. I'm using the following values from
/my
[EMAIL PROTECTED] wrote:
Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,"INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s'))",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,t
No, I don't have Windows.
I need some one to load my tables, export to excel and email me the
excel docs.
On Jun 7, 2005, at 11:54 PM, [EMAIL PROTECTED] wrote:
if you want to use excel i suppose you have also windows with more
than 3 GO
free disk.
install win32 mysql
put the files in the
Hello.
According to:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/system_error_codes.asp
It is ERROR_WORKING_SET_QUOTA. "1453Insufficient quota to complete the
requested service." Check your disk quota.
A Z <[EMAIL PROTECTED]> wrote:
>
> Dear
Hello.
It seems not at the moment. See discussion at:
http://bugs.mysql.com/bug.php?id=9056
Juri Shimon <[EMAIL PROTECTED]> wrote:
> Hello mysql,
>
> Is mysqldump from 5.0 dumping a stored procedures?
> If it isn't, then when (if planned)?
>
--
For technical support cont
Hello.
I can see such behavior in test database because mysql.db table
has records which allows updates to any user, and database
privileges ORs with global privileges. Send us the contents
of your privileged tables. See:
http://dev.mysql.com/doc/mysql/en/request-access.html
Upgrade to
Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,"INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s'))",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp);
Shawn Green
Database A
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
> Subqueries in 4.1 are totally broken. They don't use indexes. They're
> evil. We're told we have subqueries but there's no way anyone on earth
> could use them. To make matters worse a lot of developers are TRICKED
> into using them and as
"Tommy Svensson \(InfoGrafix\)" <[EMAIL PROTECTED]> wrote on 06/07/2005
04:49:09 PM:
> Hi all you mysql gurus,
> I have 400 000 unique strings where each and every one of these strings
are
> associated with 1 - 50 (appr.) integer values.
> Now, pretty simple for you guys I guess, but how will
Well, here's the semi-relational way to do it:
CREATE TABLE `MyStrings` (
`ID` int NOT NULL AUTO_INCREMENT ,
`String` varchar(100) NOT NULL DEFAULT '' ,
UNIQUE `StringIndex`(`String`)
PRIMARY KEY ('ID') )
TYPE=MYISAM
CREATE TABLE `MyIntegers` (
`ID` int NOT NULL AUTO_INCREMENT ,
`StringID` int N
Hi,
snprintf(query_length,query,
"INSERT INTO
idsmatch(sip,sport,dip,dport,HEX(payload))VALUES('%s',%d,'%s',%d,'%s')",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp);
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.m
Wrong path, you are referring to an uri, not a path. Way off topic to
starting explaining basic file system stuff here.
You should be the same path you used when your uploaded the
file. Something like:
/home/chris/datafile.txt
Frank
At 10:06 PM 6/7/05, Chris wrote:
Well, in fact
Ashok Kumar wrote:
> Sorry. I think i gave some unwanted info in my query.
> C-CGI is nothing but - CGI is scripting lang like
> JScript and its mainly for web related applications.
> we can use this scripting in any languages. i had
> chosen "VC++ - Console appln".
> In this i used MySQL C-API
Dear Fellows,
How to deal with the following error:
regards
mysqld-nt --console
050608 11:12:42 InnoDB: Operating system error number
1453 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for
installation help.
InnoDB: Error number 1453 means 'Unknown error'.
InnoDB: See als
Hello,
I am writing a program for packet sniffing in Linux platform using C
language. I am using MYSQL as my database for storing packet information like
IP, port, packet payload, etc. I have created a table using the following query:
create table idsmatch(sip text,sport integer,dip text,dport
Hello,
I was wondering if there is any way to get SELECT result with
`table_name.col_name` column names.
It seems to me that I have had such result set before (Not with my
current installation/configuration / :4.0.23_Debian-4). ( I know about
column aliases, but is this a the best or the only
I tried the SHOW GRANTS statement
SHOW GRANTS FOR 'dtk10mv'@ 'localhost'
and got this:
Grants for [EMAIL PROTECTED]
GRANT SELECT, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'user1'@'localhost' IDENTIFIED BY PASSWORD '08862e71234184bc'
GRANT UPDATE (column1) ON database1.table1
Hi all you mysql gurus,
I have 400 000 unique strings where each and every one of these strings are
associated with 1 - 50 (appr.) integer values.
Now, pretty simple for you guys I guess, but how will I design my
database to make a search interface against this data as rapid as possible?
My fir
if you want to use excel i suppose you have also windows with more than 3 GO
free disk.
install win32 mysql
put the files in the data directory of one existing database
connect and use that database
export data to an outfile by :
select * from yourtable into outfile csv fields terminated by '
69 matches
Mail list logo
