You've also failed to provide enough information about your problem to
allow someone to figure out what it may be.
> Alice wrote:
>
> hi .. i am a new user to mysql,
> i did install myODBC, but fail to create the db connection in the ODBC
> ...
> why it fail ???
>
>
>
hi .. i am a new user to mysql,
i did install myODBC, but fail to create the db connection in the ODBC ...
why it fail ???
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments
hi .. i am a new user to mysql,
i did install myODBC, but fail to create the db
connection in the ODBC ...
why it fail ???
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attach
hello all
this is to inform u that i am running mysql 3.23.26 on linux 7.1 redhat but some
problem with the mysql demon
i am not able to stop the service through /etc/inet.d/mysqld
it is showing serviece failed
can any aone help me
Thanking You,
CBayScribe SysAdmin,
CBayScribe Support.
On Wed, 23 May 2001, Don Read wrote:
> >
> >
> >
> >
> >> while($row = mysql_fetch_object($result))
>
> Do you plan on executing a mysql_query() some time before this ?
Actually it is executed before this. This scripts works fine on my local
host running php 4.0.1pl2. Every time I r
is there any way to (config file or something) to preset what a database
directory's permissions are when it is created (i want the database's
directory to have permissions of 755 for a program that i'm writing, but
it appears to default to 700)...
i know i can write a script to perform this oper
Hi there,
Where do I find mysql.sock file? I couldn't find it
under mysql or mysql-gui directory.
Thanks
Wei
--- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote:
> Jausions, Philippe writes:
> > Hi,
> >
> > Just wondering how to get through that "Can't
> connect to local MySQL server
> > through so
using berkleydb3.2.9 with patch1 and patch2
when compiling MySQL 3.23.38
I add --with-berkeley-db
--with-berkeley-db-includes=/usr/local/BerkeleyDB.3.2/include
--with-berkeley-db-libs=/usr/local/BerkeleyDB.3.2/lib
so it configure and th
I have a very large table, where one of the columns is
color enum("red", "blue", "black")
The distribution of values is 90% black, 8% blue, and 2% red.
I want to be able to randomly select 10 rows matching a certain color from the table.
Of course,
select * from my_table where color = "bl
I got my query to work...
However, this query is going to be used a LOT, so I want to make sure it's
completely optimized. I have keys on all fields that I should...here's the
query I'm using:
select m.member_id, t.num_questions, r.score FROM members as m, trivia as t,
results as r WHERE t.trivi
I have 3 tables (applicable fields shown below):
members:
member_id, username
trivia:
trivia_id, num_questions
results:
trivia_id, member_id, score
I need a query that will return: the score and number of questions for a
given trivia, and the information I know is the member's username. Here's
How much if at all slower should a BETA-LOG build of MySQL be than one that doesn't
log ?
We have on BSD 3.23.26-beta-log which is MUCH slower than 3.23.32 on Linux.
- Sam.
-
Do You Yahoo!?
Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
Dear,
I apologize if this question stupid. I was see many question about MySQL
file system with the word INNODB, MyISAM and other. I wonder which the
best type to use in Linux because I did not know more about Unix file
system. So, I was install mysql by default and I want to know wh
Machine: PPC G3 (Rev. A iMac), 288 MB RAM
Problem occurred when running 'make install'. It configured fine
(Configure command: ./configure --prefix=/usr/local/mysql-3.23.38) and
compiled fine. However, 'make install' exited as follows:
.
.
.
/usr/bin/install: run-all-tests and /usr/local/mysql
This is no bug. This is usually a result of
1. The mysql server not starting.
2. Incorrect permissions.
3. socket file is in the wrong place and yes, you can define the location of
the socket file. RTFM for this.
- Original Message -
From: "Mark Lo" <[EMAIL PROTECTED]>
To: <[EMAIL PR
On Tuesday 22 May 2001 21:37, Stephan Skusa wrote:
> Another signal 11 dump ... cutting down sort_buffer to 4194296 Bytes
> seems not to be the solution for the signal 11 at 0 o'clock ... stated
> some weeks ago!
>
>
>
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tell
Hey,
After configuring MySQL 3.23.36 (first using Apachetoolbox but then just
compiling it from the downloaded source). I have run into this problem.
Any ideas? I'm running RedHat 7.0 on an X86 box.
Making all in libmysql
make[2]: Entering directory
`/export/home/mrichard/Apachetoolbox-1.
Hi everyone! I'm going to be working on a Honors Project and I'm wondering
if I've chosen the best set of tools. The software I am designing is
intended to be installed on isolated Win32 machines (hopefully will be
ported to Linux and/or WWW app someday). I have chosen to use Visual C++ and
My
I've been arguing with MS Access lately. Fortunately, I won. But only
because I had the source to MySQL available. Here's the situation:
(If you're looking for the feature request, skip to the end of the e-mail.
This message is a summary of a series of message posted on the MyODBC list.
I
hi.
i would suggest doing this in 2 queries, one to get the penalties, and one
to get the goals...as you can only really get the "top 10" for one of them.
if you want the top 10 leaders in penalty minutes, and the goals scored for
that player, you can join the goals table in there as well and SUM
>Description:
replication involving now() is sketchy if the two server clocks differ.
>How-To-Repeat:
Have a replicating server with a different clock (or timezone!) than the
primary server. Do an insert or update or anything involving now() and
it'll get weird, since the second server may or m
At 04:47 PM 05/23/2001, Angerer, Chad wrote:
>Well.. not sure if this is right but if you start up the mysqld server on
>startup the mysql.sock should be created in that directory always, so the
>symbolic link will always point to the same place.
>
>Otherwise.. I believe the directory will be in y
How does one know if their database server needs more memory? I have several
tables around 600,000+ rows that are being joined. I have 512MB of memory.
Is there a rule of thumb, or a good way to calculate how much memory my
database server needs.
Can I run my bigest query through some sort
Hello, I was just looking at my MySQL databse using mytop and saw that I was
getting over 60 queries per second. Can people give me an idea of how many
queries per second they get?
Thanks,
Nathan Hendler
Tucson, AZ USA
http://retards.org/
-
At 05:48 PM 05/22/2001, Angerer, Chad wrote:
>Dennis,
>
>do a find / -name mysql.sock 2>/dev/null to find exactly where mysql puts
>this file.. My rpm install put it in
>/var/lib/mysql/mysql.sock
>
>Find where your mysql.sock file is and make a symbolic on it pointing to
>/tmp/mysql.sock
>
>ln -s
Mysql Bug Report about Latin5 in 3.23.38max
I downloaded Mysql Win32 sources and saw that :
in share directory , in Index file there is #30 latin5 line.
but in directory this file does not exist.
all other files are correct and exist but
there is not latin5 file???
Yusuf Incekara
Regards
I keep getting this message in the mysql .err file I have no id as to
what to do or even look at.
010519 11:57:54 mysqld started
/usr/sbin/mysqld: ready for connections
010520 4:02:33 /usr/sbin/mysqld: Binlog closed, cannot RESET MASTER
Status information:
Current locks:
key_cache status:
You didn't show the code where the mysql_query() is done.
Further, you have "RAND as r" coded in your select statement,
not "RAND( ) as r". Is this live code?
Cheers,
Kent
(filter feeder: database)
-
Before posting, please ch
All,
In order to save very large strings (fully-formatted HTML) in a mysql
column, I have run it through java.util.zip's GZIP classes.
The result of this process is a byte[] of variable length.
I have as yet been unsuccessful at saving and retrieving this byte[].
(My column is currently a blo
I had the same problem too. If you go to CPAN and then go to DBD::Mysql,
click on the ftp site to
Jochen Wiedmann's directory and scroll past the one that says DBD-Mysql-yada
to the one that says Msql-Mysql-modules-1.2216.tar.gz and install that one
instead, it should work. Worked like a charm f
> *] I need to generate a RANDOM UNIQUE number for every new record. Is there an
> *] easy way to accomplish this inside of mySQL.
> *]
>
> The way I do this for session ids is through a perl function that I
> wrote a long time ago. Essentially I create a really long string of
> mixed case al
Hi there all,
A little bit of a silly question here, I am used to using PHP Myadmin.
What the problem is I have just been learning the command for creating etc..
using telnet, but I have a 2.5mb sql file that I need to run. The questions
are;
1: How do I run this file via telnet
2: If I hav
On Wed, May 23, 2001 at 02:22:02PM -0400, Dave Carter spake thusly:
*] I need to generate a RANDOM UNIQUE number for every new record. Is there an
*] easy way to accomplish this inside of mySQL.
*]
The way I do this for session ids is through a perl function that I
wrote a long time ago. Essen
I need to generate a RANDOM UNIQUE number for every new record. Is there an
easy way to accomplish this inside of mySQL.
TIA
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
(mail filter bologna: sql,database,query)
--
The errors are in the example below not in the code that i'm working
with. the group by would be school_name or school_id otherwise the
query would error and I wouldn't be experiencing the oddities that I am.
What it seems to be is that if I want to preform math on 2 sum
functions, (+-*/) it
Hello everyone,
I have mySQL 3.23 running on win2000 and encounter the odd
problem: longblob-type field is treated as blob-type since
I cannot put data more than 64kb in size into that field.
Any suggestions are highly appreciated.
Best of luck,
Yuriy Zubarev
_
Could someone point me to where I could find documentation for
incorporating MySQL with WebMail?
http://www.linuxdoc.org/LDP/solrhe/Securing-Optimizing-Linux-RH-Edition-
v1.3/webmlimp.html
walks you through installing WebMail, but it assumes you are using
PostgreSQL. Any help would be appreci
>I'm gaving a problem with adding several sums together when using a
>group by clause. The table I have looks like this:
>
>school_id int
>school_name varchar
>sport varchar
>cost_a float(9,2)
>cost_b float(9,2)
>cost_c float(9,2)
>
>The real table is normalized, fi
HI,
I got the following problem with apache_1.3.20 + modssl-2.8.4-1.3.20 +
openssl-0.9.6a + php-4.0.5 + mysql-3.23.38. After I upgrade the system, I
can only connect to mysql server via the consle window. But, I am not able
to use the php-mysql command to connect to the server via the web
At 18:10 23/5/2001 +0300, Heikki Tuuri wrote:
Hi,
>Claudio,
>
>in the source distribution the macro
>
>__NT__
>
>is defined. That makes it work only on NT and 2000.
>You should compile without __NT__ . See a posting by Miguel
>about 5 days ago.
If you don't have the VC++ compiler use mysqld-max.e
Hi,
I just installed mysql 3.23.37 on a FreeBSD 4.2 server.
The access to the db works fine from the command line with "-h=localhost"
option but when the localhost is replaced with the IP address it doesn't.
I've added an entry in the "user" table with the IP address & restarted
mysqld. The entr
When I execute this in mysql it works fine, but when I execute it on a web
page it gives a "Not Unique table/alias 'sporttable'
I would expect errors if 'playerpayment' was in my FROM clause but as you
can see it is not.
Note my example:
INSERT INTO playerpayment ( Family_ID, Player_ID, Player_
I am using mysql 3.22.32 on solaris.
when i start safe_mysqld , two process start :
safe_mysqld and mysqld.
But when i try to access to the database with
an http request, or with mysql (the command line)
nothing append ...
there is nothing in var/server.err
do you have an idee or where to se
Claudio,
in the source distribution the macro
__NT__
is defined. That makes it work only on NT and 2000.
You should compile without __NT__ . See a posting by Miguel
about 5 days ago.
Regards,
Heikki
>Downloaded latest version of MySQL for Win95 (3.23.38-win) on May 21st.
>After "mysqld" comm
I have 4 tables, named:
players - stores player id, name, team id
teams - teamid, teamname
goals - goals scored, player id, team id
penalty - penaltys accumulated, player id
What I'm trying to do is write a query to get the top 10 from any category
and display them. I can do them individually f
Jermey,
I would really appreciate that. Our sysadmin said it'll take another few
days before I can get the latest gnu compiler.
Thanks,
-eva-
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 3:47 PM
To: Eva Hammel
Cc: '[EMAIL PROTECTED]'
Su
Downloaded latest version of MySQL for Win95 (3.23.38-win) on May 21st.
After "mysqld" command this is the response:
C:\>cd mysql|cd bin|mysqld
Innobase: Assertion failure in thread 4293273545 in file M:\mysql-3.23\innobase\
os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Raymond,
Make sure the mysql server is running.
If it is running.. check permissions on the file. If there are ok.. find
where mysql puts your mysql.sock file and add a symbolic link from it to
/var/lib/mysql/mysql.sock
-C
-Original Message-
From: Raymund D. Nones [mailto:[EMAIL PROT
Hi,
You can use DBTools (http://dbtools.vila.bol.com.br). It's free, for Win32
and imports from MSAccess, Paradox, xBase and ODBC databases.
[]'s
Crercio O. Silva
-Original Message-
From: Mitchell [mailto:[EMAIL PROTECTED]]
Sent: terça-feira, 22 de maio de 2001 19:43
To: [EMAIL PROTECT
Hi, I'm trying to switch my database searching over to the Fulltext method,
but
I'm having some problems. The search function works with single words,
but when I search for multiple words I'm getting hundreds of results
with no relevence to what I'm looking for. The score on these results
is low
Perhaps MyODBC would help you out...
http://www.mysql.com/downloads/api-myodbc.html
Don't know for sure but it's probably worth a look :-)
HTH
Jon
-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: 23 May 2001 13:57
To: [EMAIL PROTECTED]
Subject: Cold Fusion Expres
I have developed a ftp searchengine, which uses a database for backend data
storage.
While mysql is indeed the fastest db for my needs, I wish to improve the
searchtime a bit further. A typical query would be
SELECT id, field FROM table WHERE field LIKE '%query%'
I understand that the use of
Hi. I am new to this list and I am having some problems. I have set up a
small personal server at my house to set up a site for family and such. I
am by trade a cold fusion developer. On the server at home I have a cold
fusion express application server running on a win2k box using iis as my web
I installed the RPM from the MySQL site. I finally have it installed and
the server appears to be running, but I have none of the access tools to get
to the databases.
I am setting this machine up in another country, so all is done via command
line through ssh, that means I can't use any X too
Ok, im working on a dynamic site with php and mysql. I allow people to
upload csv files that I process via cron job and php script to get the data
from the files into a table in my DB.
My first thought was to read through each file line by line and do an
insert for each line ch
If this was the binary install, I had the same problemso I compiled from
source.problem went away.
> Hi,
>
> Im trying to do the CPAN install of DBD::MySQL, Im running OpenBSD 2.7 ---
> I know this is prolly not the best list for this question, but its the only
> related list im currentl
alex writes:
> Hi ppl!
>
> I've a strange problem - I'm creating HEAP-type table and filling it
> with the result of select query from a relatively big table
> (containing ~2187000 records).
>
> The resulting error message is the following "Got error code 127 from
> table handler"
> And that's a
Hi ppl!
I've a strange problem - I'm creating HEAP-type table and filling it
with the result of select query from a relatively big table
(containing ~2187000 records).
The resulting error message is the following "Got error code 127 from
table handler"
And that's all :0)
I'm just wondering what
Stephan Skusa writes:
>
> What?? ... no I haven't ...
>
> It's slightly a problem doing exact logs ... cause this Database-Server
> crashes every 2-4 Days ... and does about 600,000 Queries an hour ...
>
> I generated a mysqld.sym ... if anybody needs this ... I'll send it ...
> I think this Ma
[EMAIL PROTECTED] writes:
> >Description:
> When updating a table after it has been selected with a LEFT JOIN, some
> UPDATE queries execute normally without actually updating the data, unless the
> data to be updated is selected normally first.
> This script is written in mod_perl, us
On 22-May-01 Adrian D'Costa wrote:
>
> Thanks. Now I am into another problem. I am not sure whether it is php
> or mysql. Though it works in the command prompt of mysql. Below is the
> snippet of my php script. What I am trying to do is to randomly display a
> scroll from the special table
Neither triggers, views or stored procedures are supported by MySQL.
However you can write your application in a way so that you don't need
either of them.
Alice wrote:
> Hi, i am a new user of mySQL, however i have experience in MSSQL server.
>
> i have difficulties on creating stored procedu
Could anyone pls help ?
I have installed mysql-3.23.38-1 into my linux server (SuSe) 6.4 Kernel 2.2.14
It keep dying and restart itself.
Here is the Error log file listing:
Number of processes running now: 2
mysqld process hanging, pid 16852 - killed
mysqld process hanging, pid 16851 - killed
0
Hi, i am a new user of mySQL, however i have
experience in MSSQL server.
i have difficulties on creating stored
procedure, triggers and views in mySQL.
/---\
Confidential and/ or privileged information may be contained
64 matches
Mail list logo
