Hi.
Opens: ~4000 - 2
Queries p/s avg: 10 till 60
Thx for helping
Greetz
Daniel
-Ursprüngliche Nachricht-
Von: Egor Egorov [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. Februar 2002 18:38
An: [EMAIL PROTECTED]
Betreff: Which Hardware do I need ?
Daniel,
Monday, February 04,
Hi.
Our queries seem well optimized, maybe there are some slow queries
in there but sometimes you have no other choice and we are using indexes.
Our Key Buffer size is about 16MB (standard).
Thx for helping ...
Greetz
- Daniel
-Ursprungliche Nachricht-
Von: Jeremy Zawodny [mailto:[E
MYSQL
sql,query
is anybody know when suppost to be support to views ?
|\_.._/|
| o o |
(=T=)
^'-^-'^.
'. ; .'
| | | | |
((_((|))_))
Best Regards from the Cat
Noam Cassif([EMAIL PROTECTED])
Raz Systems LTD
http://www.raz.co.il
--
MYSQL
sql,query
is anybody know when suppost to be support to views ?
|\_.._/|
| o o |
(=T=)
^'-^-'^.
'. ; .'
| | | | |
((_((|))_))
Best Regards from the Cat
Noam Cassif([EMAIL PROTECTED])
Raz Systems LTD
http://www.raz.co.il
--
Guilhem,
this is a known problem and mentioned in the Restrictions section of the
InnoDB online manual.
It is not the correct way to run SQL statements in the autocommit mode on
the slave server, while the master has normal transaction processing on.
I have asked Sasha to add COMMIT marks to th
Dear members,
1) How can we know the no. of disk accesses & main memory used to execute
a particular query in mysql ?
2) Is any one familier with mysql source code for windows.
Plz help me in this as I desparately need this information at the
earliest.
Plz reply asap.
Thanx in advance..
Pra
Hi,
I just installed mysql in my Solaris (Sparc) box, but when I run mysql
( mysqld running ), I get the following err,
ld.so.1: bin/mysql: fatal: libncurses.so.5: open failed: No such file
or directory
Killed
Any help will be appreciated!
---
Hi,
A 16MB key buffer seems very small; this is OK for a personal workstation
with 64/128MB RAM not for a high performance 1GB server.
If your queries are using indexes, you should check
Key_read_requests and Key_reads values, if your query buffer is
efficient, Key_read_requests should be MUCH
Hi all,
I want to connect a MySQL client from Windows NT to SUN Solaris 2.6.
How can I do this? I need some services running in the Server (in my case, SUN
Solaris). What means the message:
"Host is not allowed to connect to this MySQL server" ??
Thanks in advance
06.02.02 11:42:26, Marcelo Muzilli <[EMAIL PROTECTED]> wrote:
>Hi all,
> I want to connect a MySQL client from Windows NT to SUN Solaris 2.6.
> How can I do this? I need some services running in the Server (in my case, SUN
>Solaris). What means the message:
>
> "Host is not a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm planning a *very* simple DB to place tips on small biz websites on.
I'm having a little trouble conceptualizing how it might work.
My schema runs like this:
2 tables
content TipId | AuthId | title | keywords | desc | section | text
On Wed, 2002-02-06 at 11:22, Nick Wilson wrote:
> 2 tables
> content TipId | AuthId | title | keywords | desc | section | text
> author AuthId | name | email | bio
>
> My question is: If I enter a 'tip' and put myself as the author, when
> /I/ come to write another tip how do I make my
Ben,
Tuesday, February 05, 2002, 11:42:50 PM, you wrote:
BO> Hi;
BO> I get this error when I try to access a database as root:
BO> mysql>> use antigo;
BO> Can't read dir of './antigo/' (Errcode: 13)
BO> What does this mean and how do I fix it?
That means your unix user doesn't have privileges o
Cindy,
Tuesday, February 05, 2002, 11:58:45 PM, you wrote:
C> Sorry, I know this is documented somewhere, because I've seen it,
C> but I can't find it now, nor remember exactly what it said.
C> When I try to connect to the mysql server (mysql -u root -p ),
C> I get an error about /tmp/mysql.so
admin,
Wednesday, February 06, 2002, 4:40:30 AM, you wrote:
a> hello,
a> This is my problem and question:
a> I installed mysql-3.23.36 when I installed the RedHat7.1, but now I want to
install mysql-3.23.47 to the platform and I hope the two versions are both useful. How
should
Marcelo,
Wednesday, February 06, 2002, 12:42:26 PM, you wrote:
MM> Hi all,
MM> I want to connect a MySQL client from Windows NT to SUN Solaris 2.6.
MM> How can I do this? I need some services running in the Server (in my case,
SUN
MM> Solaris). What means the message:
MM>
Noam,
Wednesday, February 06, 2002, 11:37:13 AM, you wrote:
NC> MYSQL
NC> sql,query
NC> is anybody know when suppost to be support to views ?
It will be sopported in MySQL around Version 4.1
See at: http://www.mysql.com/doc/A/N/ANSI_diff_Views.html
NC> Noam Cassif([EMAIL PROTECTED])
NC> Raz Sy
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Diana Soares declared
> On Wed, 2002-02-06 at 11:22, Nick Wilson wrote:
> > 2 tables
> > content TipId | AuthId | title | keywords | desc | section | text
> > author AuthId | name | email | bio
> >
> > My question is: If I
Hi!
> "Alex" == Alex Aulbach <[EMAIL PROTECTED]> writes:
Alex> I found out, that the fulltext engine is misbehaving with less than 5
Alex> entries. Seems to me, that this is exactly the same case...
Alex> Perhaps a flush inside the engine or so isn't made with such less entries?
Alex> The
i have a log file in which i record every visit of my site, although some
times a visitant came by the morning and by the night or something alike, so
i am trying to create a select command which count the ip every since he
came back a hour afther of his last visit, the command is just like this:
Hi guys,
Has anyone successfully used MySQL as the backend database for tape/file
cataloguing on ArcServe 2000/Brightstor ?
I can get Arcserve to work fine with MS SQL (runs for cover) but it wont
work with MySQL.
To be honest I dont have much indepth knowledge of MySQL, so any help is
grateful
On Wed, 2002-02-06 at 11:52, Nick Wilson wrote:
> > You can always use INSERT for the "content" table and REPLACE for the
> > "author" table.
>
> I don't think that would work as it will change the AuthId and effect
> any other 'tips' I've written.
> Each author should have one entry in 'author'
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Diana Soares declared
> No. You're right!
> Unless you generate your own AuthId (with date, not auto-incremented), i
> think you will have to do a SELECT in the "author" table to get his ID
> /you will need it to insert a new tip in t
Nick,
> I don't think ...
> Am I talking rubbish?
An admission and then an invitation??? Boy you must some masochist!
You asked a question, it was answered (and there's usually more than one way to skin
the proverbial cat); and
then you appear to argue.
"Thinking" is not as good as "testing":
Franklin, Kevin writes:
> We are running an extremely large instance of mysql version 3.23.46 on
> Solaris 2.8. We are attempting to use a software version compiled 64 bit
> and have been experiencing memory related server crashes.
>
> The behavior suggests that we are still unable to use more
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then [EMAIL PROTECTED] declared
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
On Wed, Feb 06, 2002 at 02:57:51PM +0200, Sinisa Milivojevic wrote:
> Franklin, Kevin writes:
> > We are running an extremely large instance of mysql version 3.23.46 on
> > Solaris 2.8. We are attempting to use a software version compiled 64 bit
> > and have been experiencing memory related serve
Hi
Is it possible to connect to a MySQL Database running on a Linux server from
an workstation running Mac OS 9.0 using ODBC ? i.e. does it exist any ODBC
drivers for MySql to use from Mac ?
Best Regards
Jan Eskilsson
-
Before
hello,
we are using mysql on a windows98 machine. But a lot of times the tables in
the database keep crashing. When checking it says:
1 client did not close connection...
table marked as crashed (not always this line)
with different tables
does anyone had this problem also?
Willem
---
Jan Eskilsson wrote:
>
> Hi
>
> Is it possible to connect to a MySQL Database running on a Linux server from
> an workstation running Mac OS 9.0 using ODBC ? i.e. does it exist any ODBC
> drivers for MySql to use from Mac ?
I myself use and beta test MacSQL: http://www.rtlabs.com/macsql/
It is
Hi
I want to retrieve a row of MySQL data using Perl and DBI, so I do it like
this:
[code]
my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|;
$sth = $dbh->prepare($sqlquery);
$sth->execute or die("Can't execute SQL query. [$DBI::err]
$DBI::errstr");
Nick,
> Well I /hadn't/ tested as I wasn't sure that my DB design wasn't flawed,
> I was expecting someone to say 'well if you want to do that you need to
> design like this..' No matter.
Again: if you use the native-MySQL/command line, or an administration/management
package, you will be able
Hi,
I am making a form for editing the rows in a table. It displays each row
as a row in a table(structure id tinyiny,name varchar(30) ), with the
value inside a textbox so it can be changed. When doing the $submit to
MySQL, I need do this:
for($count=0;$count<=$i;$count++)
{
$cur
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
Heikki> Guilhem,
Heikki> this is a known problem and mentioned in the Restrictions section of the
Heikki> InnoDB online manual.
Heikki> It is not the correct way to run SQL statements in the autocommit mode on
Heikki> the slave ser
Hey All!
Anyone know the difference between MySQL and PostgreSQL?
Are the both pretty much the same? So far I like MySQL, but
find that MS SQL is far greater, but only because it has
much more. Anyone have any comments on the matter?
-
jeremy,
Tuesday, February 05, 2002, 8:32:23 PM, you wrote:
jr> following the instructions for resetting a password (
jr> http://www.mysql.com/doc/R/e/Resetting_permissions.html ),
jr> i was not able to find the .pid file. is it possible to continue the process
jr> without killing it?
If you hav
Hello, I'm new to Unix and MySQL.
I would like to store binary data in MySQL, but cannot find any sample code
on how to go about doing this in C.
The binary data is variable size ranging from 3k to 10k. I want to store it
in a row along with a User ID so I can retrieve it by doing a query on this
Hi.
No, Postgres has much more. The biggest point is, that it has
Subselects ! But mySQL seems to be much faster in some points.
That´s all I want to tell :)
Greetz
Daniel
-Original Message-
From: Vernon A Webb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 3:59 PM
To:
michael.s,
Wednesday, February 06, 2002, 12:22:15 PM, you wrote:
msÉ> Hi,
msÉ> I just installed mysql in my Solaris (Sparc) box, but
msÉ> when I run mysql ( mysqld running ), I get the following
msÉ> err, ld.so.1: bin/mysql: fatal: libncurses.so.5: open
msÉ> failed: No such file or dire
On Wed, 2002-02-06 at 07:51, Matt Rudderham wrote:
> Hi,
> I am making a form for editing the rows in a table. It displays each row
> as a row in a table(structure id tinyiny,name varchar(30) ), with the
> value inside a textbox so it can be changed. When doing the $submit to
> MySQL, I need do
On Wed, 2002-02-06 at 07:59, Vernon A Webb wrote:
> Hey All!
>
> Anyone know the difference between MySQL and PostgreSQL?
> Are the both pretty much the same? So far I like MySQL, but
> find that MS SQL is far greater, but only because it has
> much more. Anyone have any comments on the matter
Dear all,
today I have switched from myodbc 2.50.39.00 to 3.51.01.00,
because I had a problem using SQLColumnPrivileges (see below)
After that I couldn't use my application because of the
ConnectionHandle was destroyed. After logging the application I
have found, that there is an problem insi
I have a site using PHP & Mysql. About a month ago to now one of the tables
gets corrupted with the message Got Error 127... I fix it and everything
works OK, except every time I loose 1 record.
Today I could obtain mysql.err from the machine and I could see whenever an
error is produced by date,
Hi everyone,
When using replicate-ignore-table in mysql, does filtering happen before
or after transmission from the master to the slave?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then DL Neil declared
> > > > >
> > > > > My question is: If I enter a 'tip' and put myself as the author, when
> > > > > /I/ come to write another tip how do I make my query avoid putting
> > > > > another entry in author? I'll be using P
> -I/usr/include -I./../include
>
> -I./../regex-I. -I../include -I.. -I.
> mysqld.cc:1767: implicit declaration of function `int regex_init(...)'
A carefull look reveals that the commandline above is seeing
/usr/include/regex.h instead of /
Can you send exact message as this one to [EMAIL PROTECTED] ??
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<__
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
Subject: Mysqld hangs on initialization with mysql_install_db.
>Description:
when running the databse installation script,
Hello,
I am relatively new to Mysql. I am have a strange problem that is
preventing me from setting up
my database to test out mysql as a backend to an IDS system. When I
start the mysql command
I get the following output.
srsids01# ./mysql
Welcome to the MySQL monitor. Commands end with ; or \
Albert Chin writes:
>
> MySQL 3.23.46 was built with the Sun C++ compiler:
> $ CC -V
> CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19
>
> It was built as follows:
> CC=cc CFLAGS="-mr -Qn -xstrconst -xO2 -xtarget=generic -xarch=v9" \
> CXX=CC CXXFLAGS="-xO2 -xtarget=generi
i have a log file in which i record every visit of my site, although some
times a visitant came by the morning and by the night or something alike, so
i am trying to create a select command which count the ip every since he
came back a hour afther of his last visit, the command is just like this:
Legault, Alain writes:
> SEND-PR: -*- send-pr -*-
> SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
> SEND-PR: will all comments (text enclosed in `<' and `>').
> SEND-PR:
> Subject: Mysqld hangs on initialization with mysql_install_db.
Hi!
A usual cause for the above be
I am looking for a way to use MySQL on a Windows 98 platform with the
gnu tool set. The binaries that came with the Win32 version of MySQL
seem to be for Microsoft. The function names have an '@n' appended to
them with the 'n' being the number of bytes for the arguments.
Therefore, even though the
"Vernon A Webb" <[EMAIL PROTECTED]> writes:
> Anyone know the difference between MySQL and PostgreSQL?
PostgreSQL has a lot of features MySQL don't have yet (transactions
everywhere, foreign keys, subselects, stored procedures, triggers,
etc), while MySQL is heavily optimized for handling big l
On Wed, Feb 06, 2002 at 06:12:22PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > MySQL 3.23.46 was built with the Sun C++ compiler:
> > $ CC -V
> > CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-03 2001/10/19
> >
> > It was built as follows:
> > CC=cc CFLAGS="-mr -Qn -xs
I have a table with 2.9 mil records which represents 197k sentences stored
vertically. I do this because I need to know information about each word
and its relationship to other tables.
I want to know how many words have a particular word-group ID before and a
particular word-group ID after the
Trond Eivind Glomsrød writes:
> "Vernon A Webb" <[EMAIL PROTECTED]> writes:
>
> > Anyone know the difference between MySQL and PostgreSQL?
>
> PostgreSQL has a lot of features MySQL don't have yet (transactions
> everywhere, foreign keys, subselects, stored procedures, triggers,
> etc), while M
I have MySQL running on my FreeBSD server and I want to connect to it from
my Windows 2000 workstation using mysqlgui.
I put the ip address of the FreeBSD server in the my.cnf file under host,
but it keeps trying to connect to the Win2000 machine instead of the FreeBSD
box.
Am I doing something wr
On Wed, 6 Feb 2002, Sinisa Milivojevic wrote:
> Trond Eivind Glomsrød writes:
> > "Vernon A Webb" <[EMAIL PROTECTED]> writes:
> >
> > > Anyone know the difference between MySQL and PostgreSQL?
> >
> > PostgreSQL has a lot of features MySQL don't have yet (transactions
> > everywhere, foreign k
Sommai,
Wednesday, February 06, 2002, 8:01:13 AM, you wrote:
SF> Hi,
SF> I need to know that MySQL has any compression method when it store
SF> data? If the answer is Yes, How the different compression between MySQL
SF> and other tools (zip, gzip)? I asked this question because I nee
On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote:
> Trond Eivind Glomsrød writes:
> > "Vernon A Webb" <[EMAIL PROTECTED]> writes:
> >
> > > Anyone know the difference between MySQL and PostgreSQL?
> >
> > PostgreSQL has a lot of features MySQL don't have yet (transactions
> >
On Wed, Feb 06, 2002 at 01:57:21PM +, Wiliam Stephens wrote:
> Hi
>
> I want to retrieve a row of MySQL data using Perl and DBI, so I do it like
> this:
>
> [code]
> my $sqlquery = qq|SELECT * FROM ata_members WHERE id=$id|;
> $sth = $dbh->prepare($sqlquery);
> $s
Albert Chin writes:
>
> $ grep SIZEOF_LONG config.h
> #define SIZEOF_LONG 8
> #define SIZEOF_LONG_LONG 8
>
> $ grep SIZEOF_LONG incldue/my_config.h
> #define SIZEOF_LONG 8
> #define SIZEOF_LONG_LONG 8
>
> --
> albert chin ([EMAIL PROTECTED])
>
If SIZEOF_INT is 4, then it could be our bug.
P
The way I look at it, MySQL gives you a choice of table types, so you
can pick the one best suited to the task at hand. For raw speed where
you can do without transactions, you can go with MyISAM. Otherwise you
have Innobase. I'm not sure where/why db3 fits in, haven't been
bothered to look int
[redirecting to mysql list because of general interest]
Yoram Naim wrote:
> Can some one send me a code sample (C , CPP )
> How can I copy file data to MYSQL BLOB field
> but not in one piece .
Is this even possible? If so, I'm sure that the JDBC driver could use such
a feature to stream lar
Trond Eivind Glomsrød writes:
> On Wed, 6 Feb 2002, Sinisa Milivojevic wrote:
>
> I said "everywhere" - you need to use Innobase to get foreign keys, and
> innobase/db3 to get transactions.
>
> --
> Trond Eivind Glomsrød
> Red Hat, Inc.
>
>
As EVERY binary and source we distribute has Inno
Jorge Guerra writes:
> I have MySQL running on my FreeBSD server and I want to connect to it from
> my Windows 2000 workstation using mysqlgui.
> I put the ip address of the FreeBSD server in the my.cnf file under host,
> but it keeps trying to connect to the Win2000 machine instead of the FreeBSD
Hi,
> -Original Message-
> From: Peter Klinge [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 06, 2002 5:33 AM
> To: [EMAIL PROTECTED]
> Subject: Error in myodbc 3.51.01.00
>
>
> Dear all,
>
> today I have switched from myodbc 2.50.39.00 to 3.51.01.00,
> because I had a proble
On Wed, 6 Feb 2002, Sinisa Milivojevic wrote:
> Trond Eivind Glomsrød writes:
> > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote:
> >
> > I said "everywhere" - you need to use Innobase to get foreign keys, and
> > innobase/db3 to get transactions.
>
> As EVERY binary and source we distribute ha
Hi,
> -Original Message-
> From: Shankar Unni [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 06, 2002 9:29 AM
> To: Yoram Naim
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: blob field
>
>
> [redirecting to mysql list because of general interest]
>
> Yoram Naim wrote:
>
> > Can some one
Albert Chin writes:
> On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
>
> Yes, SIZEOF_INT is 4:
> $ grep SIZEOF_INT config.h
> #define SIZEOF_INT 4
> $ grep SIZEOF_INT include/my_config.h
> #define SIZEOF_INT 4
>
> --
> albert chin ([EMAIL PROTECTED])
>
We shall ha
Hello All
I am new to MySQL 3.23.42 and I installed it on a Windows 2000 system. I
need a database with both English and Arabic records (the fields name not
necessarily in Arabic). I searched the archive of the list and the manual
and although I found some messages about Arabic, I could not figur
Hi there,
I am really new at PHP & MySQL, so please bear with me.
I am using the mysql_insert_id function but continually receive an error,
and hoping someone can point me in the right direction to resolve this.
My error:
Warning: Supplied argument is not a valid MySQL-Link resource on line 44
Trond Eivind Glomsrød writes:
> On Wed, 6 Feb 2002, Sinisa Milivojevic wrote:
>
> It's enabled in the MySQL rpms we distribute as part of RHL as well, but
> it's not the default type for created tables. Thus, most people won't be
> using it. If memory serves, you need to set various options in
Albert Chin writes:
> On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> Yes, SIZEOF_INT is 4:
> $ grep SIZEOF_INT config.h
> #define SIZEOF_INT 4
> $ grep SIZEOF_INT include/my_config.h
> #define SIZEOF_INT 4
>
> However, according to
>
>http://docs.sun.com/ab2/coll.4
Venu wrote:
> Its possible with MyODBC Drivers to 'n' size. You can
> supply BLOB/CLOB data in pieces to desired size by
> making use of SQLParamData and SQLPutData APIs.
Does the MySQL wire protocol support this? Or is MyODBC emulating this by
reading and updating the entire blob after each p
On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> >
> > $ grep SIZEOF_LONG config.h
> > #define SIZEOF_LONG 8
> > #define SIZEOF_LONG_LONG 8
> >
> > $ grep SIZEOF_LONG incldue/my_config.h
> > #define SIZEOF_LONG 8
> > #define SIZEOF_LONG_LONG 8
> >
> >
[EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text
On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote:
> Albert Chin writes:
> > On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote:
> > Yes, SIZEOF_INT is 4:
> > $ grep SIZEOF_INT config.h
> > #define SIZEOF_INT 4
> > $ grep SIZEOF_INT include/my_config.h
> >
Hi Andrea,
> I am really new at PHP & MySQL, so please bear with me.
welcome to our happy band...
> I am using the mysql_insert_id function but continually receive an error,
> and hoping someone can point me in the right direction to resolve this.
>
> My error:
> Warning: Supplied argument is n
hello,
i tried to connect my MySQL-Server with a short java application. The
application can't connect to the server, obviously the server is running on
localhost:3306. I append the SourceCode (roughly the same:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak
) and th
Albert Chin writes:
>
> Ok. Guess we'll wait for a fix. Any idea when a fix for MySQL will be
> available?
>
> --
> albert chin ([EMAIL PROTECTED])
>
Just look into Changelog's of the versions that come out.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa M
Almost, but not exactly the same .
DriverManager.getConnection(dburl, dbuser, dbpasswd) <-- note, 3 arguments
here
> -Original Message-
> From: debian [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 06, 2002 1:59 PM
> To: [EMAIL PROTECTED]
> Subject: Cannot connect to MyS
Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> Trond Eivind Glomsrød writes:
> > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote:
> >
> > It's enabled in the MySQL rpms we distribute as part of RHL as well, but
> > it's not the default type for created tables. Thus, most people won't be
> > usi
Trond Eivind Glomsrød writes:
> Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>
> There is a slight difference between advanced, non-standardized
> tuning/backup/load-balancing like that and core SQL functionality not
> being present.
>
> --
> Trond Eivind Glomsrød
> Red Hat, Inc.
>
This dep
But you could already read any file that the web server can read, if you can
execute scripts which are run as the webserver. Only way to prevent that is
suEXEC. How is this specific to MySQL?
> 1) Webserver must be able to read HTML files of every WebUsers
> 2) MySQL functions are called with u
thnx for answering, but if i use your suggestion, i get the same
errormessage. who can help me?
- Original Message -
From: "Lee, Andrew" <[EMAIL PROTECTED]>
To: "'debian'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 8:23 PM
Subject: RE: Cannot connect to M
Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> Trond Eivind Glomsrød writes:
> > Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> >
> > There is a slight difference between advanced, non-standardized
> > tuning/backup/load-balancing like that and core SQL functionality not
> > being present.
>
Hi,
Now I am puzzled by the filepath,Load_file, I install
MySQL in Windows98, the file which i want to insert to
table is c:\P1.bmp
when I run load_file in mysql command line,it succeeds
mysql> insert into blobtable (load_file("/P1.bmp"))
but i don't know why i should use slash instead of
backsl
I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB
data files,
but mysql is telling me that the files must be <= 4096MB
This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a
reiserfs filesystem...
I don't think there should be such a low limit...I acci
Howdy,
I'm trying to reset a forgotten password for a MySQL server, and I can't
kill mysqld via the method mentioned in the documentation (or by any method
for that matter). When I try using the command...
kill 'cat /var/lib/mysql/mysqld.pid'
...I get a message saying that there is no such p
First off, you trying to insert the image into the database or just its
path?
-Original Message-
From: yue cheng [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:23 PM
To: [EMAIL PROTECTED]
Subject: Load_File issue
Hi,
Now I am puzzled by the filepath,Load_file, I inst
Though this is a PHP issue, for those that use PHP here's what was wrong:
mysql_insert_id() requires
your connection link identifier, which is what is returned from mysql_connect and
mysql_pconnect.
This is contrary to almost all other mysql_ functions, which want the result resource
returned f
Hey all,
Is it possible to copy the contents of one column to another column using
mySQL? I just
changed my table structure by adding a few more columns and I need to be
able to move the data from the original column to 4 new columns and then
drop the orginial. I know that the proper query for sq
If you need to, use the "kill -9
-9 is a definite kill and it will work
-Original Message-
From: JP Audette [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:52 PM
To: [EMAIL PROTECTED]
Subject: having trouble killing mysqld to restart and change root
password
Howdy,
I
On Wed, Feb 06, 2002 at 04:10:33PM -0500, Max Mouse wrote:
> Hey all,
>
> Is it possible to copy the contents of one column to another column
> using mySQL? I just changed my table structure by adding a few more
> columns and I need to be able to move the data from the original
> column to 4 new
Ye, that did the trick. I was able to get the daemon restarted using the
--skip-grant-tables & option, however now I can't connect to the
monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try
using /usr/bin/mysql -h hostname mysql
Anyone know why I can't get the monitor
Amendment to that last post
I don't think the daemon is starting properly, because I can't run a
mysqladmin version - I just get a hung cursor.
Does anyone know if there's something that would be stopping mysqld from
loading with the --skip-grant-tables option? When I do a ps I can see th
> Ye, that did the trick. I was able to get the daemon restarted using the
> --skip-grant-tables & option, however now I can't connect to the
> monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try
> using /usr/bin/mysql -h hostname mysql
>
> Anyone know why I can't get
On Wednesday 06 February 2002 12:15 am, you wrote:
> I am trying to find the problem but, error file shows stack trace
> ? which I could not understand.
Bharat:
Please follow the instructions in the manual section that the stack trace
message is referring you to. This will tell you how to reso
1 - 100 of 120 matches
Mail list logo
