Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.0.4)
A fast test-data generator tool that comes with a library
of real-life data, presets and much more.
This new release consists of four versio
Hopefully this will be the last snag...least till the next one :)
I'm having a problem setting the charset to unicode (utf-8). If I
understood what I read I can set each table to support a charset. But what
I want to do is set the default charset for a database to be utf-8. Is this
possible? If so
When using SJIS charset, there is a problem when the second byte of
a character matches with 7bit ASCII code.
The character codes including \(\x5C) in their second byte need
caution.
The range of SJIS code is [\x81-\x9F\xE0-\xFC][\x40-\x7E\x80-\xFC]
Please see my test result at
http://ep
Does any one knows how to store and retrieve files in blob columns using
VB .Net with ByteFx?
FBR
On Mon, 19 Apr 2004 20:17:38 -0700 (PDT), Marc Slemko wrote:
> On Mon, 19 Apr 2004, Stormblade wrote:
>
>> Ok. Love MySQL and I will be using it for my personal use and recommending
>> it to clients as a lower cost alternative. I've only been using it for a
>> very short time but there one major
On Mon, 19 Apr 2004, Stormblade wrote:
> Ok. Love MySQL and I will be using it for my personal use and recommending
> it to clients as a lower cost alternative. I've only been using it for a
> very short time but there one major gripe I have with it and I believe it's
> just a design thing.
>
> My
On one database, I keep seeing similar errors related to the key file for
the different tables.
1034 Incorrect key file for table:
Can't read key from filepos: 672768
error 5 when fixing table
Can't copy datafile-header to tempfile, error 9
How do I diagnose if the database file structure is corr
On one database, I keep seeing similar errors related to the key file for
the different tables.
1034 Incorrect key file for table:
Can't read key from filepos: 672768
error 5 when fixing table
Can't copy datafile-header to tempfile, error 9
How do I diagnose if the database file structure is corr
Hello,
I have a client that can connect to either a local or remote MySQL server.
LOAD DATA INFILE works fine on a local server, but obviously fails when a
remote server is used. When I add LOCAL to the command, I get: The used
command is not allowed with this MySQL version
I am using
Hello,
I have a client that can connect to either a local or remote MySQL server.
LOAD DATA INFILE works fine on a local server, but obviously fails when a
remote server is used. When I add LOCAL to the command, I get: The used
command is not allowed with this MySQL version
I am using 4.0.18.
Ok. Love MySQL and I will be using it for my personal use and recommending
it to clients as a lower cost alternative. I've only been using it for a
very short time but there one major gripe I have with it and I believe it's
just a design thing.
MySQL seems to put the burden of error checking and s
At 20:23 -0400 4/19/04, Stormblade wrote:
On Mon, 19 Apr 2004 17:36:50 -0500, Paul DuBois wrote:
Sorry if I wasn't clear. One of the things you wanted to do was have
a column that is set automatically to record-creation time when the
record is created, but not updated automatically when the re
At 9:45 -0700 4/19/04, Emmett Bishop wrote:
Is the key_buffer_size server variable useful for
tuning databases that only have innodb tables or do I
need to use the innodb_buffer_pool_size variable for
this?
The buffer controlled by key_buffer_size is used only
for MyISAM and ISAM tables.
--
Paul Du
On Mon, 19 Apr 2004 17:36:50 -0500, Paul DuBois wrote:
> Sorry if I wasn't clear. One of the things you wanted to do was have
> a column that is set automatically to record-creation time when the
> record is created, but not updated automatically when the record is
> updated later. You will be
At 19:09 -0400 4/19/04, Andy B wrote:
hi..
i am trying to create this table:
CREATE TABLE rnjresort_events (
Id int(25) NOT NULL auto_increment,
Type enum('Annual','OneTime') binary NOT NULL default 'Annual',
StartDate varchar(200) binary NOT NULL default '',
EndDate varchar(200) binary NO
hi..
i am trying to create this table:
CREATE TABLE rnjresort_events (
Id int(25) NOT NULL auto_increment,
Type enum('Annual','OneTime') binary NOT NULL default 'Annual',
StartDate varchar(200) binary NOT NULL default '',
EndDate varchar(200) binary NOT NULL default '',
Name varchar(100)
I'm not actually getting an error. I'm simply unable to access any of my
databases while logged in as [EMAIL PROTECTED] I'd like to change this and
specify what account is used to establish a connection. How and where do I
make this change in MySQL?
Thanks
-Original Message-
From: Egor E
At 17:55 -0400 4/19/04, Stormblade wrote:
On Sun, 18 Apr 2004 14:18:40 -0500, Paul DuBois wrote:
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to
MyS
> -Original Message-
> From: Marvin Wright [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 19, 2004 8:55 AM
> To: [EMAIL PROTECTED]
> Subject: InnoDB Load Problem
>
> Hi,
>
> Apologies in advance for the large post but I've tried to explain my
> problem
> as much as I can.
>
>
>
> I'
At 7:11 +1000 4/20/04, electroteque wrote:
Huh as in production ?
Surely you jest. 4.1.1 was an alpha release. It's unlikely
that 4.1.x would go straight to production-level in a single
step. I believe that 4.1.2 will also be an alpha release.
That said, I encourage you to go ahead and try it ou
Use JFS, unless your database server is going to have many many (on the
order of 10K) small tables use Reiser.
JFS hands down is faster for various mixed environments of reading / writing
/ random access etc.
--
DVP
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTEC
Can you start it with strace running and see where it fails? I suspect its
an issue with finding the group file. If this is the cause you will need to
build mySQL yourself.
Btw please send arch / version / system hardware spec.
--
DVP
> -Original Message-
> From: Mozzi [mailto:[EMAIL PRO
Don Dachner wrote:
Which filesystem is better for a MySQL server? I can't see the difference between them.
All I need is a LFS that will handle a MyISAM table above the 4GB size level.
Running Linux 2.4 (or can install the latest ver if necessary) on 32 bit Intel platform.
My Linux bo
Does anyone know of an open source tool like Torque or Hibernate for
Java that can generate C++ classes rather than Java? We're starting a
project with a mySQL backend that involves both a C++ part and a Java
part. I've searched high and low for such a tool/library and haven't
been able to find o
On Sun, 18 Apr 2004 14:18:40 -0500, Paul DuBois wrote:
> At 13:30 -0400 4/18/04, Stormblade wrote:
>>On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
>>
>>> Stormblade wrote:
>>>
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
w
Hello.
I have installed binary version for aix 5.2 from www.mysql.net and when i try to
compile cyrus-sasl with mysql support it don't find mysqlclient libraries.
I use --with-mysql=/usr/local/mysql/ to build but i get:
checking for mysql_select_db in -lmysqlclient... no
configure: WARNING: MyS
Sorry no subject on the last email
Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have
Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have scripts that you use why not
lodge
Ah Ha! Thanks!!!
Lou
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 19, 2004 5:14 PM
Subject: RE: Getting an older version of MySQL
> 4.0.18 is the latest 4.0.x release.
>
> 4.0.3 < 4.0.9 < 4.0.10 < 4.0.18
>
> 4.0.3 != 4.0.30
>
> ---
Huh as in production ?
> -Original Message-
> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 20, 2004 5:52 AM
> To: [EMAIL PROTECTED]
> Subject: Re: when 4.1.2 release
>
>
> Marek Lewczuk <[EMAIL PROTECTED]> wrote:
> > Hello,
> > when do you plan to release
4.0.18 is the latest 4.0.x release.
4.0.3 < 4.0.9 < 4.0.10 < 4.0.18
4.0.3 != 4.0.30
-Original Message-
From: Lou Olsten [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 1:44 PM
To: [EMAIL PROTECTED]
Subject: Getting an older version of MySQL
Hi,
I'm currently running some instan
Hi,
I'm currently running some instances of 4.0.18. I read the following in the docs:
<>
But when I look at the downloads page, I only have options for 4.0.18 (production) or
4.1.1 (alpha).
How do I upgrade my 4.0.18 to 4.0.3 or whatever the latest 4.0.x might be?
Thanks,
Lou
When trying to start mysqld I get the following error
#safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/safe_mysqld: line 275: 32649 Segmentation fault $NOHUP_NICENESS
$ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
$USER_OPTION --pid-
Hello!
I have a simple query on a table of about 1,000,000 records... The table is
optimized and the query is pretty simple at this moment... something like
this
select id,name,desc,cat,date from table where cat='12'
however I need to order the results by date desc... I have indexes on both
the
Marek Lewczuk <[EMAIL PROTECTED]> wrote:
> Hello,
> when do you plan to release 4.1.2 version ?
>
It will be released in several weeks.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ _
"Chad Attermann" <[EMAIL PROTECTED]> wrote:
> I am using HIGH_PRIORITY in my SELECTs to force queries to take predcedence over
> updating
> due to replication. I have recently implemented UNION in some of my queries to
> optimize
> queries like "WHERE table1.column1=something OR table1.column2=s
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get
At 15:26 -0400 4/18/04, Stormblade wrote:
Thanks for the explaination. Heh I should have realized that. varchars are
probably implemented as null terminated strings and so they need an extra
byte for the terminating char (Null or otherwise).
They're stored as a length byte + string contents.
Yeah
At 0:11 +0200 4/19/04, Gerd JuppJacke wrote:
Hello,
I need fast help. My .frm-files are deleted on MyIsam MySQL. The other two
files types (myd and myi) of each table are still there but the frm-files
are deleted. The database does not work any more.
How can i reconstruct the database with the two
At 0:11 +0200 4/19/04, Gerd JuppJacke wrote:
Hello,
I need fast help. My .frm-files are deleted on MyIsam MySQL. The other two
files types (myd and myi) of each table are still there but the frm-files
are deleted. The database does not work any more.
How can i reconstruct the database with the two
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name "id #", which is used by many
queries in Acce
At 15:26 -0400 4/18/04, Stormblade wrote:
Thanks for the explaination. Heh I should have realized that. varchars are
probably implemented as null terminated strings and so they need an extra
byte for the terminating char (Null or otherwise).
They're stored as a length byte + string contents.
Yeah
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name "id #", which is used by many
queries in Acce
Is there a way to log authentication failures against the mysqld by
source IP and username attempted?
--
Mark P. Hennessy [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Which filesystem is better for a MySQL server? I can't see the difference between
them.
All I need is a LFS that will handle a MyISAM table above the 4GB size level.
Running Linux 2.4 (or can install the latest ver if necessary) on 32 bit Intel
platform.
My Linux books says XFS is the lead
Hello everyone,
Sorry for the delay in responding but I had to be out of town for the last
4 days and didn't have access to my mail.
Here is a recap for those who are just joining:
I have multiple branch locations that need to have their transactions
rolled up into a common statistics database.
Ben Dinnerville wrote:
Note that sorting by the count can't use an index, so it will be slower
than if you had ordered by `Call Svc Tag ID`.
This is something that will need testing. Ordering on a varchar(255) column
(call svc tag ID) is going to be a lot more inefficient than ordering on a
num
Hi,
Apologies in advance for the large post but I've tried to explain my problem
as much as I can.
I'm having load issues with my InnoDB server and am not sure what I should
try to resolve this problem.
The machine is redhat Linux 7.2 with dual processors, 4GB ram and about 32GB
disk space.
The
Is the key_buffer_size server variable useful for
tuning databases that only have innodb tables or do I
need to use the innodb_buffer_pool_size variable for
this?
Thx,
Tripp
__
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital print
hi - Ive posted this before but not had a satisfactory solution...
Im trying to load spatial data as OGC WKT into a geometry field but a number of rows
consistently fail. I can se no reaspn for this other than their length - does anyone
know what the size limit for insertion into a geometry field
I hate to say this, but you may want to look into FileMaker if you
don't know a lot about databases and programming. You'll be able to get
things up to speed a lot quicker and other users would be able to learn
it fairly easily to help you out. I often use FileMaker to prototype a
database and
thanx for all the replies.
i found the solution with a single select and update, it was a simple
update(how did i miss tht???)
but what if i want to do a compelete transaction with row level locking
in consideration, as thr can be time lag between the queries(select and
update) so a row level lock
First of all, thank you for providing a really informative list. I have
listened to many of the suggestions going back and forth and have
learnt a lot in the past few months.
I have a question.
We have a fresh MySQL installation on a new box, and we want to
basically start tuning it to our p
hi all
I have installed mysql and I created an users call lrmt and password
is lrmt.
So from command line(mysql -u lrmt -p lrmt) i can enter to mysql with out
any problem and also with mysql -u root -p socket.
I used this command to give permission to user
GRANT ALL ON database.* TO [EMA
Zhang Yu <[EMAIL PROTECTED]> wrote:
>
> I am migrating an old Access database to MySQL. After
> migration, we'll keep using Access forms as front end,
> and MySQL as database.
>
> I experienced a strange problem when creating table
> with a column name "id #", which is used by many
> queries in A
Ben,
- Original Message -
From: "Ben Dinnerville"
Sent: Monday, April 19, 2004 1:49 AM
Subject: RE: Slow Query Question - Need help of Gurus.
>>Then try again:
>>
>> SELECT `Call Svc Tag ID`,
>> Count(*) as counter,
>> `Journal Create Date`
>> FROM 31909_859552
Hello, Me and a few others are developing om linux boxes running MySQL 5.0.0. We often
create users with different access rights on our development boxes and then it often
occours problems with users when our programs goes into "production". I would like to
find a common user enviroment for our
58 matches
Mail list logo
