I am using the host that served my applet. I also already tried both, putting
in "localhost", as well as, putting the IP address in the code. Neither
worked. I still get the same error message with one small difference. When I
used the IP address, I received this error:
SQLException: Unable
hi all,
i'm using RH linux 9 and MySQL(3.23.54a-11) that comes with the distro. i have
installed the latest jdbc driver (mysql-connector-java-3.0.14-production-bin.jar from
the msql site) for mysql and also have set the CLASSPATH correctly. despite this, t he
jsp application i'm running is giv
I think he's trying to create the user mysql on the system.
If so try if you can add any other user on your system. If this fails, it's
a problem of your system. Try asking the question on a debian list. Maybe
they can help you better.
Regards
O.Salzgeber
-Ursprüngliche Nachricht-
Von: V
hi...
a simple question...
i'm creating a table and want to set a column to have the default of the
current day/time when the row is created...
i've tried...
create table foo(
dog int,
timestamp1 default NOW()
);
with no success. i've also tried various iterations..
any ideas/solutions as to
Generally applets are anly allowed to access the host that served them.
Try to use the host name (localhost or whetever your machine is called) rather than
the IP address, or conversely, give the IP address rather than "localhost" to the
browser.
I don't know whether applets are restiricted t
Good day.
From these sources:
http://jeremy.zawodny.com/blog/archives/000458.html
http://dev.mysql.com/doc/mysql/en/FreeBSD.html
Jeremy is using "-O -march=pentiumpro" and
MySQL AB "-O2 -fno-strength-reduce".
Does anyone compared this? Or it make no sense?
PS. MySQL 4.x and FreeBSD 4.x
--
Best
I am trying to connect to a database which is being served off of my machine
(same one I am using to connect to it). It works fine when I do-
System.out.println(rs.getString("D.Name") );- and it prints it out in an
application. But when I try to output it in an applet, it gives me this error:
A client wants access to some data in mysql 3, it is a simple case of a user
table and a registered_serials table, there is always one user, and there
can be many resistered serials. (One to many)
They want to somehow get this data into Excel, so I want to give them one
record per user, even thoug
Greetings All,
I walked through the mailing list thread earlier today. The big issues
that I believe that people raised were:
* Incorrect information on distribution as it applies to the GPL in
our licensing documents
* Lack of clarity from MySQL on what is and not acceptable use of
GPL-licen
Hi everyone,
I hope you can give me some pointers to speed up the inserts for a simple InnoDB
table. We are running MySQL 4.0.16-Max on a machine with 4 Intel Xeon 2.8 GHz CPU's, 2
GB RAM, Red Hat 9 Linux kernel 2.4.20. The innodb_buffer_pool_size is set to 512 MB.
This is the create statemen
1. I re-examined the error messages in config.log. I
couldn't find anything obvious to fix.
2. I decided to gamble and run make, compile went OK
3. Ran make install, install went OK
4. Ran mysql_install_db, went OK
5. Changed file permissions
drwxr-xr-x 13 root mysql 442 30 Jul 05:29 ./
drwxr-
sean c peters wrote:
But when I load a parent table, an auto_increment column
autogenerates a value that will be a foreign key in a child table. So i cant
create the file to load into the child table until after the parent table has
been loaded. Then i'll need to get back all the auto increment
> Entering it in hex works for me too. So the problem _was_ actually with
> the values I inserted into the database.
>
> What's the best way to actually see what is stored in the database,
> preferably as hex or something else that a terminal is guaranteed to
> display correctly? Clearly, what
Also, are the indexes in place when you start your inserts? Constantly
updating those indexes will be slow; try inserting without indexes, and
then building the indexes.
You can also limit the size of your index file by,
1) Making sure all columns are as small as possible (ie MEDIUMINT rather
t
On Wed, Aug 04, 2004 at 02:46:50PM -0500, rdo mail list address wrote:
> Is the MySQL Reference Manual, by Widenius and Axmark (the one to which
> there is a link on the Documentation page of the mysql website, for sale by
> Barnes and Noble) the same reference manual that you can download?
>
> Th
Are you disabling autocommit before doing the inserts? And committing
after all inserts are complete?
-Original Message-
From: Luc Charland [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 7:54 PM
To: [EMAIL PROTECTED]
Subject: Insert problems with InnoDB (big table)
We are eval
For this type of custom loading you may want to explore a programming
language such as Java or C/C++ or Perl. Depending on your platform you could
even explore some third party tools.
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/4/04 3:27 PM
Subject: load data infil
I haven't used load data infile much, mainly because of issues like this
question. I want to load a bunch of data for our data warehouse into about 10
different tables. But when I load a parent table, an auto_increment column
autogenerates a value that will be a foreign key in a child table. So
Is the MySQL Reference Manual, by Widenius and Axmark (the one to which
there is a link on the Documentation page of the mysql website, for sale by
Barnes and Noble) the same reference manual that you can download?
The PDF version has 1310 pages, the softcover book has 712 pages, and I'm
not sure
If I use "innodb_file_per_table", how do I properly back-up that table so it
could be imported to another server should something happen to my main
server if I do not have the hot-back-up utility?
If I lock & then copy the table, can I simply use "ALTER TABLE tbl_name
IMPORT TABLESPACE" for it
David Griffiths writes:
>Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when data
>is deleted either.
Actually, Oracle has been able to resize data files since 7.2. It
is usually done with an 'alter tablespace ... coalesce' followed by an
'alter tablespace datafile ... resiz
> On other hand B->C changes for some tests surprise me. Are the
> results stable if you repeat the run ? In some cases especially
> for short tests deviation can be pretty large.
The results are stable, sadly. The bigger surprise was the select
deviation from 3 to 4, but so far, in applicat
On Mon, 2004-08-02 at 14:57, Tinley, Jeremy wrote:
> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
> ALTER test results of sql-bench had been greatly improved, CREATE has
> shown nasty performance degradation. Just before needing to make the
> decision to revert back to 3
On Wednesday 04 August 2004 06:44 am, Odhiambo Washington wrote:
> Is there hope for me in this situation??? I have googled and googled but
> all that I see doesn't seem to help me to recover the data in the table.
>
> This makes me very desparate.
>
> I'd be very thankful for any pointers that wo
Hashing algorithms like MD5 are good answers to what you're
looking for, but first, I'd recommend SHA1. MD5 is known to
have some weaknesses, and SHA1 produces a longer, more
secure 160-bit string (called a message digest). MySQL
versions 4.0.2 and up have SHA1 built-in.
Whether you use MD5 or SHA
I think you understand. Here is how I would re-write the query to use the
new table:
$query = "SELECT
l.CatalogNumber,
l.PDFLink,
l.PDFName,
l.MP3Name,
l.Title,
p.PublisherName,
c.ComposerLname,
> For certain columns i am completely sold on not using nulls, for others, i
> cant see any conceptual reason to favor either way, so i thought i'd tap
> you all for some insight.
A NULL is the equivalent of saying "I don't know" whereas a 0 means the value
between -1 and 1 and a blank means 'no
There is are five new time_% tables. You could install 4.1.3 in a clean
area, export the tables and import the tables into the upgraded environment.
You could also export your 4.0.x data and import this data into the newly
created 4.1.3 environment.
-Original Message-
From: Jeff Mathis
To
I think I understand. So instead of my queries being centered around
the listings table, they will be centered around this new table?
Currently, I pull the records for each category like so:
$query = "select
l.CatalogNumber,
l.PDFLink,
l.PDFName,
Hi There,
I was wondering if anyone has used the Stored Procedures in MySQL
version 5.0.0-alpha. I have setup a MySQL server version 5.0 alpha and
was trying out the stored procedures. I noticed some strange behaviour
in using some of the function calls from within the stored procedures. I
am faci
we just upgraded from 4.0.4 to 4.1.3, and are getting this warning. is
there a script somewhere we can run to create the alleged missing time
zone table?
040804 10:09:49 Warning: Can't open time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without them
thanks
j
As posted, your data structure supports two one-to-many relationships, not
the one-to-one relationships as you described. You can have multiple
Listings per Category and multiple Categories per Group. What it sounds
like you have been asked to do is to support a many-to-many relationship.
You
Hi!
On Aug 04, Egor Egorov wrote:
> Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>
> >> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
> >> ALTER test results of sql-bench had been greatly improved, CREATE has
> >> shown nasty performance degradation. Just before needing
You are right, a comma separated "list" won't work since you won't be
able to do joins on it. To create a one to many relation, you actually
need to create another table to hold the relation.
CREATE TABLE listCatLink (
ListingID bigint(20) unsigned NOT NULL,
CategoryID int(11) NOT NULL
)
On Aug
EB> My thought was to add a new field to the listings table that would
EB> contain a comma-separated list of CategoryIDs, but something doesn't
EB> feel right about this solution.
> This would break the first normalization form and is extremely bad
Okay - I thought something was off...
> First o
Sheraz <[EMAIL PROTECTED]> wrote on 04/08/2004 13:14:26:
> Hi
> I need to store a globabl unique identifer value in
> mysql4.x database table.
>
> table field is varchar(16) as the string length is 16
> byte or 128 bitsmy string data is unsiged char
> type..
>
> how can i send that
Hi, All:
We have a network management system written in C++, MysQL, and Hp
SNMP. It works in Solaris command line. When I wrote a similar
python codes which call compiled C++ and mysql codes in solaris
command line, the comipled codes work fine in wraped python file. When
I
change the python
Hi,
On 2004-08-04 21:20, gerald_clark wrote:
[...]
SELECT C.B
FROM A
INNER JOIN C ON C.A = C.A
Perhaps you meant:
INNER JOIN C on C.A = A.A
RIGHT JOIN B ON B.B = C.B
WHERE C.B IS NULL
[...]
Yes, thanks. I didn't realize that mysqlbug sends the report to a
mailing list. I have proceeded to su
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 8:33 AM
To: [EMAIL PROTECTED]
Subject: Re: CREATE performance degradation from 4.0.17 -> 4.0.20
Sergei Golubchik <[EMAIL PROTECTED]> wrote:
> As one usually doesn't create tables at the huge r
Hi all,
I need some advice on a project I have. Basically, I have some tables:
CREATE TABLE listings (
ListingID bigint(20) unsigned NOT NULL auto_increment,
CatalogNumber varchar(12) NOT NULL default '',
PDFLink varchar(100) default NULL,
PDFName varchar(80) default NULL,
Title varch
On Tue, Aug 03, 2004 at 01:11:44PM -0400, Jeremy March wrote:
> Is this for Swedish language data? I don't know Swedish so I don't
> actually know where u-diaeresis is sorted in Swedish myself, but
> according to the source code (in the file: strings/ctype-uca.c) the
> u-diaeresis is sorted as an
The JDBC driver will not recognize the my.cnf file.
-Original Message-
From: Sergei Skarupo
To: Mysql List (E-mail)
Sent: 8/3/04 10:51 PM
Subject: Default username and pw for MySQL Connector/J
Hi everyone,
Is there a standard way to specify a default user name and password for
the java
Yes. Exactly! Thanks so much for pointing this out!
Haitao
On Wed, 4 Aug 2004 08:53:28 -0500 (CDT), Mark Matthews <[EMAIL PROTECTED]> wrote:
>
>
> > Hi,
> >
> > I have following code to insert a row into a table - schema follows:
> > :
> > PreparedStatement insertData = targetConnection.prepa
* Egor Egorov <[EMAIL PROTECTED]> [20040804 16:24]: wrote:
> Odhiambo Washington <[EMAIL PROTECTED]> wrote:
>
> > +--++--++
> > | atmail.Users | repair | info | Key 1 - Found wrong stored re
- Original Message -
From: "Karl-Heinz Schulz" <[EMAIL PROTECTED]>
To: "'Philippe Poelvoorde'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 04, 2004 6:41 AM
Subject: RE: SQL Syntax Question
> Philippe,
>
> I changed my to the following but the result is now (I del
> Hi everyone,
>
> Is there a standard way to specify a default user name and password for
> the java driver? For example, will it recognize .my.cnf like most mysql
> clinets do?
>
> Thanks,
>
> Sergei
>
Sergei,
No there is not. It must be passed in on the command line. Of course your
application
> Hi,
>
> I have following code to insert a row into a table - schema follows:
> :
> PreparedStatement insertData = targetConnection.prepareStatement("insert
> into CompanyParticipationLevel
> (siteId,nodeId,companyId,editionId,participation
> LevelId,participationText,participationLogo) values
Hello All,
DBACentral for MySQL has been released!
===
The long-awaited headliner of the DBACentral Product Family has been
finally released!
We are proud to present an absolutely new product which brings MySQL
database management to the new level of fastness
Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
>> ALTER test results of sql-bench had been greatly improved, CREATE has
>> shown nasty performance degradation. Just before needing to make the
>> decision to revert back to 3.2
If you want them ordered by autoinc_field then add
ORDER BY autoinc_field.
Otherwise expect them to be returned in any order.
Cres Justado wrote:
can anyone help me with my problem regarding mysql 4.0.2. I'm having a
problem with the sequencing of the auto incremnt field. if my
application makes
Jon Drukman <[EMAIL PROTECTED]> wrote:
> i've got one master and one slave. the master is VERY busy, tons of
> inserts/updates/deletes all the time. (it's an extremely high traffic
> message board system.)
>
> we've got a situation right now where the slave starts lagging WAY
> behind the mas
Are you attempting to add a user in the MySQL database or the mysql user on
the system?
-Original Message-
From: Levi Campbell
To: mysql
Sent: 8/4/04 8:12 AM
Subject: cannot add mysql user on debian sarge
On debian sarge, I'm trying to add a user for MySQL but every time I
try, I get the
"Scott Fletcher" <[EMAIL PROTECTED]> wrote:
> Is it possible to verify the database backup. Like most machines, that
> make backup of files then verify that all of it is backed up without an
> error? I use mysqldump to make a backup but I have no idea about the
> verify
Restore the dump int
I checked. SIUE seems to be an institute of higher learning. Well, here's
your chance to do some self-directed,internet-based learning (probably the
point of your project, isn't it. :-( )
RTFM my dear student! Then, if you don't understand what you read, use a
search engine to find out what o
That's how dbs work. When rows are deleted, they reclaim that space when
new rows are inserted. Hence, there is no "last row" (in fact, no order at
all) unless you explicitly order the results in your select. That's what
ORDER BY is for. Try
SELECT autoinc_field, data_field FROM yourtable
Alan wrote:
Description:
See how-to-repeat.
How-To-Repeat:
CREATE TABLE A (A int);
CREATE TABLE B (B int);
CREATE TABLE C (A int, B int);
INSERT INTO A VALUES (1),(2);
INSERT INTO B VALUES (1),(2);
INSERT INTO C VALUES (1,1);
SELECT C.B
FROM A
INNER JOIN C ON C.A = C.A
Perhaps you me
"Venkateswaran, Bhaskar" <[EMAIL PROTECTED]> wrote:
> I just upgraded to mysql-4.0.20 compiled using gcc-3.3.3. All my C++ DB
> interfaces connecting to this mysql database seem to run into a problem -
> when I try to disconnect, mysql_close() is called but the program just hangs
> there without b
"Carlos Proal" <[EMAIL PROTECTED]> wrote:
> How stable is this feature? , i have been using it for a few time and works
> fine, but im thinking to move my current productive enviroment this way and
> i dont know if its a good choice.
>
> Any advise is appreciated.
It is stable. :)
--
Fo
Odhiambo Washington <[EMAIL PROTECTED]> wrote:
> +--++--++
> | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 |
> | atmail.Users | repair | status | OK |
> +
On debian sarge, I'm trying to add a user for MySQL but every time I try, I get the
following error
/usr/bin/perl: relocation error: /usr/perl5/locale/gettext/gettext.so: unrecognized
symbol: Perl_gthr_key_ptr
What do I need to do?
1. What is the user or connection limit for both versions of MySQL
(Database
Server and MaxDB)?
Search the web site
2. How much memory does MySQL take when started up?
Search the web site
3. Does MySQL take advantage of dual CPU systems?
Search the web site
4. Define referential integrity.
Do a
> I was wondering if anyone could answer a few questions for me. I have to
do
> some research for a school project.
> 1. What is the user or connection limit for both versions of MySQL
(Database
> Server and MaxDB)?
> 2. How much memory does MySQL take when started up?
> 3. Does MySQL take ad
I was wondering if anyone could answer a few questions for me. I have to do
some research for a school project.
1. What is the user or connection limit for both versions of MySQL (Database
Server and MaxDB)?
2. How much memory does MySQL take when started up?
3. Does MySQL take advantage of d
Hi
I need to store a globabl unique identifer value in
mysql4.x database table.
table field is varchar(16) as the string length is 16
byte or 128 bitsmy string data is unsiged char
type..
how can i send that data to mysql table ?
will it require binary storage for this unsigned data
Hello DB-users,admins,
I have serious problem with a table in a DB that I have.
This is on a mysql-4.0.20.
mysql> CHECK TABLE Users;
+--+---+--+--+
| Table|
hi all
i'm having the following issue, that i'm not sure how to resolve
i have a comma seprated file, which imports fine with;
LOAD DATA LOCAL INFILE 'path/top/file.txt' REPLACE INTO TABLE
`tablename` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED
BY '\r';
but lines with latin1 chara
Philippe,
I changed my to the following but the result is now (I deleted the print
stuff for better reading)
Event 1
Event 2
Details 1 for event 1
Details 2 for event 1
Details 3 for event 1
But I would need
Event 1
Details 1 for event 1
Details 2 for event 1
Details 3 for event 1
Eve
Karl-Heinz Schulz wrote:
Thank you for trying to help me.
The output is wrong
I get either
Event 1
Event 2
Details 1 for event 1
Details 2 for event 1
Details 3 for event 1
that query is wrong :
$eventdetail_query = mysql_query("select informations, titles, file_name
from eventdetail, event where
Luc,
do you use the mysql client for the insert operations?
And is autocommit set to "yes"?
Then the answer is:
turn off autocommit mode and commit every rows.
Commit every 100,000 rows for example.
The speeds up the whole thing a lot because there is no need for a disk
flush after every record
In article <[EMAIL PROTECTED]>,
Jeff Mathis <[EMAIL PROTECTED]> writes:
> my understanding is that the datafiles are created when the server
> initializes, and this this is the designed and expected behavior. Most
> other database products use a similar model. Your scenario cannot
> happen. You sp
>Description:
See how-to-repeat.
>How-To-Repeat:
CREATE TABLE A (A int);
CREATE TABLE B (B int);
CREATE TABLE C (A int, B int);
INSERT INTO A VALUES (1),(2);
INSERT INTO B VALUES (1),(2);
INSERT INTO C VALUES (1,1);
SELECT C.B
FROM A
INNER JOIN C ON C.A = C.A
RIGHT JOIN B ON B.B = C.B
WHERE
Oracle can shrink tablespaces, you can find how to do it searching
Metalink for this article: "1029252.6 How to Resize a Datafile"
Best regards,
Antonio Delgado.
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: martes, 03 de agosto de 2004 22:00
To: [EMAIL PROTEC
Thank you for trying to help me.
The output is wrong
I get either
Event 1
Event 2
Details 1 for event 1
Details 2 for event 1
Details 3 for event 1
Or
Event 1
Details 1 for event 1
Details 2 for event 1
Details 3 for event 1
Event 2
Details 1 for event 1
Details 2 for event 1
Details 3 for
HI
MD5 would be a good way of doing it. Just add a column to your user table
and
UPDATE users SET subscribed = 0 WHERE encryptedID = "md5 hash here"
HTH
Peter
> -Original Message-
> From: Scott Haneda [mailto:[EMAIL PROTECTED]
> Sent: 04 August 2004 03:37
> To: MySql
> Subject: Best
Hi,
mysqldump has an flag '-Q' which quotes all table and column names. But
what about the database names? They will not be quoted (in the CREATE
and USE statements)!
During transformation of databases from a 3.23 server to 4.1 I have some
databases with '-' inside the name (obviously this was p
75 matches
Mail list logo
