Date |Tue, 28 Aug 2001 03:16:59 -0230 (NDT)
From |Neil Zanella [EMAIL PROTECTED]
Hello!
NZ RedHat 7.1 users:
NZ The command used to start mysqld on this platform is simply (as root):
NZ # /etc/init.d/mysqld start
NZ This is _all_ that is required.
NZ Once that works you can set
NZ the
Date |Mon, 27 Aug 2001 18:32:57 -0500
From |Tyler Longrne [EMAIL PROTECTED]
Hello!
TL Hello everyone,
TL Is there any way to make selections in groups of 5. I want to get 5 record
TL sets at a time until we get to a point that there's 4 or less records.
TL Thank you everyone,
TL Tyler
TL
hello.
with a lot of help from many of you and some very nice folks, i have
been able to build some example/experiment/'mess around' type of dbs.
yay.
i'd like to ask...
if any of you are familar with (File Maker Pro, most recent
versions)... how does one go about using MySQL to create a
Date |Mon, 27 Aug 2001 18:16:43 -0400
From |alexus [EMAIL PROTECTED]
Hello!
A hi
A i'm trying to setup mysql w/ InnoDB
A i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html
A and i'm end up with this in my log every time i run mysql and in addition it
A ends
A here is
Date |Mon, 27 Aug 2001 14:14:22 -0700
From |PR [EMAIL PROTECTED]
Hello!
P I was wondering if anyone could point me to a message board (perl or php)
P that has a very efficient database design to handle threaded views. I know
P that this is a difficult task under mysql and have seen the threads
Date |Mon, 27 Aug 2001 15:31:26 -0700
From |John Meyer [EMAIL PROTECTED]
Hello!
JM At 09:15 AM 8/28/01 +1200, you wrote:
Hi there,
I treat image data type as text, does anyone know how to insert an image
into the table?
JM the image data type is actually a BLOB, not text. Usually, it's more
hi,
i have 2 questions that i badly need answered. i use phpmyadmin, but
any answers containing SQL syntax should work in this app...
1)
this should be simple but i don't know it. i use the following mysql
table field as the Key for my tables:
id int(10) unsigned NOT NULL auto_increment,
Date |Mon, 27 Aug 2001 12:54:25 -0700 (PDT)
From |S K Bryan [EMAIL PROTECTED]
Hello!
SKB Hello -
SKB I'm very new at this, so please pardon the very beginner questions...
SKB I'm attemtping to install MySQL to my local machine running Win98. The
SKB install seems to go alright, but when I try
Hi All, can someone point me in the right direction for saving
formatted RichEdit Text to a blob field and then loading the RichEdit field
with the data from the blob. I am using Borland Builder 5 odbc to MySQL
database.
Regards
Doug
[EMAIL PROTECTED]
Hello Everybody :-)
Well, I just suscribed to the mailing lists and would like to know a few more
things about mysql. I have heard a lot about it and i think i will enjoy learning it a
lot. I would be glad if anyone could care answering to my query.
what is mysql most usefull for ,i mean
Hi Nilesh
MySQL is very fast but has not got all the things SQL can have (this is for
speed).
So we use it for web sites and for authenticating users over radius.
Simon
-Original Message-
From: Nilesh Keshavji Parmar [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 09:05
To: [EMAIL
Date |Sat, 25 Aug 2001 00:24:07 +0200
From |Boaz Yahav [EMAIL PROTECTED]
Hello!
BY Hi
BY I have a table with a filed that is unique (used unique() in the
BY creation).
BY how do I undo this unique()?
unique is an index property.
Just remove them by ALTER TABLE command
Date |Fri, 24 Aug 2001 14:08:43 -0400 (EDT)
From |boulat [EMAIL PROTECTED]
Hello!
B Hi group,
B Im using the latest mySQL 3.23.41, ever since I installed the new
B version I've been getting Lost connection to MySQL server during query
B 50% of the time on my mySQL server. I have a load
Date |Fri, 24 Aug 2001 14:09:20 -0500
From |Tyler Longren [EMAIL PROTECTED]
Hello!
TL DROP TABLE Track
TL Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
TL Anyone know what that means? As you can see, it came from tryign to do a
TL DROP on a table.
TL Thanks,
TL Tyler
Date |Fri, 24 Aug 2001 10:29:53 -0700
From |Benjamin Arai [EMAIL PROTECTED]
Hello!
BA What is the maximum table size allowed by MySQL and Redhat 7.0 be default?
BA Benjamin Arai
Read about it here:
http://www.mysql.com/doc/T/a/Table_size.html
Neil Zanella writes:
1. What was the name of the first GPL file release of MySQL?
3.23.xx
2. Which portions are not distributed by mysql.com as part of MySQL?
All are.
3. Which portions of the Windows MySQL release
are not released under the GPL if any? For instance is the
Hi,
We have Oracle SQL statements that uses UNION is there an equivalent for this in mySQL?
// Jocke
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi all,
I work with mysql 3.23.40 on Mac Os X 10.0.x and have created a Database.
This Database has to move to another mysql server 3.23.40 on a Mac OS X
Server. In older versions (up to 3.23.39 I think) it was sufficient to
create an empty database on the destination machine and just copy and
Hello!
These query produces an SQL syntax error
in 3.23.29a-gamma:
GRANT ALL PRIVILEGES ON databases.*
TO 'foo'@'localhost' IDENTIFIED BY 'bar';
SHOW TABLES FROM databases;
Probably this is because of databases is
a keyword. However, mysqladmin does allow to
create database
Sorry, It was a little mistake in my previous letter.
mysqladmin create databases does not output any
error messages, however it does not create database
databases.
However, mysqladmin drop databases produce this:
/usr/local/mysql/etc/ access.grant mysqladmin drop databases
Dropping the
Jrkeborn Joacim wrote:
Hi,
We have Oracle SQL statements that uses UNION is there an equivalent for this in
mySQL?
Not yet. It should be in version 4.0
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA
When you have just inserted a record into a table that autoincrements the
primary key,
is there a way of retrieving the id assigned at the same time? I'm using ASP
to write the
code in question , and I'm trying to find a better solution that looking at
the max key value
just before/after in
HEllo!
Is it possible to create a merge table for
tables from different databases.
I wrote this script for database collection:
CREATE TABLE dict
(
url_id int(11) DEFAULT '0' NOT
NULL,
Hello list.
I am having strange problems with my Tables since the partition had been
running out of space and mysql crashed. I repaired all the tables and
thought it was a success (no errors were detected anymore) but some days
later there was an error in another table and I fixed it but
Let me add my $.02
CHP A) There's no *point* in keeping the image in the database.
CHP A DBMS is all about searching, comparing, relations, etc. You
CHP get *none* of these by storing the image data in the DB.
Sometimes it just easier to store all things in same place. Right now
I working on
for a particular query i have to select data from five tables.
can any one suggest me a best way to do that in terms of performace..
thanks in advance
muruganandam
-
Before posting, please check:
On Tuesday 28 August 2001 12:36, [EMAIL PROTECTED] wrote:
When you have just inserted a record into a table that autoincrements the
primary key,
is there a way of retrieving the id assigned at the same time? I'm using
ASP to write the
code in question , and I'm trying to find a better
Hallo,
i'm new to mysql. I delete a mysal.host table. Does it means i can't
access the rest of my tables in the database? If so, can i rebuild this
table or is there another way, to access the rest of the tables?
I'am running MySQL under Linux.
Thank's for Comment's, Help ...
Steffen
On Tuesday 28 August 2001 13:55, Harald Fuchs wrote:
In article 01082813314101.11299@redgrave,
Ian Barwick [EMAIL PROTECTED] writes:
You mean using SELECT LAST_INSERT_ID() ?
and praying no other query was run at the same
time.
Try locking the table for writes just before your
When you have just inserted a record into a table that autoincrements the
primary key,
is there a way of retrieving the id assigned at the same time? I'm using ASP
to write the
code in question , and I'm trying to find a better solution that looking at
the max key value
just before/after in
Hello!
Currently replication is implemented between
two mysqld. I would like to suggest new feature.
Make it possible for two mysqld to exchange data
between each other. For example, MERGE tables
distributed between two machines.
Question to authors. How do you think, will
it ever be
It means mysql does not have write permission on the sports directory.
Grigory Bakunov wrote:
Date |Fri, 24 Aug 2001 14:09:20 -0500
From |Tyler Longren [EMAIL PROTECTED]
Hello!
TL DROP TABLE Track
TL Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
TL Anyone know what
See V 4
-Original Message-
From: Alexander Barkov [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 14:13
To: [EMAIL PROTECTED]
Subject: Feature suggestion
Hello!
Currently replication is implemented between
two mysqld. I would like to suggest new feature.
Make it possible for two
Hello all
Please if could someone help, I am running MYSQL to record print
transactions at my company..the way I have set this up is by after a print
job has completeda bat file is run whih basically says...go and insert into
the table the following values
Now on more than 1 occasion the
When the temp directory runs out of space, the thread executing will
wait for space to become free.
If you kill the server, this client has not closed the table properly.
How do you determine that the server crashed ?
If it stopped responding, maybe it is just waiting for space to become
Hi there
We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with
a FreeBSD and a web Apache server 1.3.19 .
The hosting company has just argued MySQL cannot handle more than 1Go in
database files opened per session.
Is it true ?
If so how to go over that 1Go limit ? ( :-) yes
[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:
database,sql,query,table
If you just reply to this message, and include the entire
Tom Churm wrote:
hi,
i have 2 questions that i badly need answered. i use phpmyadmin, but
any answers containing SQL syntax should work in this app...
1)
this should be simple but i don't know it. i use the following mysql
table field as the Key for my tables:
id int(10)
Hi
Is there any design document available of the complete architecture
of the mysql database. I wanted to try out small changes . I want to
make sure that it does not effect any transactions or anythings like
that in any way.
mallik
--
I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win 98SE
client. I do have a question about the menu entries under Commands, Tables for Edit
table and Create tables. I've searched through the help file and didn't find any
mention of these two menu entries, and
Hi!
On Aug 28, Bernard-Olivier Clist wrote:
Hi there
We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with
a FreeBSD and a web Apache server 1.3.19 .
The hosting company has just argued MySQL cannot handle more than 1Go in
database files opened per session.
Is it
This would give you a list of all users that have entered things more than
once; However, it would not give you all the rows that are duplicated.
SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) 1
Hope this helps!
Daniel Von Fange
Hello,
According to MySQL documentation (Chap. 7.1 MyISAM Tables):
Maximum number of keys/table is 32 as default.
However when I try to create more than 16 keys, I get:
ERROR 1069 at line 1: Too many keys specified. Max 16 keys allowed
This table is of MyISAM type.
I am currently running
Hello,
I'm trying to build MySQL 3.23.39 for a LynxOS 3.1.0 platform. I believe that I only
need the client, and have selected the no-server options. However, when trying to run
make it bombs out in the client directory due to the sql_string.cc file which has
declared an include for
In Oracle, I remember working with roles that I could assign to a user. Is
there such a mechanism, or are there plans to implement such a mechanism,
in MySQL.
-
Before posting, please check:
I am trying to install the dbf2mysql converter and really
getting a headache. Someone told me that I need to
install the Include files and libraries for MySQL and I
have been searching frantically all over the web for the
source for this. All I have been able to find is the RPM's.
I am on Mac
Hi mySQL,
I have a huge problem and unfortunately my Domain Hosting Services has no interest in
helping me. I am running mySQL with ASP and use a DSN-less call to connect to mySQL.
The problem is a little bit weird because running the query using phpmyadmin gives me
a perfect recordset.
In Oracle, I remember working with roles that I could assign to a user.
Is
there such a mechanism, or are there plans to implement such a mechanism,
in MySQL.
This sounds a lot link granting a user certain privileges. Here's the part
of the documentation that talks about this:
At 09:57 AM 8/28/01 -0700, you wrote:
In Oracle, I remember working with roles that I could assign to a user.
Is
there such a mechanism, or are there plans to implement such a mechanism,
in MySQL.
This sounds a lot link granting a user certain privileges. Here's the part
of the
I just update the gcc version and still the same problem :
absa# gcc -v
Reading specs from
/usr/local/lib/gcc-lib/i386-unknown-freebsd3.3/3.0.1/specs
Configured with: ../configure --enable-languages=c++
Thread model: posix
gcc version 3.0.1
Any Ideas ?
thanks
- Original Message -
linking tables via MyODBC + MS Access works great for me.
dpk
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2001 12:06 AM
Subject: reports? from MySQL
hello.
with a lot of help from many of you and some very nice folks, i have
been
HI
We are trying to populate a form drop down box (HTML) with a column from our
database. What is the query that will get us that without repeating the
items (in the 500 or so records this column has only 12 non-repeated items)
Thanks.
Kevin Pottie
Internet Designer
O'Dell Web Design
Select Distinct.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: Webmaster Odell [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2001 04:56
Subject: Drop Down Boxes
HI
We are trying to populate a form drop down
On Tue, Aug 28, 2001 at 02:56:13PM -0700, Webmaster Odell wrote:
We are trying to populate a form drop down box (HTML) with a column
from our database. What is the query that will get us that without
repeating the items (in the 500 or so records this column has only
12 non-repeated items)
I'm developing some MySQL applications using VB6 and ADO, and need to do some work on
error handling. I can get the error code easily enough from ADO's Error collection,
but is there a list of error codes and their descriptions. I've been doing this by
generating errors and seeing what codes
If you're accessing via Windows, you can use MyODBC and a reporting
package such as Crystal Reports or Quick Reports or just about any
ODBC-compliant reporting package. You should also be able to link MS
Access to your MySQL database...
For simple reports where you just want to print some data,
Check the source.
include/mysqld_error.h
A. Clausen wrote:
I'm developing some MySQL applications using VB6 and ADO, and need to do some work
on error handling. I can get the error code easily enough from ADO's Error
collection, but is there a list of error codes and their descriptions.
Greetings everyone!
I had 2 questions related to using BDB and mysql. I
don't see any startup options for BDB, so can I safely assume that there
are'nt any , so don't need a my.cnf file? Also, how do I specify 'autocommit
off' every time BDB starts, instead of specifying it
I have problems only converting certain DBF files to mysql with dbf2mysql.
Some work but some don't and when they dont' I get the following error
bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF
Error creating table!
Detailed report: You have an error in your SQL syntax
Hi !!!
)-Original Message-
)From: Armando Cerna [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, August 28, 2001 1:27 PM
)To: [EMAIL PROTECTED]
)Subject: dbf2mysql problem please help
)
)
)I have problems only converting certain DBF files to mysql with
)dbf2mysql.
)Some work but some don't and
Hi guys, could anybody help me? I have a very big database. When I make
querys to my database, depends on the type of query, it takes a lot of time.
I want to implement a progress indicator. Is there any way to implement
something like this?
Thanks
Claudio P.
Not really a MySQL question, but it is related to the MySQL web site
If I go to:
http://www.mysql.com/udmsearch/search.php
the Support link is spelled Pupport (on other pages it is spelled
correctly, however)whoops :)
--Sam
Sam Masiello
Software Quality Assurance Engineer (providing
On Tue, Aug 28, 2001 at 05:10:17PM -0400, Sam Masiello wrote:
Not really a MySQL question, but it is related to the MySQL web site
I forwarded it to [EMAIL PROTECTED], which is where that sort of
thing should go... Few folks on this list have any control of MySQL's
web site.
Jeremy
--
Hi,
Damn you guys are fast! :)
Fixed. But the udmsearch is busted right now for unknown reasons. I
will fix shortly.
Matt
Jeremy Zawodny writes:
FYI...
- Forwarded message from Sam Masiello [EMAIL PROTECTED] -
From: Sam Masiello [EMAIL PROTECTED]
To: MySQL General
This is really stupid, but I can remember how to save results of SHOW
CREATE TABLE tbl_name and SHOW COLUMNS FROM tbl_name in to text file. I'm
running mysql 23.41 on Win2k.
Thanks in advance
--
Martin Jeremic
mailto:[EMAIL PROTECTED]
Hello,
I just installed mysql-max-3.23.41 on Linux. All went smooth but
alas cannot get myqld to start. here is the log from the systemname.err
file in mysql/data directory:
010828 14:26:30 mysqld started
Can't initialize InnoDB as 'innodb_data_file_path' is not set
010828 14:26:30
How do I do exact phrase matches using FULLTEXT?
I have this 2 million row table, full of text data, that I want to search
for an exact phrase. When I say:
select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID;
It works correctly, returning 1 row, MUCH faster than doing a select
Hi!
On Aug 28, Ed Carp wrote:
How do I do exact phrase matches using FULLTEXT?
I have this 2 million row table, full of text data, that I want to search
for an exact phrase. When I say:
select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID;
It works correctly, returning 1
On Aug 28, Ed Carp wrote:
How do I do exact phrase matches using FULLTEXT?
I have this 2 million row table, full of text data, that I want
to search
for an exact phrase. When I say:
select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID;
It works correctly, returning
Hello,
I have a problem with the access :
I have created 2 users with no privileges in the user table (privileges are
set in the db table, so those users can only access one particular db).
the first user has all the privileges set to Y for the db hello, this user
works fine.
the second user
This is covered in the mysql manual here:
http://www.mysql.com/doc/P/o/Post-installation.html
First, you need to install the default databases ( installs
mysql/host.frm ):
bash mysql_install_db
Then tell mysql not to use InnoDB:
put this in your /etc/my.cnf file:
[mysqld]
skip-innodb
ERROR 1044: Access denied for user: '@localhost' to database 'hello'
This says that you are connected as user '' ( blank ) from localhost. Make
sure you're logging on correctly and try again.
dpk
-
Before posting, please
- Original Message -
From: Dana Powers [EMAIL PROTECTED]
To: Pierre-Yves [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 1:22 AM
Subject: Re: ERROR 1044: Access denied
ERROR 1044: Access denied for user: '@localhost' to database 'hello'
This says that you
hello all,
i am trying to install web calendar software on my machine, which is
available at sourceforge.net website. to run that software first of all
a textfile named tables-mysql.sql needs to imported into the mysql
database. for doing that i typed the following command at the shell
prompt
The way mysql access tables work, if it cant find a user named 'user2', it
will default to the blank user ( '' ).
dpk
- Original Message -
From: Pierre-Yves [EMAIL PROTECTED]
To: Dana Powers [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2001 4:39 PM
Subject: Re: ERROR
Description:
I downloaded, via ftp, and installed MySQL-3.23.41-1.i386.rpm.
The user instructions at the end of the rpm -i ./*.rpm command
proscripbed the use of /usr/bin/mysqladmin -u root -p password 'new-password'
and /usr/bin/mysqladmin -u root -h 'my-dns-name' -p password 'new-password'.
Hi all, I just joined list. I spent a couple hours in the archive and
decided MySQL better improve their install message regarding setting the
root password! Half the posts are about it going badly. ;)
I believe I found the answer in the archives, but they all aren't the same
answer. So is the
Hi!
ajgrif == ajgrif [EMAIL PROTECTED] writes:
Description:
ajgrif I downloaded the lated AIX binary from mysql.com, and unpacked it to
/usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db
per the INSTALL-BINARY file. This is the error I recieve:
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Jeremy Zawodny writes:
I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm
trying to build the MySQL client libraries. According to the
INSTALL-SOURCE file, I need to use a command-line like this:
CC=gcc
Hi all, I got a No Database Chosen. What's the syntax for adding the
database? I tried *.*, mysql, and test between UPDATE and user but all
returned syntax error.
Thanks much, Gregg
UPDATE user SET Password=PASSWORD(desiredpasswordhere) WHERE User=root;
Alok K. Dhir ([EMAIL PROTECTED]) writes:
select * from Laws WHERE MATCH(Line) AGAINST ('growth
hormone') AND Line like '%growth hormone%' ORDER BY ID;
This defeats the purpose of the fulltext index, don't you think?
Not really - since the WHERE clause is executed left to right, the
Hi,
we are using mysql 3.23.33 on HPUX11 and every time we reboot the machine,
it overwrites the binary log and starts from 001 again. This is only
happening on a couple of machines. It doesn't do this if i manually
restart mysql, only when the machine is rebooted.
On one of the machines, mysql
shell # mysqlimport -u root -p webcalendar tables-mysql.sql
where, 'webcalendar' is the database that i have created for this
purpose. after entering the password at the password prompt it is
displaying the following error:
mysqlimport: Error: You have an error in your SQL syntax near
Just a kudos to those that redid the MySQL site.
DAMMM IT LOOKS GOOD
Excellent job!!!
Cheers
M;)
Quote from The Young Ones:
I suppose you think it's pretty weird, don't you Mike? Well, you'd be right.
Because THAT's the kind of guy I am, right! WEIRD! Which is why I go
i'd like to ask...
if any of you are familar with (File Maker Pro, most recent
versions)... how does one go about using MySQL to create a printable
report? e.g., where you select the fields you wanted in the report
and then create a layout and page setup for the report, (then print
it)?
Date |Tue, 28 Aug 2001 16:32:49 +0530
From |muruganandam [EMAIL PROTECTED]
Hello!
M for a particular query i have to select data from five tables.
M can any one suggest me a best way to do that in terms of performace..
M thanks in advance
M muruganandam
Please give more details. Like table
G'day,
Is it possible to compile mysql with InnoDB for AMD Athlon processor ?
Error produced during compilation follows:
make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync'
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include
-DDBUG_OFF -O3
-DDBUG_OFF
87 matches
Mail list logo