Hi:
Check This!
-
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,
Hello.
Does anybody worked with LDAP + MySQL ?
Thanks in advance,
Alex Kontorovich - DBA
-
Tel:(+972)9 - 9519133
Mobile: (+972)54 - 424862
E-mail: [EMAIL PROTECTED]
Rolf Hopkins schrieb:
"^M"??? You sure it is that? Anyway, it is most likely to do with carriage
returns. Windows uses CR and LF to indicate a new line, while Linux and
Macs only use LF. Hopefully this will help. Don't know what you can do
about it though.
- Original Message
hi there,
at the mysql prompt i can get the exact time taken to run each query.
how can i display this time in an HTML page via PHP. is there a function
which gives me this time
bye
Mathew
-
Before posting, please
On Tue, 13 Feb 2001, Donald Korth wrote:
The hosting company has given me a user name and passwd . When i log into my own
site thro' a telnet session i 'm able to view all the databases created in the server
that includes DBs not created by me . I also did a "USE DB" command to connect to
At 15:12 12/02/2001 -0500, WJ McEachran wrote:
Hi!
MySQL doesn't support Windows clustered servers because besides
the transaction feature is necessary the development of the
resource manager to have the fail over.
Regards,
Miguel
I've just been exposed to Access 2000 :-(
I'd be interested in
At 10:34 12/02/2001 -0700, John Halladay wrote:
Hi!
Generally your problem happened when you did the linking of the
MySQL table, Access didn't find a primary key column and you
didn't select any.
If the above is right, add a primary key column and link the
table again.
Regards,
Miguel
I've
Hi;
I'm getting this error:
Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 = 3.0.8
What does it mean and what should I do about it (if anything)?
TIA,
BenO
-
Before posting, please check:
I am not very sure of what exactly does this this mean but I guess that the
particular module that you are installing requires a cversion of PHP that
has to be greater than 3.0.8.
This is just a guess. I aplogize if it's wrong.
regards
Ankur Verma
HCL Technologies
A1CD, Sec -16
Noida, UP
India
Hello,
at the time I try to figure out what's the best way
to get a kind of parent/child - hierarchy with unlimited
subchild.
My special attention is situated on really fast SELECT statements.
Actually I'm using nested sets like:
CREATE TABLE Personnel
(emp CHAR(10) PRIMARY KEY,
salary
Say I have a bunch of records in a table with a bunch of fields. One of
those fields is cluster_id. It is not unique. However, I want to make a
unique set. I want one record for each cluster_id value. I don't care
which record that is.
Right now, I do:
SELECT DISTINCT cluster_id FROM my_table
On Tue, 13 Feb 2001, Irmund Thum wrote:
Rolf Hopkins schrieb:
"^M"??? You sure it is that? Anyway, it is most likely to do with carriage
returns. Windows uses CR and LF to indicate a new line, while Linux and
Macs only use LF. Hopefully this will help. Don't know what you can do
Hi All
I am going to have replication on mySQL database. I am just starting to
write a script to see if the slave can connect to the master. If not then do
one last check to see if the master is down by trying to connect to it. Then
connect to slave set slave as master. When that is sorted do
can you please stop sending attachments through the list?
At 11:24 AM +0100 2/13/01, Irmund Thum wrote:
Rolf Hopkins schrieb:
"^M"??? You sure it is that? Anyway, it is most likely to do with carriage
returns. Windows uses CR and LF to indicate a new line, while Linux and
Macs only use
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Caching Bug with AUTO_INCREMENT columns
Description:
When i use a table with an AUTO_INCREMENT column and
insert Data in the Table with a NULL Value for the
AUTO_INCREMENT column, AUTO_INCREMENT sets an new value
Thomas Kaester writes:
Hello Sinisa and everybody who can help me!
I try to develop a UDF which returns a string! But I get only 256 characters of the
string! I tried to change my alloc function, so that I only use my_malloc and
my_free! But the result is the same! The necessary memory
I have MySQL running on a cobalt Raq 3 with linux operating system. I have
set up MyODBC and I can connect through MS Access I can also connect through
MS Frontpage and created a simple web interface to retrieve some results
from my db however when uploaded I recieve no results when I definatly
Guys,
I know it's off topic but this virus seems to be spreading quite violently,
I've had to remove from one of our clients machines this morning.
If you become infected with it, it's a simple remove procedure.
1. Remove the reference to OnTheFly in the registry, look for the text VBS
and
[...]. Currently, in MySQL
you must call UNLOCK TABLES before issuing another LOCK TABLES, because
there is no deadlock detection in MySQL itself.
I believe a LOCK TABLES does an automatic atomic UNLOCK TABLES of any
that were locked before if it's able to get the requested locks.
Tim.
Hi,
at the mysql prompt i can get the exact time taken to run each query.
how can i display this time in an HTML page via PHP. is there a function
which gives me this time
Unfortunately, no, there isn't a built-in function to do this. So, you'll
have to resort to some DIY. But, it's quite
Problem is that most ISPs can't afford a competent DBA...;(
clay bond wrote:
On Tue, 13 Feb 2001, Donald Korth wrote:
The hosting company has given me a user name and passwd . When i log into my own
site thro' a telnet session i 'm able to view all the databases created in the server
that
Absolutely this is nothing short of bad adminingIbet you could scag in their
passwd file and has root access in short order...;( And of course the ISP will blame
mysql if anything happens to them though...lazy bad ISP
cheers,
mikel
Donald Korth wrote:
Hello
The hosting company
While the output you've shown could well be considered eroneous, surely
you shouldn't be relying on this sort of logic in a decent piece of code
? Or am I missing something ?
If you're trying to work out which row was inserted most recently,
shouldn't you be using your db handle lastinsert_id
When ftp'ing the file use the ASCII mode instead of the BINARY mode. All
CR/LF conversions will take place automagically. Alternatively some linux
distributions have a utility to strip CR's from ASCII files and there is
always old reliable vi .
I hope this helps...
Pat...
[EMAIL PROTECTED]
At 23:04 12-02-2001 -0800, John W Ford wrote:
I can't figure out why my windows machine leaves "^M" character at the end
of each line of code. This causes the file to be messed up when I put it on
the Linux server.
That's a carriage return. DOS/Windows ends a line with a carriage return
followed
What you have just described means that database permissions have not been
set up correctly and your ISP has left himself wide open for all kinds of
attacks and I'm not just talking about attacks on the database itself but
also attacks on the whole system. Ie access to unix root. DOS, etc
Read
Hello,
I'm having a problem exporting MySQL BLOB's to Oracle, especially those
records that has "Carriage Return" or "Line Feed" characters in them.
Has anyone done this before, and how did they do it? I need an immediate
help in this subject. I'd appreciate you help very much.
Thanks
Noor
Hello,
We operate a forums website and use Phorum web application (PHP/MySQL
backend), more info: http://www.phorum.org
After operating for two years now, we are facing a serious problem.
Giving the fact that the forums are full of content, ONE (1) search
operation on a single forum is draining
Hello everyone
Does anyone know why and when occurs the following error :
Cannot load connection class 'java.sql.SQLException
Thanks a lot !
Daniel Ducat
-
Before posting, please check:
http://www.mysql.com/manual.php
can anyone figure out why the following code works fine when both select
variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH
select variables equal something other than "ALL"?
here is the code:
What area of the city would you like to dine in?
?php
Hello!
I think that one feature will be useful:
limits (like UNIX limit feature) on per-thread basis. On public-access site
(for instance, free hosting with mysql) poorly-written SQL can make quite a
load; limiting usage can forcedly kill such requests.
I could not subscribe to developers
Hi:
Check This!
-
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,
Rolf Hopkins wrote:
What you have just described means that database permissions have not been
set up correctly and your ISP has left himself wide open for all kinds of
attacks and I'm not just talking about attacks on the database itself but
also attacks on the whole system. Ie access to
Didn't Oracle just release a MySQL to Oracle migration kit? Check the
Oracle website.
Cal
http://www.calevans.com
-Original Message-
From: Noor Dawod [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 8:41 AM
To: MySQL List
Subject: Exporting data from MySQL to Oracle
Hi Matt,
Think you will find: http://www.scibit.com/MySQL useful
-Original Message-
From: Matt Davis [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2001 14:47
To: [EMAIL PROTECTED]
Subject: ASP and MySQL
I have MySQL running on a cobalt Raq 3 with linux operating system. I have
I suppose that only way to reorganize unique field is to use another table.
- Original Message -
From: Irmund Thum [EMAIL PROTECTED]
To: Rus [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 8:53 AM
Subject: Re: mysqlimport - LOAD DATA LOCAL INFILE
Rus schrieb:
A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE
clause
eg I did
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq
instead of
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq WHERE MATCH Q,A AGAINST ("This")
The latter will give much better
Hi
Hmm, this seems to me like redundant code.. if you're holding info in
Score, and not using it but only using the same operation that was used
to create it, then it's a redundant code..
Are you sure the second form works faster than the first one?
Noor
-Original Message-
From: Jason
I couldn't find such product on Oracle's website.
Noor
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 5:51 PM
To: Noor Dawod; MySQL List
Subject: RE: Exporting data from MySQL to Oracle
Didn't Oracle just release a MySQL to Oracle
From what someone on this (can't remember who or I would give credit) list told me,
It ONLY uses the index if you have it in the WHE
RE clause... and apparently the SQL optimizer catches that the MATCH AGAINST is the
same in both places and only runs it once...
- Original Message -
Oh no, not another one
-Original Message-
From: Mike Hammonds [mailto:[EMAIL PROTECTED]]
Sent: 12 February 2001 18:30
To: [EMAIL PROTECTED]
Subject: Here you have, ;o)
Hi:
Check This!
-
Before posting, please
I couldn't fine this mentioned in the archives, so I hope someone has seen
this before:
I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
There is still server process (sleeping), and there is still a pidfile.
This can happen after ten or fifteen minutes of queries.
I
On Tue, 13 Feb 2001, Peter Skipworth wrote:
Or a handy one-liner...
perl -pi -e "s/[\012\015]//" *.sql
Or alternatively edit the file with vi and do:
:s/
//
This inteprets to the following keystrokes:
':' colon
's' s for substitute
'
' Ctrl-v-m to create the annoying ^M as
On Tue, 13 Feb 2001, Irmund Thum wrote:
Rolf Hopkins schrieb:
"^M"???
The ^M is the carriage return/line feed usually found in ms/dos text
files.
On my Linux system (on downloaded files) I removed them by
tr -d \r old file new file.
tr = text replace; -d delete; \r = ^M
see 'info tr'
Michael, it would be very nice if you would mark security related bugs
so that admins who are not subscribed on Bugtraq see them, too.
This is at least the second time where I got information about security
bugs in MySQL *only* via 3rd party and not from the web page nor from the
changelog.
Or a handy one-liner...
perl -pi -e "s/[\012\015]//" *.sql
Or alternatively edit the file with vi and do:
:s///
This inteprets to the following keystrokes:
':' colon
's' s for substitute
''Ctrl-v-m to create the annoying ^M as one character
'//' two slashes
On Tue, Feb 13, 2001 at 11:45:55AM +0700, Andrea wrote:
Hi all
I am interesting on password routine in mysql
Could some body help about this routine ?
I download the source code of MySql, but i am not yet found about this
routine
Are you looking for the following code from
Try this,
The code below will remove the last character from
each record in your file. On your Linux system
enter this line on the command line and the
results will appear in the NEW_FILE. Obviously you
can name the input and output files anything you
want.
awk '{print substr($0, 1, length-1)}'
John
Here is another solution to removing those '^M'
chars. This is a lot simpler
than my last idea :-
sed 's/^M//g' YOUR_FILE YOUR_NEW_FILE
Michael Thomas
www.abcXyz.com
-
Before posting, please check:
Hi!
I'd like very much to be able to walk backwards through a list of my
records. How might I indicate that mysql ought to position itself at the
highest record number and then all selects will go backwards (say with LIMIT
1) ?
Thanks for your time!
Cheers!
-Warren
I set up two MySQL servers to run in a failover configuration. Because
queries will only ever be submitted to one server at a time, I decided to
use a makeshift two-way replication scheme under MySQL as descibed in
the MySQL manual.
First server (wallace) has this:
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote:
I couldn't fine this mentioned in the archives, so I hope someone has seen
this before:
I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
There is still server process (sleeping), and there is still a
To add to this, I'm running 3.23.32 (on Solaris). I really like
the concept of merge tables, but without the ability to insert
new records in underlying tables, it's far less useful for my
needs.
Thanks.
Fred.
On Tue, Feb 13, 2001 at 12:44:25AM +0100, Fred van Engen wrote:
Hi,
Is it okay
mv file file~ ; tr -d '\015' file~ file ; rm file~
Or, in vim, :set fileformat=unix
Or, use PFE32.EXE on Windows as your editor (allows saving
as Unix text file).
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
-Original Message-
From: "Jon Haworth" [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 5:40 PM
Oh no, not another one
Mike and James - you fell for the good ol' trick.
Bu hu for you - don't you just "love" it? :-)
Now whoever made the little bastard this time...?
Funny thing actually: My Outlook Express
Thanks everybody for helping me out... I got the scripts loaded and am
talking to mySQL via DBI now.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
G. Adam Stanislav
Sent: Tuesday, February 13, 2001 6:36 AM
To: John W Ford; Mysql
Subject: Re:
How do you define backwards? By what sort order?
Cal
http://www.calevans.com
-Original Message-
From: Warren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 1:28 PM
To: [EMAIL PROTECTED]
Subject: changing the direction of searches via Select
Hi!
I'd like very much to be
Warren schrieb:
Hi! I just posted the following silly (in retrospect) question
$next=MYSQL_QUERY("select ref from questions where ref $ref[0] ORDER BY
ref DESC LIMIT 1");
no reason to apologize - sometimes the best postings :-
--
http://it97.dyn.dhs.org/
IrmundThum
+49 179 6998564
On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote:
I've seen it after installing two versions of MySQL on one server.
I forgot to set another location for the second MySQL process
before starting it with /bin/safe_mysqld. The result was that the
socket was removed by the second
I know I'm using a really old version of mysql (3.22.4a-beta)
but upgrading means changing my application, and I'd rather
avoid that right now.
I'm trying to get it to build on RedHat 7.0
I have updated gcc to 2.96-69
When compiling sql/sql_yacc.cc
The compiler appears to hang in pass 1.
Isn't it possible the virus itself was actually removed by the mailserver
antivirus software? Can anybody confirm this just for we could feel more
safe? My Outlook 2000 shows the message and the attachment, but the
attachment is a text file with mailing list footer information - just like
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello all,
I am new to the list and need assistance. I noticed this thread in the
archives, but I didn't see an answer. So, I'll ask it again.
I have tried several times to use BerkeleyDB with MySQL to provide
transaction support. It has failed
I _used_ to be able to log to a FIFO as recently as mysql-3.22.32,
but now with mysql-3.23.33, I can't:
010213 17:03:11 Could not use /var/mysql/db/localhost.fifo for
logging (error 29)
where in /usr/include/sys/errno.h:
#define ESPIPE 29 /* Illegal seek */
I'm
Description:
Corrupted tables cause REPLACE to complain about Duplicate entries.
Or maybe REPLACE gets confused and causes table corruption.
It doesn't happen all of the time which is the frustrating part of this.
How-To-Repeat:
DBD::mysql::db do failed: Duplicate entry
I'm wondering if MySQL supports transaction?
Since I have an application to use MySQL JDBC to perform several insert
statements and then do a rollback, all data saved to the database without
rolling back.
-Eric
-
Before
Hi there,
please check the oracle migration bench at the oracle technet.
http://technet.oracle.com
kind regards
denis mettler
-Urspr?ngliche Nachricht-
Von: Noor Dawod [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 13. Februar 2001 17:23
An: Cal Evans; MySQL List
Betreff: RE:
Search for the information on grant tables on mysql.com.
.. Atle
On Mon, 12 Feb 2001, Mike Yuen wrote:
I and 2 others are working on a web site an occasionally. Each of us are
in different locations and exchange info email. Some of them
need to query the database to compare results with
I had forgotton how much in love with it I once was, until Outlook
refused to behave as the help files said it would, and the help files
describe capabilities that were simply not available. I have moved to
Outlook, because I needed to access several email accounts, and the
older versions of
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Transactions
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#BDB
-tcl.
On Tue, 13 Feb 2001, Eric Kwong wrote:
I'm wondering if MySQL supports transaction?
Since I have an
On Tue, 13 Feb 2001, Crystal D. Silver wrote:
in the documentation about how to just plain DELETE everything in the
database (i don't want to delete the installed database itself, just go back
down to where there's nothing in it, so I can start over)...could somebody
tell me what to do?
I would like to see some 'bash-like' abilities for an alias command and a
.mysql file or something similar to store commonly used queries (to be
accessed by a single keyword). I find myself writing extremely long
queries from time to time and I have to store them in a text file and
worry about
Hi,
I've got a question about the use of indexes.
I've a site running quite good. I've such features
like polls and all that usual stuff.
I take the poll tables as example.
POLLS:
idpoll bigint unsigned not null auto_increment primary key,
drop table...
On Tue, 13 Feb 2001, Crystal D. Silver wrote:
Date: Tue, 13 Feb 2001 14:01:48 -0800
From: Crystal D. Silver [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help please?
Hi,
My host gives me a MySQL database, and I've had no trouble getting purchased
cgi scripts to
Apparently I jumped the gun today when I posted my last message about
compiling on Solaris. I had inadvertantly extracted and compiled an older
version of MySQL.
Tonight I compiled the latest version, 3.23.33, and it does indeed fix all the
shortcomings of the previous compiles with Solaris.
Won't a "Drop TABLE" work?
Brady...
Original Message Follows
From: "Crystal D. Silver" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help please?
Date: Tue, 13 Feb 2001 14:01:48 -0800
Hi,
My host gives me a MySQL database, and I've had no trouble
Hi,
Attached is a bug and a question.
Regards,
Jonathan
user id: jberall4691
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
SELECT t.trans_id, t.trans_no,
Hi,
I'm trying to install the lastest version of mysql 3.23.33 rpm
(downloaded from mysql.com) on RH7 using the command "rpm -Uvh MySQL*"
but encountered "failed dependencies error" as shown below:
error: failed dependencies:
MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.33-1
mysql =
I had the same problem just yesterday.
- MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.33-1
benchmark uses Perls DBI modules, so U have to install them before installing
MySQL-bench.
Unless U R going to perform benchmarking U need not install MySQL-bench modules.
- mysql = 3.23.22 is
Hi sara,
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
I can able to understand that you want to use mysql database using Jsp.
regards,
S.Chitra
On Wed, Feb 14, 2001 at 09:03:16AM +0800, Rolf Hopkins wrote:
Do you have a cron job that's cleaning up your socket file along with
whatever other garbage it's cleaning up?
Nope. As I said in my original mail:
I don't have a cronjob, or any other external process that scrubs /tmp.
I'm
I don't understand will someone please look at this code and see what is
wrong.
?php
$dbglobal = mysql_connect('localhost', 'mylog', 'mypass');
mysql_select_db('test', $dbglobal);
$query ="SELECT * FROM emails Where id 100";
$result = mysql_query($query);
while(list($ID, $EMAIL) =
While downloading phpMyAdmin you can choose whether to use .php or .php3
extensions ...
And if you don't want to then Just add .php3 to AddType in apache or through
.htaccesss
Cheers,
Maxim Maletsky
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
Hi
I post once more this message, because I didn't receive any answer.
- Message d'origine -
De : Philippe MORIN
: [EMAIL PROTECTED]
Envoy : vendredi 9 fvrier 2001 09:49
Objet : Concurrent insert/select with BDB
Hi
I'm using MySQL 3.23.32 on Linux.
I try to run concurrent
Hello,
I am creating a script which works offline from the mainstream of our system
and updates our databases.
These scripts includes INSERTING, UPDATING and DELETING records.
I am performing a updating operation using Python which takes really some time.
Something like,
update TABLE1 set
Greets All:
Deja just got purchased by google today, and, usenet search is gone. No answers
out there, anymore folks. :(
I have my firewall redirected from the router to a FreeBSD box that can't do
sshd for a few days because of recent exploits. It won't build. Period. Spent
5 hours on it.
I am running mySQL 3.23.32 with ColdFusion 4.5 on a RedHat Linux 6.2
machine. MySQL continuously crashes. I've been told that it could be that
the ODBC driver is not up to date. Where can I get these drivers... or do
you have any suggestions as to what I should do?
Please help.
I don't have internet access at home, also the mysqlbug script could not send
the mail automaticaly, but have edited the output and included it as
attachement.
and once again:
there is a problem with 'select distinct' in some case (distinct+join+order by)
the problem is to see in attached file
[EMAIL PROTECTED] schrieb:
does the current version of 'phpMyAdmin 2.1.0 work with PHP 4.0.4?
i downloaded 'phpMyAdmin 2.1.0 with php3 extensions' (from the php
site) and my browser won't even open the file 'index.php3' as a file.
and when i try to go to
88 matches
Mail list logo