Most search engines use databases. Some search directories or web
addresses directly. Some use spiders to collect data. Search engines
are as varied as the kinds of jobs they do. First, decide what needs
to be searched and what searched for. Then research it. Don't just
plug a stock program into
Hi!
I have so many data more than my SCSI HDD.
But I can add large IDE HDD.
I have an idea put index files on one HDD and data files to another.
What do you think about this idea?
What is more effictive, leave data to SCSI HDD or leave indexes on SCSI?
___
I have installed MySQL on Linux Redhat 7.0. When I try and run a MySQL
command, I get the following error: "Warning: MySQL Connection
Failed: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)"
What can I do to rectify this?
Rudi von Fintel
N Dip Electrical
Hi guys
Havent worked much with mysql or any databses for that matter, I have
created a small database on my unix box and I want to make a query to the
database from another unix box without telneting in or ssh, I beleive that
it runs on port 3306.??? help
regards,
Mark Coetser
Hi
You need to start the server first, using the safe_mysqld daemon
-Original Message-
From: Rudi von Fintel [mailto:[EMAIL PROTECTED]]
Sent: 26 January 2001 13:30
To: [EMAIL PROTECTED]
Subject: Installation problems
I have installed MySQL on Linux Redhat 7.0. When I try and run a
Hi,
is there any way to disable all the MySQL-Warnings that are sent to my
visitors browsers when the database is down for a moment. I am using the
database to count the pageviews, and if the connection to the DB is
impossible, there should not be sent any warning to the visitors browser! Is
At 11:36 AM +0200 1/26/01, Mark Coetser wrote:
Hi guys
Havent worked much with mysql or any databses for that matter, I have
created a small database on my unix box and I want to make a query to the
database from another unix box without telneting in or ssh, I beleive that
it runs on port
* Martin Ramskogler [EMAIL PROTECTED] wrote on 26.01.01 12:36:
is there any way to disable all the MySQL-Warnings that are sent to my
visitors browsers when the database is down for a moment. I am using the
database to count the pageviews, and if the connection to the DB is
impossible, there
I have a column that is defined as a SET. For simplicity's sake,
let's say the column is defined as:
set_col SET ('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'Z')
After entering a few hundred rows, I know that some but not all
values of the SET have been used at least once. How can
I found a very strange behaviour of MySQL 3.23.xx with GROUP BY clause ...
I have a Table:
CREATE TABLE groupbyTEST (
fldNAME varchar(20) NOT NULL,
fldMONTH tinyint(4) DEFAULT '0' NOT NULL,
fldSALARY decimal(10,0) DEFAULT '0' NOT NULL,
fldDATE datetime DEFAULT '-00-00
I have tried as MySQL documentation help to create one duplicate table using existing
table structure.
But, It's raise error.
i.e.,
create table newtable select * from oldtable;
mysql
mysql create table works SELECT * FROM t_Works;
ERROR 1064: You have an error in your SQL syntax near
On Fri, Jan 26, 2001 at 01:28:14PM +0100, Legeard Luc wrote:
Hello
I 'd like migrate my mysql server wich run on a Sunsolaris to a Linux
computer.
I have installed mysql on my linux and it works
Now , i'like to move database from Unix to Linux
A copy database ( *.ISD, *.ISM,*.frm) to
AFAIK, ISD, ISM is isam type table which are platform
dependent. So, you cannot just COPY them. You need
to do something trikier (sqldump and then restore using
mysql)
MYD, MYI - are myisam tables and they are declarede
platform independet. You can move then around w/o
trouble (AFAIK again).
Hello,
For the company I work for I have set up a MySQL database for a
books website with more that 1 million records of books.
The visitor can search for keywords. A sequential scan would be
much too slow. (When I made the database, I had not yet heard of
the new FULLTEXT index in MySQL.)
Hi,
While trying to install the latest mysql Binary distribution
(mysql-3_23_32-pc-linux-gnu-i686_tar)to our Red Hat Linux 6.0 machine I
have encountered the following problem. I would appreciate, if some can
shade a light on it.
When I tried to Create the MySQL grant tables
shell
Hello!
Need some help.
I have two tables
t1 with fields id and site
t2 with fields id, from, to, koef
I want to update t2 set koef=2 if the from field in t2 table exist in
t1.url
such update return error.
update t2, t1 set t2.koef=0 where t2.from=t1.site
Thank yoo very much.
On Fri, Jan 26, 2001 at 02:28:37PM +0200, Evan James Dembskey wrote:
It appears as if I have installed MySQL successfuly (under CLOS 1.2).
CLOS ??
However, everytime I try to
#include mysql.h OR #include "mysql.h" OR #include
/usr/local/mysql/include/mysql.h ETC
I get a "No
Hello,
For the company I work for I have set up a MySQL database for a
books website with more that 1 million records of books.
The visitor can search for keywords. A sequential scan would be
much too slow. (When I made the database, I had not yet heard of
the new FULLTEXT index in MySQL.)
We are using all the recommended versions of software to get MySQLGUI
compiled and running. When we try to login we get a bus error. After
putting the software in the debugger, we found that the string
conversion routine is causing the address of the string to be an "odd
address". Has anyone
Mehalick, Richard RE SSI-GRAX writes:
I asked a week ago if BDB tables had ever been tested by the MySQL team on
RedHat 7. Any ideas?
-
/ Rick Mehalick Senior Consultant
/ Shell Services International SSI-GPAX
/ Phone:
Do you know any free web hosting that supports MySQL. Please let me know.
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are
GNUe Forms is a data entry/query tool that allows a designer to describe a
data aware user interface via an XML based form definition language.
This file is then parsed at client startup and a proper user interface is
dynamically generated. Currently the client portion of the system is
Hello!
I promised to report to the mailing list how the interfacing of MySQL
and Innobase engine progresses. Innobase will provide transactions,
rollback, row level locking, and Oracle-style non-locking consistent read
to MySQL. It currently runs on Intel Linux and NT.
Following items from the
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name
Jennifer Devilbiss writes:
We are using all the recommended versions of software to get MySQLGUI
compiled and running. When we try to login we get a bus error. After
putting the software in the debugger, we found that the string
conversion routine is causing the address of the string to
petro writes:
Hello!
Need some help.
I have two tables
t1 with fields id and site
t2 with fields id, from, to, koef
I want to update t2 set koef=2 if the from field in t2 table exist in
t1.url
such update return error.
update t2, t1 set t2.koef=0 where t2.from=t1.site
Sam Wong writes:
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon
400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID
The traffic of it is about 300 queries/second on average, and keep staying
at around 400 q/s at night.
The problem is that, it core dumps in 5-10 mins,
Hi,
I would like to know if Mysql can be used with Actuate Report writer. If yes
what drivers will I need.
Thank you,
Anju Bagaria
Total E Care Corp.
130 Campus Drive, Edison NJ 08837
Email:[EMAIL PROTECTED]
Phone:732-225- x199
Fax: 732-417-0482
One approach might be to use a hierarchal menu -- first level
is first letter of the company, second level is all of the
companies whose names begin with that letter.
Or, set a search to pull up the list of companies which contain
a certain phrase.
-Tilghman
--
"There cannot be a crisis
Thanks for the response.
On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote:
It just occurred to me, however, that this becomes a much bigger
problem when the web server(s) and the database server are running
on different machines.
Only if they're on different networks. Ideally, you could
Julian Hiscock writes:
We are currently trying to compile MySQL V3.23.32 under Tru64 V5.0a running
on a Compaq Alphaserver DS20E. The error messages are as follows:
Object file format error in: /usr/local/mysql/lib/mysql:
read_pass1_info_malloc: bad file magic number
ld:
Object
Hi.
You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.
I need to quicken DB to the maximum and to keep minimum size of the DB.
Thanks.
Nick.
-
Before posting, please check:
http://www.mysql.com/manual.php
The manual says that if two seprate single-column
indexes exist on two different colums (col1, col2)
and someone issues a query:
SELECT * FROM tbl_name WHERE col1=val1 AND col2=val2
optimizer will choose the index which matches the least
records and use it.
This is it. Manual does not say what
Beside Jeremy's notable comment, please try latest FreeBSD binary
available on our site.
Also follow Ken Manzel's info on FreeBSD 4.* patches.
The fact that you have SMP kernel should not matter much, as FreeBSD
native threads can not use SMP for threaded servers.
If you still get
In the last episode (Jan 26), Artem Koutchine said:
The manual says that if two seprate single-column indexes exist on
two different colums (col1, col2) and someone issues a query:
SELECT * FROM tbl_name WHERE col1=val1 AND col2=val2
optimizer will choose the index which matches the least
Hi,
I am trying to install MySQL on my Sun workstation
which has Solaris 2.6 installed. I have completed
following steps
1. configure
2. make
After step 2 when I am doing "make install" (step3)
it is giving me following error:
---
Warning:
Right, I trying to compile MySQL latest stable on FreeBSD 4.2 but I
get stuck sql_yacc.cc ..
Any pointers?
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k.ab.ca
414-5359
Hello list,
How would you go about selecting * from 2 tables?
I have 2 tables: table_1 and table_2
In table_1 I have the following data.
dog
bird
cat
In table_2 I have:
mouse
rat
hampster
How do I show both tables contents like:
+--+
|dog |
|bird |
|cat |
|mouse |
You can't do
select * from table_1 UNION select * from table_2;
1st the structures of both queries have to be exactly the same. Second, you
have to specify them in the select.
select animalType from table_1 UNION select animalType from table_2;
should work, assuming that you have a field
What do you mean "get stuck". You some kind of error or just
it does shows that it compiles it and makes you wait a lot.
Well, if you look a bit above you will see that the following
compile may take a long time and IT DOES TAKE A VERY
LONG TIME ON SLOW MACHINES.
So.. WAIT!
If you got error, then
assuming that each table only has one element, you could do a select * from
2 table.
If you don't and you need to combine everything, then you're trying to do a
UNION.
mySQL doesn't support UNION's yet.
one way to do a union is to create a temporary table then use two queries to
fill the
Why not do an update regardless if the record exist or not,
then insert it if you get an error?
-Opprinnelig melding-
Fra: Artem Koutchine [mailto:[EMAIL PROTECTED]]
Sendt: 26. januar 2001 19:02
Til: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Emne: Re: If exists UPDATE else INSERT
I've seen
Do it the other way around.
If insert fails, do the update.
Udate may fail, and before you insert, another tread could do the
insert.
Now your insert would fail, and your data would be lost.
Pl Wester wrote:
Why not do an update regardless if the record exist or not,
then insert it if you
Hi--
I'm running an art archive, and for the artist listing pages I have to
come up with a query something like the following:
select name,dirname,sortname,pictures.artistid,count(pictures.artistid)
as imgnum,avg(rating) as rateavg,max(uploaded) as lastmod
from
Can somebody provide me with some sample code for the following. I read it
over in the manual but am still lost.
thanks
Randy
+++
Sounds like you want a mutex and you can use get_lock and release_lock in
mysql for that.
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
As far as PHP is concerned, 4.0.4pl1 is not enough. You need to install CVS
version later than 2001-01-18. At least this is my experience.
Maciek
-Original Message-
From: tc lewis [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 8:47 PM
To: Maciek Uhlig
Cc: [EMAIL
Hello Anna,
According to the MySQL Crash-Me the maximum numbers for 3.23.xx are:
- Columns in table 3398
- max table row length (without blobs) 65534
- table row length with nulls (without blobs) 65502
If you understand the concepts of DB normalization don't bother reading the
following:
Hello,
I would like to change the default date format MySql from /mm/dd to
dd/mm/. Does anyone know, how to make this change in MySql?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
Hello,
I would like to change the default date format MySql from /mm/dd to
dd/mm/. Does anyone know, how to make this change in MySql?
You can't.
However, you can select DATE, DATETIME, or TIMESTAMP values using
Update, which may be helpful:
The number I'm getting back (which I said is vastly too high) is in
fact the number of pictures multiplied by the number of ratings entries
for that artist.
I wanted to be able to get those two groupings separately. Is there a
way I can do
Thank paul. I know about Date_format, but was curious if there is some
setup parameters would allow us to define the MySql date format .
Paul DuBois wrote:
On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
Hello,
I would like to change the default date format MySql from
I was just wondering what the "USAGE" privilege is good for and where it
would be used?
Pauls's book says that USAGE is a special "no privileges" privilege.
___
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
Add -lz to your linking options and all should go well.
"Dave Juntgen" [EMAIL PROTECTED] wrote:
Hello everyone..
I am trying to compile a CGI program written in C statically and I keep
getting this one error. I am using MySQL version 3.23.31, the compiler
error below shows that it is
Hi,
Check that you have zlib installed and then just add -lz to the libraries
you will be linking with.
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB,
Hi.
You posted to the wrong list. This list is for developing of MySQL itself.
As for your problem, MySQL does not have a good solution at this point. Have
you tried using the BACKUP command? It will flush and lock the table and
copy only the data and .frm files. A RESTORE will rebuild the
Hi,
There was a bug in 3.23.31 (I think) with fultext indexes. Was this fixed in
3.23.32?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php
You can create a "MERGE TABLE" (read all about it in the manual)...
CREATE MERGE TABLE everything ( animalname varchar(25)) TYPE=MERGE
UNION=(table_1,table_2);
Thereafter, you can select * from everything;
Cheers,
Kent Hoover
I am a customer to a web designer that I have since cut relations with.He
left me high and dry and I am left to my own devices to ftp my web site to
another hosting co. Is there a driver exclusively for ftp work that you can
sell me; with step by step instructions of how to use it. or is
http://www.mysql.com/doc/M/a/Mathematical_functions.html
Please please please read manual before asking questions.
SELECT SUM(minutes) AS ttltime, user FROM table WHERE user = 'someuser'
GROUP BY user
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
Greetings all,
I have installed PHP 4.0.2 and MySQL 3.22.32 and Apache 1.3.12 on a Sun
Sparc 20 running Solaris 2.6. I can now
connect just fine using the mysql client and can run queries, etc.
However, when I try to do the normal connection
transaction using PHP Scripts, I get an error that
I recently upgraded to RedHat 7, and now I can't get Mysql to start. I keep
getting error 2002: can't connect. I have looked at every piece of
documentation, and can't find the solution. The mysql.sock file exists, but
it still can't connect.
I have used the rpm of version 3.23.32 to install
Redhat is funny. I have 7 and had tried everything in the books to
get mysql back up and running after a shutdown. Fortunately, I had an
experienced programmer who had helped me set it up. I queried him and
set back this command:
/etc/rc.d/init.d/mysqld restart
That did the
I've heard that redhat 7 is not that good. They implant many beta version
code inside.
Sam
- Original Message -
From: "Mike Tuller" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 27, 2001 9:10 AM
Subject: Error 2002: can't connect to mysql.sock
I recently upgraded to
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
For example, I have a table
value position
3001
1002
5003
2004
I have to update position ordered by value, and table must look like this
value position
3003
1001
5004
2002
Is it possible
You are right that RedHat is funny. 7 really seems weird. I tried for two
days to get everything going, (still am) and ran into all kinds of errors
with Mysql. I tried different versions, and had different problems on each.
I finally ran up2date to get everything update, and thought that would do
I'm trying to use libmysqlclient as
described in the manual to compile
another program in SCO Open Server
Release 5.0.5, whe i tri to do
gcc -O2 -g -o mysql1
mysql.c -L/usr/local/mysql/lib -lmysqlcl
ient -lnsl i get this messages can
someone help me.
Undefined
On Sat, 27 Jan 2001, Marcelo wrote:
I'm trying to use libmysqlclient as
described in the manual to compile
another program in SCO Open Server
Release 5.0.5, whe i tri to do
gcc -O2 -g -o mysql1
mysql.c -L/usr/local/mysql/lib -lmysqlcl
ient -lnsl i get this messages can
someone help
I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that
a column that is displayed
and has no grouping function applied to it MUST also appear in the GROUP
BY-clause!!!
The result:
fldNAME fldMONAT sum(fldSALARY)
boris 1 10200
stephan 1 6000
On Fri, Jan 26, 2001 at 10:39:46AM -0600, Patrick Goetz wrote:
Thanks for the response.
On Thu, 25 Jan 2001, Jeremy D. Zawodny wrote:
It just occurred to me, however, that this becomes a much bigger
problem when the web server(s) and the database server are running
on different
Firstly, text is a reserved word in mysql. Secondly, varchars or chars
can only have 255 characters. You should use a text type column which
can be very large (megabytes!). You have read the manual on the
different field types?
Clearly, he *did* read up on the field types in the manual and
I am trying to determine when it is best to use
varchar and when it is appropriate to use tinytext. I
have looked at the manual and have read the difference
between them but would like to have an understanding
of this in more practical, real-life terms.
Is a space between characters
72 matches
Mail list logo