Are you using MySQL 4.x sumthing?
I thought that function was taken out and replaced with
mysql_real_connect()?
I may be wrong.
-Original Message-
From: Julie Meloni [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 10:35 AM
To: Tewfic Kidess
Cc: [EMAIL PROTECTED]
Subject: Re:
Hi,
I just installed MySQL 3.23.49 on NT and executed the following
commands:
UPDATE USER SET password=password(test1) WHERE host=localhost;
UPDATE USER SET password=password(test1) WHERE host=%;
Now, after doing 'mysqladmin reload', I cannot connect...
mysql -p
Enter password
is complete, the user will have access to the a results folder
in the system containing a list of their submitted analysis (either
pending or complete).
Can anyone offer any advice/suggestions on how this can be accomplished?
Thank you very much for your time.
- Best regards,
Lee Reilly
--
Lee P. Reilly
Hi ,
My aim is to avoid mysql connects to the DB my application does
not run as a daemon .
But the parent of this program runs as a daemon , so can someone tell me
how I would make use of the same Mysql handler in the execed child also
assuming I connect to the Mysql Server in the parent ?
On Fri, 2002-03-08 at 14:19, [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
Hello,
You probably need to check the permissions for the directory that mysql is
trying to create the databases in. Make sure mysql has write permissions in
the directory. then run mysql_install_db again and you should be ready to
go.
- Original Message -
From: jake williamson 28
Hi,
I wonder if anyone can offer me some advice with this one:
I have a table called 'iq_data' holding just a primary key and a field
called 'iq_data'.
+++--+-+-++
| Field | Type | Null | Key | Default | Extra |
.
such requests should be sent to [EMAIL PROTECTED]
I did this in hopes of making things easier for people (and myself) who want
to try the new stuff out without downloading and compiling themselves.
Have fun.
Brian P. Austin
query, mysql, server
http://www.linuxmonsters.com
sorry about that
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 3:41 PM
To: 'Brian P. Austin'
Cc: mysql
Subject: RE: RPMS for Development Branch
and the URL is???
it's not www.codemonsters.net; I just
Hi,
When I run perl run-all-tests --server=mysql --cmp=mysql,pg,solid
--user=test --password=test --log in the sql-bench direcotory. I
encountered following error messages:
Can't locate DBI.pm in @INC (@INC contains:
/usr/lib/perl5/5.6.0/ia64-linux /usr/lib/perl5/5.6.0
I have finished a script that takes the bit keeper sources and makes
MySQL-4.0.2 RPMS for Redhat 6.x and apparently 7.X as well. I can put these
up on our site for download if you want. They might get others trying the
code out.
I use the spec file included with the source code.
I'll put it up
what command are you issuing.
is it mysql? If so, what arguments are you sending it?
It should look like this
mysql -u user -p
prompt: password
-Original Message-
From: Cliff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 9:18 PM
To: [EMAIL PROTECTED]
Subject: Using
Description:
Executing a SELECT DISTINCT statement in conjunction
with the BINARY cast operator will crash MySQL server
when the column being cast contains one or more null
values.
How-To-Repeat:
Executing the following code from a mysql prompt will
cause the MySQL server to
When using the BUILD/compile-pentium and BUILD/compile-pentium-pgcc I get
the following errors..
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -Wimplicit
-Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W
-Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int
Hi,
I've a problem in order to install Mysql server 3.23.47 on NT 4 box
when I try to run the file setup.exe, I get an error msg like this:
*I can't run a 16 bit program the file setup.exe is damage. Try to
reinstall* (!?!?!?)
I've never seen this error ... anyone can help me in order
Hi Victoria,
echoplusAT *I can't run a 16 bit program the file setup.exe is
damage. Try to
echoplusAT reinstall* (!?!?!?)
echoplusAT I've never seen this error ... anyone can help me in order to
solve this
echoplusAT prob?
May be you have a corrupted installation package. Try to
constraints in its table
creation commands. Is there any way to retrieve these?
--
/---
| Robert P Ricci [EMAIL PROTECTED] || [EMAIL PROTECTED]
| Research Associate, University of Utah Flux Group
| www.cs.utah.edu/flux || www.emulab.net
, that's causing you
trouble.
Luckily, in my case, our database is sufficiently small (on the order of
tens of thousands of rows spread out across ~50 tables) that this isn't
really an issue.
--
/---
| Robert P Ricci [EMAIL PROTECTED
Hello,
Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the
documentation apply equally to HEAP tables in v. 4.0?
Or, rather, if memory and address space were unlimited, how large could a heap table
possibly be in v. 4.0?
TIA
Tim Banach
State Street
Hello,
Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the
documentation also apply to HEAP tables in v. 4.0?
Or, rather, if memory and address space were unlimited, how large could a
heap table possibly be in v. 4.0?
TIA
Tim Banach
State Street Corporation
Westwood,
I believe you could use CONCAT(firstname, ' ', lastname) LIKE
'%$searchname%'
if you leave the space out of the middle it probably won't work, and you
might want to trim firstname lastname to make sure no leading or trailing
spaces exist.
Hope this helps,
P
-Original Message-
From
Hello,
Can mySQL be configured to run entirely in-memory? That is, can one
configure it so that all the tables, data, etc. remain resident in memory
and are never written to disk?
TIA,
Tim Banach
-
Before posting, please
I was wondering is there anyway to change the socket location from
/tmp/mysql.sock to something else, other than recompiling :-)? If there is
not I would like to highly recommend it as an option.
TIA
stevet
_
Do You Yahoo!?
Get your
If you are using the MySQL RPMS for RedHat, They install in the /usr directory.
(Redhat dows things differently)
So it would be
./configure --with-mysql=/usr for PHP compilation.
as far as upgrading... I have used RedHat for a long time, and have found that in
their newest distos, it is
The RPMS that are available from the MySQL WebSite are OK to use on 6.2.
I personnaly prefer to use the source or .src RPMS.
But the RPMS work fine on my 6.2 box.
[EMAIL PROTECTED] wrote:
Hello,
Which version of MySQL ( RPM packages ) is good for work with php 4.0.6
and Linux Red Hat 6.2 ?
Hi all,
I'm looking for a posibility to count the datatraffic of a database at my
mysqldb-server.
The clients should got only select-rights on thier databases. And I need to
count the resultset datatraffic of their select-queries.
I'm using mysql version 3.23.39.
I was looking for some
SHOW STATUS will give you an indication on how much
traffic is moved between your server and the clients
(look for bytes sent and bytes received) - but
only the totals for the server are displayed. I very
much doubt you can get the data by client or connection.
I'm curious as to *why*
Hi,
I am new to MySQL. I installed it on Win 98 and trying
to invoke the mysqld. First it gave me a strange error
that innodb_data_file_path is not found. I copied the
following from manual (I dont really want to create
such 2GB files though !).
mysql, query, server
there is probably a cron job or sumptin that is deleting your sock file. Try putting
it in a different place.
[EMAIL PROTECTED] wrote:
Description:
/tmp/mysql.sock is there and then apparently randomly its removed without
warning.. mysql still accepts TCP connections
on Freebsd system but when i launch mysql i
said me can't connect to localhost /tmp/mysql.sock not found.
How can i repair this error?
First, you can refrain from posting the same question twice.
Second, you can RTFM before posting - specifically,
http://www.mysql.com/doc/P/r
Hi anybody,
am a newbie to mysql and i want to install
master/slave mysql server for replication.
can anybody please desc
from the scratch (user rights)
of configuring 2 mysql servers in
master/slave fashion for replicatiom.
thanx in advance.
bye
kamesh
Dear Anyone
I am one of the Linux user. I use the
freebsd operating system.
I have one main problem. After installation
completed , I put the command mysql in #prompt.
But some error message will shows, I don't
know how to solve it.
The Error message is
me too facing the problem
in creating users and granting permission
please help me
Hi,
We are facing problem with mysql on linux.
We are unable to give the password for admin user.
Can you please give all the list for installation and
user creation as well as for uninstalling?
Thanks,
Just a thought - if your serial numbers have fixed format, then
programmatically remove the hyphen and store the number without it. Add it
back when displaying data on the screen. That way FULLTEXT will work on the
whole number without splitting it into two parts.
Vadim.
Marty McCoy wrote:
Jose--
Are you running mysqld as 'root'?
Run it as 'mysql' and change the group membership of the data directory and
its contents to 'mysql'.
Vadim.
Jose de Leon wrote:
Here are the perms on the mysql db files /var/lib/mysql/mysql
Also, I was logged into mysql with a plain user 'jose'
I have been told it is possible to embed MySQL in an application such that
the user never knows a database is running underneath the app. Where can I
find more information about doing this?
--
Shawn P. Garbett [EMAIL PROTECTED]
See http://www.garbett.org/public-key for my PGP key
as part of the next release. Problem is I have to demonstrate it
NOW, or I may end up stuck with MSDE since it exists NOW. MySQL is my
preferred option and I'd love to stick with it across all platforms the
product will be ported to.
--
Shawn P. Garbett [EMAIL PROTECTED]
See http
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Freakin' Spam filter!!!
- -- Forwarded Message --
Subject: Re: Fwd: Re: Embedding MySQL in an application
Date: 9 Aug 2001 14:07:44 -
From: [EMAIL PROTECTED]
To: Shawn P. Garbett [EMAIL PROTECTED]
Your message cannot
Austin
On Thu, 9 Aug 2001, Alex Page wrote:
From: Shawn P. Garbett [EMAIL PROTECTED]
Sent: Thursday, August 09, 2001 3:07 PM
Subject: Fwd: Re: Embedding MySQL in an application
The real point is, that a user can take the product out of shrink rap,
install it, run the program and never
Hello,
SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc
gcc version 2.95.3 20010315 (release)
I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box.
I get the following error which has me completly confussed:
ctstset: Compile tstset.cc -- tstset.[c|s] -- tstset.o
Assembler:
On Sun, 5 Aug 2001, SOHM Philippe wrote:
Hi,
I'd like to add a function MD5() to mysql with CREATE FUNCTION
Someone can help me ? I know nothing in C
Philippe
That might be a problem if you wnat to compile in your own function.
You might want to try a UDF instead. I don't use them
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file mes0501.xls.pif
The file mes0501.xls.pif is moved to /var/tmp/virCOE0PgUxY.
-
Hi! How are you?
I send you this file in order to have your advice
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file T_chamado06f.xls.lnk
The file T_chamado06f.xls.lnk can not be moved because /var/tmp/virSIA0zg7eo: No space
left on device.
-
Hi! How are you?
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file 01062001.xls.bat
The file 01062001.xls.bat is moved to /var/tmp/virPKB0HQl_p.
-
Hi! How are you?
I send you this file in order to have your
-- Virus Warning Message (on tjintranet)
Found virus TROJ_SIRCAM.A in file unix1.zip.com
The file unix1.zip.com is moved to /var/tmp/virANB0.nrHt.
-
Hi! How are you?
I send you this file in order to have your advice
helo
anybody there to help me for my project
my project is on PERL and Mysql in Linux
please say me the procedure to
study those stuffs.
thanx in advance
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
Has anyone seen any documentation for using mysqld as a library.
I am building an embedded device on a machZ chipset, and I would really
like to be able to use mysql for some internal querying of our data
collection.
I can get it to run (barely) as is, but need more room and memory for other
Hello,
Can anyone tell me if the MySQL database has a defualt user ID and
password? I am trying to access a remote DB with my application, but am
experiencing difficulties. This may be because I need correct user access
details. Are there such details, and if so, what are they please?
--
Forwarded message:
From [EMAIL PROTECTED] Tue May 1 14:37:53 2001
Date: Tue, 1 May 2001 14:37:53 -0500
From: Christopher P. Lindsey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Dates not compared properly?
Message-ID: [EMAIL PROTECTED]
Mime-Version: 1.0
Content-Type: text/plain; charset=us
:
1.3.19 actually, Matt :) I'm running .19 on both my Linux machine and
the G4. And as far as I can remember, PHP4.0.4pl1 worked ok on 1.3.14,
I was doing that for a while.
Z
On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote:
Apache is up to 1.3.17 at least. I would update
Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes
OR so
Also, use 'IN' instead of a series of 'OR' - this will make the query a lot
faster.
e.g. listings.Area IN ('19','24','25',...)
Vadim.
JD Daniels wrote:
I have this query built from a web form. The form
Well, if you really just want it stopped, the usual unix rule is to ps -ax |
grep mysql, read the PIDs then kill -11 [PID] kill the safe_mysqld script
first or it will restart the mysql daemon.
EISSEN Charlie wrote:
Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but
$SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
AND location = '$location' AND related_discipline = '$related_discipline',
MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY
Patrick--
yes, it might take hours, nothing wrong with your setup.
Vadim.
Patrick Goetz wrote:
I recently installed MySQL 2.23.37 from the unstable Debian package on a
dual-processor PII 350 w/ 128MB SDRAM running linux 2.4.2
For fun (since I've never tried running any of the
I think I remember getting around it by installing binutils from the GNU site.
That's generaly the problem with solaris. Open source is GNU centric, Solaris
prior to 2.8 is definately NOT.
EXT-Chung, Kenneth wrote:
Thanks. I got the gtar from the download page.
Now I have unpacked it
Sergei,
I also have the same problem, but in my case the table size exceeds 2Gb,
average record size being around 50Kb.
I'm running 3.23.37 (i686) on a dual PIII 866/ 1Gb RAM / 36Mb SCSI RAID5 w/
RedHat 7.1 (kernel 2.4).
As I type this message, MySQL is still [fulltext-] indexing one of the
Erik,
You mentioned 40Gig files on Intel platform -
what OS/DBMS did you use then? How about the performance?
Thanks,
Vadim.
Terry Katz wrote:
Erik,
If your running Linux on an Intel machine (which I assume it is), then
you've hit Linux's limit for IA32 and 2.2.x kernels .. If you want
Howdy all...
I've run into a strange date problem as of midnight, May 1, 2001 on my
i686 Linux machine running mySQL 3.23.37.
For some reason, queries can no longer compare dates properly:
mysql select count(*) from hit where date NOW()-1135560;
+--+
| count(*) |
You might want to try downloading binutils from the GNU web site. It has a
modified version of the linker libraries (ld). I still wasn't able to get past
the yacc compile even with 512MB RAM. Let me know how you make out. I ended up
using the binary distribution.
James Bonham wrote:
Help me
I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)
Perl Makefile.pl worked fine
I run make and this is what it ends with:
make[1]:
I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)
Perl Makefile.pl worked fine
I run make and this is what it ends with:
make[1]:
You've got a long way to go. "tar" is short for tape archive. It is an
ancient unix utility that takes directory and file data and builds it into a
contiguous data base file. This is for portability and manageability. You should
have to get past "gzip" before you get to "tar". gzip is a gnu
If your using "R"edhat, use "R"pm. Otherwise, use the tarball.
David Loszewski wrote:
is it recommended to install mysql by rpm or tar?
dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Dear MySQL Team
first of all, excuse my English. Im from Argentina,
Im a java developer and use MySQL database.
I connect to MySQL to Type4 Driver JDBC fron Java.
I have one machine with Mysql server in port 3306 and
another machine with an application in Java.
I want to know how to start a
hey,
i've been observing a similar kind of a problem
with mysql 3.23.32 on a Linux 2.4.2 kernel. The
backtrace that i'm getting is different, but even that
fails a sanity check. When i resolved the incomplete
backtrace, it showed me thread creation functions and
something of that sort. The
queries at that time.
Tx.
Vinod
--- "Gerald L. Clark"
[EMAIL PROTECTED] wrote: You have
mysqld set for 2000 connections.
How many threads do you have Linux configured for,
and how many are open
when
Mysqld crashs?
vinod p wrote:
hi,
thanks for the interest. The
hey..
thanks for the info...
This is the my.cnf file that i'm using -
[mysqld]
skip-locking
set-variable= key_buffer=640M
set-variable= max_allowed_packet=10M
set-variable= table_cache=640
set-variable= sort_buffer=6M
set-variable= record_buffer=6M
set-variable=
hi,
my mysql server restarts automatically when the
machine touches 100% CPU usage. any ideas why?
tx.
vinod.
Do You Yahoo!?
Get your free @yahoo.co.in address at http://mail.yahoo.co.in
-variable= back_log=2900
set-variable= connect_timeout=15
set-variable= wait_timeout=57600
set-variable= interactive_timeout=57600
Tx.
Vinod.
--- "Jeremy D. Zawodny" [EMAIL PROTECTED] wrote:
On Mon, Mar 19, 2001 at 12:34:30AM +0000, vinod p
wrote:
my mysql serve
hey,
i'm running serveral mysql servers on powerful
machines - dual processor, 2 GB memory, etc... Most of
the databases store temporary data only. I need the
maximum performance from these servers and have a lot
of connections to the database.
My problem is this - whenever the number of
Hi,
I need mysql (under linux) tool's -q (--quick "don't cache result, print it row by
row") in myodbc.
How can I configure the myodbc??
I have been using MyODBC 2.50.36 and I'm connecting to MySQL Server at Linux (Red Hat
7.0 2.2.16-22) under MS Win98.
Thanks.
h.
Hey, I can't stop laughing anymore ( that has no ironical meaning!!! ) :) :)
Good humor in this list, don't stop please
:) Philipp
- Original Message -
From: "Jason Landry" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; "John Dean" [EMAIL PROTECTED]
Cc: "Bob Hall" [EMAIL PROTECTED]; [EMAIL
I have two mysql servers, setup to replicate each other.
However, every so often, one or both starts logging;
010226 9:40:27 Slave thread: error connecting to master:Can't connect to MySQL
server on '0' (11)(107), retry in 0 sec
010226 9:40:27 Slave thread: error connecting to
Theres a long list of error messages following but the first is;
ha_berekeley.cc:105: syntax error before ')'
..deleted for brevety...
ha_berkeley.cc:297: warning! unreachable code at beginning of switch statement
Just wondering if this looks familiar to anyone. We are using FreeBSD4, gcc
exact command is "./safe_mysqld --user=mysql ". The error "010222 17:25:00
mysqld ended" happens immediately.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
nd
copying "mysqld" into it a viable option? Don't know what else to do.
Peter Skipworth wrote:
check your error log in ~mysql/var
On Thu, 22 Feb 2001, Matthew P. Marino
wrote:
exact command is "./safe_mysqld --user=mysql ". The error "010222 17:25:00
So, what do you do with a "tarball" anyways. Since compiling the source is
hopless( "sql_yacc.cc"), I'm looking for a binary.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Don't laugh,
Intel PI 166MHZ, 32MB RAM,10GB HD
FreeBSD4
MySQL3.23.33 from .tar.gz distribution
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hello,
I'm trying to compile and link MySql with a CORBA (ORBacus) client and I
get the following error message:
Undefined first referenced
symbol in file
__muldi3
/opt/mysql-3.23.32-sol8/lib/mysql/libmysqlclient.so
Hi,
I would like to find out if the Win2000 version of
mysql and myodbc support Win2000 clustering.
Thanks,
Sam
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
How many Bytes can I save in a user variable?
Because I have the following strategy:
I want to save all PrimaryKeys in a user variable
SELECT @a:=' ';
SELECT @a := CONCAT(@a, ', ', TPrimKey) FROM table WHERE condition;
so it is very important to know how many bytes can be stored.
regards
hi,
i recently downloaded mysql-3.23.32-hp-hpux10.20-hppa1.1.tar.gz ,
and tried writing a very simple code to start with .
i just made a call to mysql_init() and mysql_connect() in the
sample code .
i used aCC ( version : aCC: HP ANSI C++ B3910B A.01.21) on a
HPUX 10.2 machine
You could use mysqldump which makes
CREATE/INSERT statements for mysql, and
then you can change the mysql-spesific things
like auto_icrement into making an sequence, etc.
Oracle is SQL92 compliant and it would work i think.
try it :o)
mvh:
P?l Wester, programmerer
never.no as, stortingsgt 30
hi,
basically i am reframing my earlier question.
i'm using aCC ( ansic C++ compiler from HP ) on HPUX10.2
to compile and link my small C code with libraries available
from mysql-3.23.32-hp-hpux10.20-hppa1.1 .
i get the following:
/usr/ccs/bin/ld: Unsatisfied symbols:
your system...
johnny p.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 2:46 PM
To: Gus Constan
Cc: [EMAIL PROTECTED]
Subject: Re: Port 3306
What OS? If Linux or *BSD, they have firewall software
(ipchains on linux,
don't
I'm running Slackware Linux (2.0.36) and just set up a
binary version of MySQL 3.23.32. I followed the
directions exactly and all looks to be fine. However,
when I try and start MySQL by using typing
bin/safe_mysqld --user=mysql
I get the following error:
www:/usr/local/mysql# Starting
Yes, but does it get cleanly stopped when you shutdown? put the start
command in /etc/rc.d/rc.local, fine, but I think there needs to be a
kill link added to /etc/rc.d/rc.3 dir.
I like the link from apachectl to /etc/rc.d/init.d/ idea:
ln -s /usr/local/apache/bin/apachectl
201 - 287 of 287 matches
Mail list logo