Hello.
Just installed on FreeBSD. No database created yet, just a straight install
I was surprised at the amount of memory the daemon is taking
25.7MB - Is that correct ?
-
Before posting, please check:
Hi,
Is there any data type for storing passwords in tables so that they cannot
be viewable by anyone.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
char(16) or char(32) with PASSWORD() function or your own crypt ;-)
Hamid Mukhtar wrote:
Hi,
Is there any data type for storing passwords in tables so that they cannot
be viewable by anyone.
-
Before posting,
I am creating a database server with mysql.
I have an adaptec 2100s card which is not supported by debian 2.2 (my
first
choice in Linux OSs)
The card seems to say that it is only supported by Red hat and SuSe
Linuxes.
Any ideas on what would be the best OS to run a database server
Red
On 29-Jul-2001 martin wrote:
Hello.
Just installed on FreeBSD. No database created yet, just a straight install
I was surprised at the amount of memory the daemon is taking
25.7MB - Is that correct ?
Thats about right for an idle daemon.
Mine shows 26.6M, 13.7M in memory.
Hi!
On Wed, Jul 25, 2001 at 10:32:38PM -0600, Chris Bolt wrote:
I am currently trying to examine the benefits of continuing to
use MySQL over Oracle. I need to know what MySQL's features are
vs. those of Oracle.
It is totaly useless to compare Oracle vs. MySQL.
Oracle is something you
Hello Ardani,
an INSERT works only on one selected table...
You must insert the values separately for each table...
where is the problem?
Christian
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Thu, Jul 26, 2001 at 09:31:29PM +0100, Graham Nichols wrote:
Distinct can only be used with count
count(distinct field_name) --- OK for 3.23 NOT for 3.22
from MYSQL version 3.23. I have only version 3.22. How can I get
around this please?
Upgrade? :-)
--
Jeremy D. Zawodny,
hi,
i have two MySQL servers and i need to run a query that retreives data
from both servers (join two tables on different servers), how can i do
this.
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php
Already done my friend - works like a dream.
best, Graham
-Original Message-
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Graham Nichols [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: 29 July 2001 10:39
Subject: Re: DISTINCT problem
On Thu, Jul 26, 2001 at 09:31:29PM
On Fri, Jul 27, 2001 at 03:45:07PM -0600, Robert Leach wrote:
Is there a standard for that in SQL?
I don't think so. And if there is, MySQL doesn't do it.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408)
On Sun, Jul 29, 2001 at 12:41:46PM +0300, Moutasem Dana wrote:
i have two MySQL servers and i need to run a query that retreives
data from both servers (join two tables on different servers), how
can i do this.
You cannot do that in a single query.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Moutasem Dana wrote:
hi,
i have two MySQL servers and i need to run a query that retreives data
from both servers (join two tables on different servers), how can i do
this.
Thanks.
-
Before posting, please check:
Håkan Elmqvist writes:
My MySQLGUI running on a Windows system is invariably much slower(typically
30 seconds) than a MSAccess database with tables linked with MyODBC to the
same Linux-hosted Mysql-database (typically less than 1 second) when
executing the same query over a telephone
Roger Larsson writes:
I'm posting to this general list because there doesn't seem to be any
list to report a spontaneous crash to.
Have tested MySQL 3.23.39-nt for some days by implementing a small
project. It has been running fine up to now when I after having dropped
a column from a
I had similar experience with MySQL GUI although my connection is over
1.5Mbs ADSL. If I use MySQL WinAdmin the response is instantaneous. I know
that applications with ported Unix interfaces can be slightly sluggish, but
not 20-30 seconds - so it has to be something else. My client is W2K and
Nik Belajcic writes:
I had similar experience with MySQL GUI although my connection is over
1.5Mbs ADSL. If I use MySQL WinAdmin the response is instantaneous. I know
that applications with ported Unix interfaces can be slightly sluggish, but
not 20-30 seconds - so it has to be something
I'm back now, and have tested the 3.23.40. It works like a charm :-) Nice
work!
Now I only wait for the Win32 binary to be released. I didn't think there
were any delays between the releasins anymore?
- Carsten
- Original Message -
From: Sergei Golubchik [EMAIL PROTECTED]
To: Carsten
Hi all,
i have a problem with the mysql driver. I have developed some java classes to read and
write from the database. These classes uses very simple sql statements like insert or
update. But sometimes (50%) when i perform a update a got the following exception.
java.sql.SQLException:
Carsten Gehling writes:
I'm back now, and have tested the 3.23.40. It works like a charm :-) Nice
work!
Now I only wait for the Win32 binary to be released. I didn't think there
were any delays between the releasins anymore?
- Carsten
Thanks for the compliments.
Win32 binaries will
hi all
i am running mysql 3.23.40 and tomcat 3.2.3 on FreeBSD
when i try to connect to the local mysql server in jsp using mm driver
it says:
Server configuration denies access to data source
the userpass i provide is right
i can connect to local mysqld use ./mysql -u root -p
also php+mysql
This maybe more of a PHP question. I have a problem with file names
that have white space or special characters stored in the database. When
I try to link to them from a webpage I get file not found error which is
probably because of whitespace in filename
Example I have a file name stored in
Hi !
Can you please send us the reproducible sample code ? So that we can figure
out the things.
Thanks in advance
Venu
-Original Message-
From: Uwe Heldt [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 29, 2001 6:28 AM
To: [EMAIL PROTECTED]
Subject: driver problem
Hi all,
i
Does anyone have any information on running MySQL on a windows CE handheld?
Thanks
Joel
Hi Venu,
it ' s hard to send you sample code. The database access is coded over more
then one class which dynamicly build sql statements. The only thing i know
is, that first a simple select is performed. After that one update on the
same table row and then a select again. Could id be that there
Hi,
Many many thanks to all who had replied.
I tried using mysqlc.exe but windows complained that a
.dll file was required, CYGWINB19.dll file not found.
Thanks in advance.
JH
--- Sinisa Milivojevic [EMAIL PROTECTED] wrote: Oh
junhui writes:
Hi,
I am currently using mySQL 3.23.39,
Hi Kit,
I am not sure whether you deliberately choose to send the email not to the
list, but it might have been a wise thing considering the long list of
emails. ;-) (which I deleted right away for your privacy).
Unfortunately I am no PHP expert but rather familiar with Perl but I don't
think
Example I have a file name stored in database as: john's - song.mp3
When I click on the link to the song in a web browser I get file not
found.
http://www.php.net/rawurlencode
-
Before posting, please check:
From other mailings on the list and my own experience, it seems
[EMAIL PROTECTED] is (has been?) sending these out to any poster
to the list.
If things aren't fixed yet, I'll probably have another one in a couple of
minutes...
Anyhow, no SJS, it seems to me this 'no spam' crap has nothing
to do
Hi,
I have mysql-3.23.40-sun-solaris2.7 on Sun and I have quite a few
problems I try to find somebody that I can pay to help me get this
running the way it should. If anyone is good with the produce and is
interested to earn some extra money please contact me. I need someone
fast.
Thomas
Does anyone have any information on running MySQL on a windows CE handheld?
Try it and let us know as soon as you've got it up and running..
Good luck.
/me wouldn't even try.. but me wouldn't even try to run MySQL on any M$
product..
mysql, query
Bye,
B.
If you're looking for support you can contact MYSQL AB (the creators of
MYSQL) checkout www.mysql.com to see which supportcontracts they offer.
But you could also try your luck on this list.
Bye,
B.
At 15:00 29-7-01 -0400, Thomas Bernthaler wrote:
Hi,
I have mysql-3.23.40-sun-solaris2.7
I have my /var/ partition set to 400mb, but I need about 4 gigs for a mysql
database im setting up
how can I relocate the data files in the users /home directory, or how can I
fix this?
-
Before posting, please check:
I got several of them in my mailbox as well, even when I asked him to stop,
so I K-lined his domain from my mail server...silly butt head..
Cheers
M;)
-Original Message-
From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 29, 2001 11:26 AM
To: [EMAIL PROTECTED]
On 29-Jul-2001 Brian Thompson wrote:
I have my /var/ partition set to 400mb, but I need about 4 gigs for a mysql
database im setting up
how can I relocate the data files in the users /home directory, or how can I
fix this?
Assume the datadir is /var/db/mysql
make a backup
shutdown
Uh, don't symlink. That'll just cause massive amounts of issues later on if
you have to deal with performance (added syscalls to check to valid
symlinks).
If you read the docs on mysql.com, they tell you the command line options
you can set to change the directory. You can put these into
After being tested for a week, he new version is finally available for
downloading. This new version has some bugs fixed and a totally new Server
Manager. Here is the list of the changes:
- New Server Manager integrated, you can add, delete or change the
parameters at any time you want. You can
I sent this before, but it never made it..
Does anyone here have any advice on controlling the size of user
databases?
I've heard talk of symlinks before, anyone had any luck with that?
Thanks,
Chris
-
Before posting, please
On Sun, Jul 29, 2001 at 02:21:43PM -0700, Vincent Janelle wrote:
Uh, don't symlink. That'll just cause massive amounts of issues
later on if you have to deal with performance (added syscalls to
check to valid symlinks).
Doesn't that apply to the time that a table is opened? If tables are
Depends on the handler. You'll get the file pointer returned.. I guess I
wasn't thinking this completely through. Ah oh well =) I keep thinking in
terms of files getting opened and closed a lot.
But configuring mysql to point to a diff directory is just better
administration.
- Original
On Mon, Jul 16, 2001 at 05:50:53PM -0700, Jim Matzdorff wrote:
difficult to do (add the necessary code to MySQL), provided that
the logging code is as straightforward as the binary logging code.
i figured something like that, though i don't know the internals.
it seems it knows what's
On Sun, Jul 29, 2001 at 03:10:14PM -0700, Vincent Janelle wrote:
But configuring mysql to point to a diff directory is just better
administration.
Unfortunately, it only gets you so far. What if you want to spread
your data across several physical disks (without hardware/software
RAID)? Or
Apologies as this question has probably been asked before.
I am new to mysql. I run it on Windows NT4. I am using version 3.23.39a.
The function NOW() doesn't appear to work. Is there a fix?
I've checked my computer and time zone, etc. Everything seems to be in
order.
Thanks in advance,
David
Hello,
I am not sure if this is the right mailing list but since it's a
mysql related problem,
I thought I'd give it a shot..
I am installing apache on my linux box with php4 capabilities. When I
configured php4
I added the mysql option...in short..something like this...
gunzip
On Sun, Jul 29, 2001 at 06:15:20PM -0400, dpowellLLC wrote:
Apologies as this question has probably been asked before.
If you check the mail archives before posting, there's no reason to
aplogize.
I am new to mysql. I run it on Windows NT4. I am using version
3.23.39a. The function NOW()
On 29-Jul-2001 Tom Cruickshank wrote:
Hello,
I am not sure if this is the right mailing list but since it's a
mysql related problem,
I thought I'd give it a shot..
I am installing apache on my linux box with php4 capabilities. When I
configured php4
I added the mysql
As an example...
mysql select now();
+-+
|now()|
+-+
| 2001-07-30 06:33:10 |
+-+
1 row in set (0.00 sec)
mysql_
That time is about twelve hours from now here on the East Coast of the USA.
-Original Message-
Sometimes it just helps to ask someone.
I forgot I'm not running this database on THIS machine. I'm running it on
the one beside it. That machine had a clock set 12 hours ahead. Thanks for
your help.
David
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]]
Sent: Sunday,
On Mon, Jul 16, 2001 at 05:50:53PM -0700, Jim Matzdorff wrote:
difficult to do (add the necessary code to MySQL),
provided that the
logging code is as straightforward as the binary logging code.
i figured something like that, though i don't know the
internals. it
seems it
Hi Everyone,
I have a small problem here(I think :-) ), but I still can't figure our how
to fix it.
I am not so familiar with Linux 6.0's Boot Shell.
Here is the problem:
After I successfully installed MySql 3.23 into my Linux system,
I added the following lines into /etc/rc.d/rc.local to
Hello-
You need to place mysqld in the background by adding a after the
command. Something like this:
/usr/local/mysql/bin/safe_mysqld
As to the problem after it starts mysqld in the foreground, have you tried
CTRL-C? Otherwise try going to a different console with ALT-F2, ALT-F3,
etc.
Hello Tom Cruickshank:
re: mysql -related install of apache and php4
-
I'm running *BSD, not Linux, but very recently installed Apache with PHP,
from source. I usually make a shell script, and check it through for all the
steps, then run the script. I had saved the script, so maybe this will
Hi Sir,
I have a question in MySQL Replication?
I have 3 different databases running on 3 servers. Then I want replicate them to
one single server. How can I do? Need I run 3 mysql on the slave server?
Winnie
-
Dear,
I'd like to use some temp table (not establish from create new table and
could delete itself when finished job) when I grab data from any real
table. Please describe with MySQL console, PHP or programming language
with API.
Sommai Fongnamthip
On Sat, Jul 21, 2001 at 06:51:37AM -0700, Donald wrote:
Im running FBSD ver 2.2.8 and need to know what version of mysql
installs ans runs best on this platform. At this time upgrading in
not an option.
I never saw a reply, so...
I've run a few versions of MySQL 3.22.xx (where xx is
On Wed, Jul 25, 2001 at 03:19:03PM +0200, Sebastiaan Smit wrote:
Hello,
I'm having a problem with MySQL when it runs for a couple of
days. At some time mysqld 'forgets' where it's databases are and
searches for them in the mysql temp dir. (In my case /var/tmp). In
the tmp dir there is
On Fri, Jul 27, 2001 at 03:13:58PM -0400, [EMAIL PROTECTED] wrote:
Is it possible to have a single mysql server with multiple data
directories? I would like to be able to specify where a database is
physically located. I know that I can do this for all databases by
setting the 'datadir'
On Mon, Jul 30, 2001 at 01:36:29AM +0200, Sander Pilon wrote:
I'd like it as well. Perhaps turn logging on/off on a
database-basis.
Say, I want to debug/view the queries on database X but don't want
the stuff that's happening on database Y.
The impression I got is that this may appear
hi all,
i apologize for the utterly newbie-ish question, but i've yet to find an
answer to it after having spent quite some time searching mysql's web site
(especially since half the links i click on now seem to be giving me 404
errors...)
how does one reindex a table containing fulltext
You should use the 'startup script' supplied with the 'source' distribution
(named server.sh in the subdirectory support-files).
To 'boot' without starting any applications or daemons, type boot -s at
the 'boot prompt' (Lilo's boot prompt if you have installed lilo). This
will boot the system
60 matches
Mail list logo
