Hi, I have downloaded the standard binary RPM for i386 (3.22.35) but it doesnt
include the Berkeley-DB library for the use the transaction in MYSQL.
Could you send me a stable version of MySQL in standar binary RPM with
transactions by using the Berkeley DB library ? Thanks you.
Hi,
Type all of the create statement in a text file (i.e. sql_file) and then
just call mysql [database] sql_file from the prompt.
As for the editor, you can use any common text file editor available
(xemacs, vi, pico, nano).
Regards,
Jorge
MySQL Development Team
__ ___ __ __
None exists. To create your own rpm is very simple:
Download source rpm
Install source rpm with rpm -i
Files will appear in /usr/src/redhat tree
Change to /usr/src/redhat/SPECS
Modify mysql.spec file to include BDB (just uncomment line on - easy to find)
Next build with rpm --bb --target=i686
When I have created a comment on a table with "create table . comment =
'this is a comment' How do I view the comment afterwards?
...Jesper
-
Before posting, please check:
http://www.mysql.com/manual.php (the
MG PUBLISHING
4865 HWY 138,R.R 1
ST-ANDREWS WEST
ONTARIO, KOC 2A0
1-800-301-8093
http://www.mgpublishing.net
PRESS RELEASE
CANADIAN SUBSIDY DIRECTORY YEAR 2001 EDITION
Legal Deposit-National Library of Canada
ISBN 2-922870-01-4
M.G. Publishing is offering to the public a revised edition of
Hi Gert!
Thanks for the very, very excellent tip - worked just great!
Now I can start on the PHP coding :-))
Bye!
Frank Hacker ([EMAIL PROTECTED])
EDV Abteilung / IT Dept.
Gebr. Reinfurt Wuerzburg
Miniaturkugellager
Gneisenaustr. 10-11
97074 Wuerzburg
Germany
Tel.: +49 (0) 931 7952 354
Fax:
Hi !
I've just upgraded to the new mysql server 3.23.32 and in the error log I now see
'Aborted connection ... (Got an error reading communication packets)'.
I have found information about this problem such as using the binary release instead
of the source release.
I have now done this and
Hi,
On Wed, Mar 21, 2001 at 08:39:55AM +0100, Benjamin Pflugmann wrote:
Sorry to contradict, but have a look:
newton:~ mysql -u root -e "select version()"
+---+
| version() |
+---+
| 3.23.33 |
+---+
8:26:25 newton:~ sudo -u mysql touch /tmp/test # just created
"Forrest" == Forrest Aldrich [EMAIL PROTECTED] writes:
Forrest I would like to know if anyone has worked with
Forrest implementing a MySQL database backend with BIND 9. I'm
Forrest interested in table design, implementation, how/if
Forrest dynamic dns is stored there, etc.
The
[EMAIL PROTECTED] writes:
Description:
mysql_convert_table_format ignores password setting for client in my.cnf.
How-To-Repeat:
create ~/.my.cnf with this:
[client]
password=SomeThing
with that as your account's password.
run 'mysql_convert_table_format test'
Shankar Unni writes:
I don't see implementation of "CHECK" CONSTRAINTS in the TODO list (e.g.
CONSTRAINT val_ck check (val = 0 and val =5)
Is this planned?
I do see FOREIGN KEY constraints on the 4.0 list, so there is a way to do
this kind of checking once this is
denis writes:
Any ETA on corrected RPM's?
Should be out this weekend or in the beginning of next week.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*|
Stephan Skusa writes:
Additional Info:
010322 5:15:35 Verbindungsabbruch 13 zu db: 'sleid' user: 'sleid' host:
`archimedes.lippe-net.de' (Fehler beim Lesen eines Commu
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace
I am trying to log activity on a web site and then display the activity. I want to be
able to break it down by hour eventually. Right now I would like to get the total hits
and the
hits for today. I have created a table like the one below.
create table hits (page_id INTEGER, htime
I've been looking into the help files provided for this command, and
couldn't see a reference to the thing I'm wanting to do (so I've assumed it
can't be done). BUT, just wanted confirmation in case there's a way to do
this:
I'm expecting to get a CSV file soon that I need to import into my
Hello,
could anyone explain me how to backup and in case of system crash
restore
the mysql database (main database where data about other databases,
grants,users, etc. is kept)?
Thanks in advance !
Regards,
Saulius Gurklys
mailto:[EMAIL PROTECTED]
Because it is my.cnf, not my.cfg.
Also they need to be world readable.
roger westin wrote:
Have the same problem, nither the server or any client seems to read the
my.cfg files,
they are just going on the precompiled default value.
Have tried to recomplie and alot off stuff but I always
The full path to the mysql.sock file must be readable, and searchable
for
the client to find and open the socket.
Craig Cummings wrote:
Hi there,
I recently upgraded my Linux kernel to 2.4.2 and my perl DBI/DBD
and now MySQL is behaving strangely. If I'm logged into my system as
Anybody know how to solve the Same Problem in Access 2K ?
Cheers
Chris
= Original Message From Frank Hacker [EMAIL PROTECTED] =
Hi Gert!
Thanks for the very, very excellent tip - worked just great!
Now I can start on the PHP coding :-))
Bye!
Frank Hacker ([EMAIL PROTECTED])
EDV
STIBS wrote:
Hi list!
I try to change my data dir from the default /var/lib/mysql to /usr/mysql .
On a standard Suse install I did the following:
- copying all databases cp -R * /usr/mysql
- changing the datadir in /etc/my.cnf to /usr/mysql
- mysql restart
- works fine
On my
Hi,
I'm new to the list so please excuse my ignorance!
Does anybody know of any graphical ways of modelling
the tables, keys, relationships etc which will then
automatically generate the appropriate database?
I'm looking at RAD with a MySQL back end.
Thanks
Claire.
Hi,
I dont know whats wrong with my mysql but when I add a column with auto_inc
(I just copied and paseted what you did) I got: Primary key cannot be NULL,
so, but I got it working So thanks anyway.
And as I always say... If something works, dont touch int.
So I wont reinstall.
/roger
Can anybody tell me if my VB5 programs can query an MySQL DataBase on a
Remote server?
If so, what should I distribute with my software?
I have done some things like that, and since VB unses standard ODBC
connections the
only thing you need to include in your dist is the MyODBC API
/roger
http://www.mysql.com/documentation/dezign/index.html
There are several other tools available but I don't remember them off the
top of my head.
Cal
http://www.calevans.com
-Original Message-
From: claire csoka [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 8:35 AM
To: [EMAIL
Sorry..
thats was realy stupid Right... it works fine now...
It wasn't the permissions, it was the filename hmm.
hahaha
:)
/roger
Because it is my.cnf, not my.cfg.
Also they need to be world readable.
roger westin wrote:
Have the same problem, nither the server or
Is it possible to install Mysql server clients and odbc
in my own setup program ?
I mean that i created a Visual Basic Project and i
also create a setup wizard for this application.
I also wanted to distribute mysql server ,
mysql clients and mysql odbc softwares included
in my setup
I installed mysql as a service and it starts/stops fine, but whenever I try any
commands starting with 'mysql' on the prompt it says it's an unrecognized command.
Please help.
Test, Please ignore.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe,
Dezign looks useful, but does anybody know any others - then
I'll stop bugging you all.
Thanks in advance,
Claire.
From: "Cal Evans" [EMAIL PROTECTED]
To: "claire csoka" [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Graphical modelling
Date: Thu, 22 Mar 2001 08:59:59 -0600
Hi,
I recantly upgraded from 3.22.32 to 3.23.35 using an rpm from
www.mysql.com.
My platform: Redhat Linux 2.2.14 i686
The problem is now that UPDATE do not always succed. I get a query OK
but no
update is done unless the same query is issued once again.
This problem is not constant but
Are you in the right directory, or do you have your PATH environment
variable set to point to the right directory? Running mysql from C:\windows\
is unlikely to work unless you've tweaked your settings.
HTH
Jon
-Original Message-
From: Daniel J. [mailto:[EMAIL PROTECTED]]
Sent: 22
Hi
Please make sure the PATH environmental variable includes the location of
mysql/bin e.g. %PATH%;x:\mysql\bin. Where x = a drive letter.
At 09:20 22/03/2001 -0800, Daniel J. wrote:
I installed mysql as a service and it starts/stops fine, but whenever I
try any commands starting with 'mysql'
Hi,
I have these 3 tables which hold order information
for a web site.
One table holds the shipping info/credit cart stuff,
another one holds one type of item ('home accents'),
and the other one holds house plans.
When someone orders these items, due to the options on
house plans, I must store
Hi,
This is my first posting, although i've been signed up to the list for a
while.
My problem is this.
Table A (5000 rows)
ID, NAME, SCORE
Table B (1000 rows)
ID, NAME, SCORE
I want all records from Table A and those from Table B where they match, for
this i'm using a right join. However,
You need to add the \mysql\bin directory to your path.
Dunc.
-Original Message-
From: Daniel J. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 12:20 PM
To: [EMAIL PROTECTED]
Subject: MYSQL on Windows 2k
I installed mysql as a service and it starts/stops fine, but whenever I
On Thursday 22 March 2001 16:46, Johan Vanroose wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Replication does not continue after removal/replace of network
cable.
Description:
Configuration.
Two servers (PCs) running mysql, both are master and slave to each
other.
After running ./configure ; make ; make install when trying to run
mysql_install_db the error "Didn't find /usr/local/libexec/mysqld
You should do a 'make install' before executing this script" . How do I go
about resolving this issue ?
\
I tried half a dozen or so different ones a while back and settled on CASEStudio,
www.casestudio.com.
Mark Chalkley
Beneficial Systems, Inc.
*** REPLY SEPARATOR ***
On 3/22/2001 at 3:35 PM claire csoka wrote:
Dezign looks useful, but does anybody know any others - then
I'll
Sinisa Milivojevic wrote:
Hi!
With :
select * from table;
queries MySQL returns results immediately.
Any problem that you experience might come only from poor build, some
OS bug or some wrong settings.
Thanks for the reply! That's good to know at least. I really didn't
know
if
Description:
Compilation problem on SunOS intel.
How-To-Repeat:
Try to build using gcc (package from sunfreeware) and configuring
like this:
sh configure \
--enable-thread-safe-client \
--enable-assembler \
Hi!
I posted an incomplete Innobase manual at my website. I will
be updating it daily as the writing progresses.
Best regards,
Heikki Tuuri
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Thanks
Sinisa Milivojevic wrote:
denis writes:
Any ETA on corrected RPM's?
Should be out this weekend or in the beginning of next week.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/
Thank you very much. This did the trick! The /var/lib/mysql directory
needed to be readable and executable. I don't know why the Kernel upgrade
changed this but it's good now.
-Craig
On Thu, 22 Mar 2001, Gerald Clark wrote:
The full path to the mysql.sock file must be readable, and
Maxim,
I posted a very similar question yesterday and got a very helpful reply.
Please see it below:
Databases are essentially just directories. What you do is create a
directory in the users home directory. Then, do this:
ln -s /path/to/home/dbdir /path/to/mysql/data/dir/somedbname
Then
I know Oracle has been modified to use XML files as the database,
making queries directly to a flat file
No, thats not how it works.
They format the *output* with XML making it easier for an application
that can parse XML to import the data.
Hello
If table xyz is a symbolic link (recommended in the manual for very big files
that do not fit on a single partition) then "ALTER TABLE xyz TYPE=ISAM;"
ignores this, removes the link and recreate the table on the data directory.
I consider it a bug, as it is
a) not what the user expects,
I'm gonna take a crack at this.
The type keyword in the alter table command is there to convert databases
from one type to another. While yes, I do think that the MySQL team could
check if the types are the same and not recreate the table if it isn't
necessary. I don't consider it a bug that
hey all! I'm developing a CGI app for access to a mysql table. I want
to offer users the ability to arbitrarily sort the results. That is,
given the following table:
letter
-
A
B
C
I want to sort the results as B,C,A , C,A,B, and such. I need to do
this from a single select statement so
Hi,
This is a bit unclear - any sorting is either based on some combination of
values, be they columns, bits of columns, static values or random values,
and so can be expressed as an Order BY clause.
For example, I have a report that allows the user to say in which order the
columns should be
Mysql experts,
I downloaded the binary distribution for AIX on a Risc/6000 and tried to
install it. However, when I get to the mysql_install_db part I get the
following error which ultimately fails to complete.
# scripts/mysql_install_db
Could not load program ./bin/my_print_defaults:
hello all,
thanks for the replies regarding why problems using msqry32.exe. ultimately, my
flaw was that i had created a GRANT for the database "cat" while the ODBC DSN
connection was trying to use the database "CAT". uppercase got me, a common
problem of mine.
thanks again.
First off check you version of aix. Also you have to install the zlib
packed, that is where you will find libz.a library I had this very problem
and it took me a whie to hunt down aprpriate files.
I was on aix 4.3.0 and now 4.3.3(the zlib package needs thenewer OS.) you
can look: on
Jack,
My AIX oslevel reports 4.3.2. The zlib package is already installed. The
libz.a file is easily found in /usr/local/lib. It just won't load for some
reason. I must have some library problems with shr.o. Any thoughts?
Tim
First off check you version of aix. Also you have to
I would look into the Lib paths...though this is a quick sanity check...(I
have to ask)
when you execute the script mysql_install_db
are you in some pathmysql-3.xx.xx-aix/
or in the scripts directory? I ask because that can mess the script up.
since it is looking into a relative directory for
Hi,
I am new on this list, and also new on mysql, i know little much abt
database and SQL as i learn in my graduate course, is there any online
documentation available for SQL or Database, so i referesh my knowledge and
create database on mysql. I already installed mysql server on Solaris 8(x86)
Hello
This one appeared on a Debian mailing list.
I know that this is fixed in the latest versions as they allow running the
server as non-root user and so it is not considered as a bug ()
but I'm sure that there're administrators out there which are not aware of
this exploiting method!
trying to make a simple database for our alumni organization. hope to hear
soon!
Thanks,
Moin
First there is a very good doc on www.mysql.com and you can find info on
www.devshed.com but also on many other websites. Use your favorite
searchengine!
You might want to buy a good book. I'm using
http://www.mysql.com/documentation/index.html
Cal
http://www.calevans.com
-Original Message-
From: Khan, Moin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 3:33 PM
To: [EMAIL PROTECTED]
Subject: SQL Documentation
Hi,
I am new on this list, and also new on mysql, i know
Hello All,
I have a table with a column called "bus_name" varchar(100) which is used in a
Business Name search form. I need to make the Business Name that is entered into
the search form case in-sensitive to the column "bus_name" IE. If we have a
entry in the column "bus_name" "The Happy Shop",
If you add BINARY to the column it WILL make it case sensitive.
On Thursday 22 March 2001 22:01, you wrote:
Hello All,
I have a table with a column called "bus_name" varchar(100) which is used
in a Business Name search form. I need to make the Business Name that is
entered into the search
I already view this document, but its not have enought information regarding
SQL, its give you good information on how to install and manage mysql
server, but a very little abt sql. i am looking for in depth information on
sql. hope to hear soon.
thanks,
Moin
-Original Message-
From: Cal
My favorite (dead tree) SQL primer is:
http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0764504150vm=
Don't let the name fool you, it's an excellent primer.
Cal
http://www.calevans.com
-Original Message-
From: Khan, Moin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22,
Try
Select * from table where upper(bus_name)= upper('whater I am searching
for');
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
Of MikemickaloBlezien
Sent: Thursday, March 22, 2001 4:02 PM
To: [EMAIL PROTECTED]
Subject:
On Thu, 22 Mar 2001 22:27:06 +, Jordan Elver [EMAIL PROTECTED]
wrote:
Ignore this post! My fault, we had something coded wrong in the script.! It
works fine now.
My apologies to the list! :(
If you add BINARY to the column it WILL make it case sensitive.
On Thursday 22 March 2001 22:01,
Here's an online SQL tutorial you may find helpful.
http://www.sqlcourse.com/
--jfarr
- Original Message -
From: "Khan, Moin" [EMAIL PROTECTED]
To: "'Cal Evans'" [EMAIL PROTECTED]; "Khan, Moin" [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, March 22, 2001 3:02 PM
Subject: RE: SQL
in my university life we have a course of RDBMS, and we read this book
http://www.amazon.com/exec/obidos/ASIN/0201385902/qid=985302791/sr=1-6/ref=s
c_b_7/002-2170015-1024007
but , ofcourse we have its earlier editition. right now i dont have that
book, so, i am looking similar sort of
Daniel ...
Make sure the path to C:\MYSQL\BIN (or wherever it is installed) is in the
PATH environment variable (Settings - Control - System - Environment).
Login as Administrator and edit the value for the path variable, set and
apply ... your problems should be over!
G. Jensen
- Original
If it were me, I'd create a new table in the database with enough columns
to handle all the data in the file. Then I'd do insert . . . . select
into the table that need the data.
Hope this helps,
Michael Ridinger
On Thu, 22 Mar 2001, Daniel Newman wrote:
I've been looking into the help
On Thu, 22 Mar 2001 17:01:35 -0600, "Cal Evans" [EMAIL PROTECTED] wrote:
Thank Cal, I found the problem in our coding, not the query, so it works fine
now! My apologies to the list.
Appreciate the help :)
Try
Select * from table where upper(bus_name)= upper('whater I am searching
for');
i have a MySQL server running in my office. i need to be able to telnet into
the MySQL server remotely. can anyone point me at documentation that will tell
me how?
right now (from a dos window) when i issue:
TELNET server.name 3306
- it reports "BAD HANDSHAKE"
i think that somehow i
Hi,
You don't telnet to the server, you use the mysql command line client
$ mysql --host="yourhost"
etc.
Quentin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, 23 March 2001 12:53 p.m.
To: [EMAIL PROTECTED]
Subject: howto: telnet shell
i have a
do you mean that you want to go into the database console directly from your office?
Alan.
i have a MySQL server running in my office. i need to be able to telnet into
the MySQL server remotely. can anyone point me at documentation that will tell
me how?
right now (from a dos window)
Using a Win2K server, with 3.23.34 of mySQL - get these messages
occassionally and have set the service to restart on a sudden stop.
Database error in vBulletin: Link-ID == false, connect failed
mysql error:
mysql error number:
Date: Friday 23rd of March 2001 02:06:06 PM
Script:
Hello,
I am developing a web database for a new small-time real estate company, and
I have been reading into using MySQL. I have read that there is minimal
email support for MySQL problems, unless one pays for one of your 5 support
packages. What I would like to know is, if they decide to use
Hai,
I am using Red Hat Linux 7. From where can I get example programmes of
connectiong to MYSQL using PERL under Linux.
Thankyou
Rajeev Ramanujan
I don't know how you define 'minimal' but approximately 100+ emails per day from the
user list and a response time from 5 minutes to 24 hours should be adequate for the
average "small-time real estate company" as you call it. Coming to "What will you guys
answer and not answer", I guess there
Hi,
Have you installed DBI/DBD?? if so you can perldoc DBI or perldoc mysql_dbd to read
the manual.
Alan.
Hai,
I am using Red Hat Linux 7. From where can I get example programmes of
connectiong to MYSQL using PERL under Linux.
Thankyou
Rajeev Ramanujan
as someone else has mentioned, you would need to install mysql client into your
computer and then use the command
mysql -uuserid -hhosename -p
to access your remote database.
Alan.
yes, that is what i am wanting to do. i have found a way around by using uSOFT
Query, but would like to get
Hi,
I am planning a very large search engine. I've spent some time reading
the archive and I found some suggestions on how to do this. The word
indexing method is a very interesting alternative to slow "...where like
'%foo%';" queries.
There is from 100k to 500k documents to index, each are
Hello.
On Thu, Mar 22, 2001 at 10:43:18PM +0100, [EMAIL PROTECTED] wrote:
Hello
This one appeared on a Debian mailing list.
I know that this is fixed in the latest versions as they allow running the
server as non-root user and so it is not considered as a bug ()
but I'm sure that
When I use C API ,mysql_query.
I got an error :
Commands out of sync; You can't run this command now
what this mean and what should I do?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
where's the second option?
about your construction:
We populate 2 tables:
one containing the documents (text and ID)
one containing all the words and the documents ID containing each word
how you plan to make 1 table with words, and several (unlimited)
document_ids?
what you'll need is:
1
Why not just telnet into the server where mysql is running and log into mysql from
there? That way, there is no need
to install mysql client. It look like he already has a telnet client on the
computer...
Seung-woo Nam
[EMAIL PROTECTED] wrote:
as someone else has mentioned, you would need
maybe he hasn't got telnet server. probably win32 w2k.
- Original Message -
From: "Seung-woo Nam" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 6:41 AM
Subject: Re: howto: telnet shell
Why not just telnet into the server where mysql is running and log into
Ok... I've posted briefly regarding this, but heres a complete bug report.
Yeah I know its kinda long, but I thought it better to include more rather
than less.
We are seeing a problem which results in mysqld dying with a SIGSEGV. The
problem has been confirmed on both these machines
Linux
85 matches
Mail list logo
