Dear all
As i had granted permission to user, now i want to remove particular
permission off from the user, could you pls tell me how to do so???
And what should i do if i want to remove a user? is mysql got something like
"User Group"
Thx
Jack
-
Hello the list,
I try to create a table with a TEXT primary key, and this error message
appear :
ERROR 1170 : BLOB column 'MY_COLUMN' used in key specification without a key
length.
What is the syntax to settle a key length ?
Here is my sql code to create my table:
-- =
>Hi Everyone.
>
>Quick question. When you do a search on a MySQL FULLTEXT index using MATCH
>you
>get a value returned of the relevance of the result. Is there a maximum
>value that can be returned so that I can convert these numbers into
>precentages???
>
>Thank you very much.
>
>
>Best regards
Dear all
I have a problem when I specified my host in order to connect to my
mysql server :
mysql -h p204
ERROR 2013: Lost connection to MySQL server during query
I have just installed the server and set a pass for the root user.
In hope of your help
Guillaume
-
Dear all
I had a table which with Auto_increment, which means when i insert a record
there will be a number insert to lead as the location of the record.
here is my question.
I was try to get the most last five records , but i don't know which query
should i use?
Thx
Jack
--
Hi!
On Nov 26, Andrew Dixon - MSOnet wrote:
>
> Hi Everyone.
>
> Quick question. When you do a search on a MySQL FULLTEXT index using MATCH
> you
> get a value returned of the relevance of the result. Is there a maximum
> value that can be returned so that I can convert these numbers into
> pr
Hi!
At 05:19 PM 11/25/01 -0500, you wrote:
>I think your diagnosis is correct. There is an FRM without a corresponding
>InnoDB table. The question is, what causes this, and how do we prevent it?
Brent thinks the problem was a third-party software which crashed the server.
>It appears to be a
The best way is to get the records ordered inverselly by the auto-increment
field and then restrict the return to 5 records.
Cheers,
Luis Ferro
WebDev
-Original Message-
From: Jack [mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 26 de Novembro de 2001 10:02
To: Mysql List
Subject: Gettin
AS SEEN ON NATIONAL TV: Making money from your home for an
investment of only $25 U.S. Dollars expense one time ALL YOU
NEED IS A COMPUTER AND THE INTERNET!
This is the letter you have been hearing about on the news
lately. Due to the popularity of this letter on the
Internet, a national wee
Hi!
First: please reply to the list, and not directly to me.
Then:
On Nov 26, Andrew Dixon - MSOnet wrote:
> So I take it there is no maximum value then??? Making it impossible to
> change the returned relevance value into a understandable percentage value.
> How is the relevance calculated t
Hello Heikki,
Wednesday, November 21, 2001, 8:34:13 PM, you wrote:
I see some more users are interested in optimize table to work.
Why don't you just map OPTIMIZE TABLE to ALTER TABLE for INNODB tables
so user may not care about table type, there currently one should
check the table type and use
Hi guys,
is there a method in mysql to do a search engines like query and order the
results
by relevance?
i taken a look at MATCH ... AGAINST function but i'm not sure that it's what
i need and i'm also looking for somenthing simpler and faster...
any idea?
thanks in advance
---
just to make it clearer:
select * from your_table order by auto_increment_column desc limit 5
cheers :)
- Original Message -
From: "Luis Ferro" <[EMAIL PROTECTED]>
To: "'Jack'" <[EMAIL PROTECTED]>; "'Mysql List'" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 6:30 PM
Subject: RE: Get
For measuring relevance, you'll need to come up with our own weights and
algorithms. MySQL doesn't do that kinds of things. For more information,
read the documentation of Google at:
http://citeseer.nj.nec.com/brin98anatomy.html
or http://www7.scu.edu.au/programme/fullpapers/1921/com1921.htm
C
I have an application with many table joins and now I would like to get all
different Skills that every person in my resultset has concatenated to one
string.
I would like the code to work like this.
select concat_ws(", ",SkillName) as Skills, ..., ... from Skill, ..., ...
where ... and ... grou
Hi!
InnoDB is a table type which provides row level locking, transactions, and
foreign key constraints to MySQL. It is included in the MySQL -Max
distributions in the 3.23 series, and to all distributions of MySQL-4.0.
InnoDB release in MySQL-3.23.45 is a bugfix release.
* In versions 3.23.42-.
Hi,
I'd like to ask for a reply to this (I hope not stupid) question:
is there a way to set permanently relationship between tables,
so in that way when I ask for something, Mysql automatically
joins all tables involved in that relationship?
(Like MSAccess, for example)
-
If you want to use your table more than once you have to declare that.
select ... from T1 as FirstT1, T2 as SecondT1 where
FirstT1.column...=SecondT1.column...;
Eva Fransson
-
Before posting, please check:
http://www.mysql
Does it throw an error message or output isn't what you expected?
In any event, did you try it with "HAVING"?
I couldn't notice anything wrong from what you have there
Cheers
--
sherzodR
On Mon, 26 Nov 2001, Eva Fransson wrote:
>I have an application with many table joins and now I would
Well, you could do that with shell scripts (or batch files ).
Just write a query pleasing your heart's content, and save it in script
and ( or put it into your /bin ) run it whenever you need it.
As far as I know, MySQL doesnt' have such built-in feature ( I wish I was
wrong)
cheers
--
sherz
Use "%" instead of "*"
cheers
--
sherzodR
On 26 Nov 2001, Harald Fuchs wrote:
>According to the manual, section "New Features of Full-text Search to
>Appear in MySQL 4.0":
>
>* `*' is a truncation operator.
>
>The query
> SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versailles'
Hi,
Using MySQL 3.23.43 on Red Hat Linux 6.2, is there a way to tell MySQL to
use a different "tmp" location? I am having problems indexing a large table
as mysql bombs out with an out of disk space error int the /tmp directory
(which actually has about 500 megs free space). I know there is a c
Hi,
There is an faq on using symbolic links to move databases at
http://www.mysql.com/doc/S/y/Symbolic_links.html which covers the details.
The gotcha that I fell into was that the mysql user (usually "mysql") needs
to have rights to the directories that you move the data to. So if you put
a dat
Hi Edward,
I downloaded the latest (3.23.43) binaries for in rpm format from
http://www.mysql.com and they installed fine.
Kind Regards,
Martyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Martyn Wendon" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 1:06 AM
Subject: Re: Sym
On Mon, 26 Nov 2001, Jack wrote:
> Dear all
> I had a table which with Auto_increment, which means when i insert a record
> there will be a number insert to lead as the location of the record.
> here is my question.
> I was try to get the most last five records , but i don't know which query
> sh
i don't know if this works, but here it goes
export TMPDIR=/what/dir/you/want/mysql/to/use && /etc/init.d/mysql start
something like that
or edit the init script
see http://www.mysql.com/doc/E/n/Environment_variables.html
On Mon, 2001-11-26 at 12:06, Martyn Wendon wrote:
> Hi,
>
> Using MySQ
Thank you for your report.
We shall check it out.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysq
Hi,
Thanks for that, I actually managed to work it out for myself. You can
create a file "my.cnf" in either /etc or in the root of the mysql data
directory that can contain many options. By specifying
"tmpdir=/home/mysql/tmpdata" I was able to make mysqld use that location for
temporary files i
Hello,
I'm trying to build MySQL from source.
I've noticed in whether MySQL 3.23.43 or 4.0,
for sql/lex.cc and lex.h --
The source for flex to generate these two files is missing!!
Although the yacc file (sql_yacc.yy) still exists,
I need the lex source because I want to change some
Quentin Bennett writes:
> So, if you pass NULL in as the first parameter to mysql_real_connect, a
> possibility opened up by the manual, what is the return. If it is "a MYSQL*
> connection handle if the connection was successful", where did the space for
> that handle come from.
>
> I agree with
>ERROR 1170 : BLOB column 'MY COLUMN' used in key specification without a key
>length. What is the syntax to settle a key length ?
ALTER TABLE your_table add key blob_field (blob_field(50));
Or, you can create a table like this one:
CREATE TABLE `your_table` (
`id` int(10) unsigned NOT NU
Hi !
I have a table with 2 coluns with time values , for example, colum START
("2001-11-20 23:34:03" , for example) and STOP ("2001-11-21 08:34:03" , for
example).
Given a interval of time, say 8 AM to 8 PM, i need my query to return the
total time between START and STOP outside this period.
Is t
Francis S.Lin writes:
> Hello,
>
> I'm trying to build MySQL from source.
> I've noticed in whether MySQL 3.23.43 or 4.0,
> for sql/lex.cc and lex.h --
> The source for flex to generate these two files is missing!!
> Although the yacc file (sql_yacc.yy) still exists,
> I need the lex
No concatenation is being done in my example. that is what is wrong. the
result I get is only one of the SkillName values. I would like all possible
SkillNames to be listed in Skills on the same row in the resultset, grouped
by fkEmployeeID.
I have tried out having and I can not see any need to u
Check out DATE_SUB() and DATE_ADD() functions. Those are the one to do
the trick.
sherzodR
On Mon, 26 Nov 2001, Julio Faerman wrote:
>Hi !
>I have a table with 2 coluns with time values , for example, colum START
>("2001-11-20 23:34:03" , for example) and STOP ("2001-11-21 08:34:03" , for
>e
At 04:01 PM 11/26/2001 +0800, yilmaz wrote:
>hi all,
>first of all, since this is a jdbc specific question, you might say i should
>post to java mysql
>mailing list, but for some reasons my java mysql subscribtion seems didn't
>succeed although
>i got a confirmation and a welcome email. (of course
Hi!
On Nov 26, sherzodR wrote:
>
>
> Use "%" instead of "*"
>
> cheers
> --
> sherzodR
>
>
> On 26 Nov 2001, Harald Fuchs wrote:
>
> >According to the manual, section "New Features of Full-text Search to
> >Appear in MySQL 4.0":
> >
> >* `*' is a truncation operator.
> >
> >The query
> > S
I already checked java api docs, but it doesn't provide any information nor
any help.
Since usually error messages and docs doesn't give a user friendly and
helpful
info, i hope somebody who already faced the same problem could give me some
hints about what
could be the reason.
thanks for taking
> Second - probably it's a bug. I cannot say much as the code used by this
> query was removed from MySQL source tree. It was replaced by completely
> new boolean search engine written from scratch. Unfortunately it was
> done several days _after_ 4.0.0 release.
>
> Wait for 4.0.1 - it should be o
--- Michael Collins <[EMAIL PROTECTED]> wrote:
> 1) Will there be a binary for MySQL 3.23.45 for MacOS X 10.0.x
> (Darwin 1.3.x)?
Isn't there one there? On the "Downloads" section of the site? I just
wish my local mirror was updated to include it
> 2) How do I find out what options are c
Hi!
On Nov 26, Gordan Bobic wrote:
> > Second - probably it's a bug. I cannot say much as the code used by this
> > query was removed from MySQL source tree. It was replaced by completely
> > new boolean search engine written from scratch. Unfortunately it was
> > done several days _after_ 4.0.0
I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out how
to get the query I
need against the version without the union
Seems I need a sub select but that's not supported yet. I'm trying to get a score of a
search result - the first
query works as required (but pot
Hi.
Suppose I have dumped all database tables using mysqldump with --tab=... option and
I've got some *.sql and *.txt files one per table.
Ok, through the some time I want to see how changed a table living in server compared
with it's old copy I have dumped early.
I've decided to use some of th
database,sql,query,table
Hi guys,
Can any one told me - with my great appreciate - how to load a
data
from txt file into a specific column?
Thanks.
Hytham Shehab
_
This message was sent using Menanet MenaMail.
http://www.menanet.net
http://www.mysql.com/doc/L/O/LOAD_DATA.html
Elm
> database,sql,query,table
>
> Hi guys,
>Can any one told me - with my great appreciate - how to load a
> data
> from txt file into a specific column?
>
> Thanks.
>
> Hytham Shehab
>
>
>
>
>
> _
Hello!
Can anybody, please, hook me up with a working mysqlhotcopy.pl script
for mysql 3.23.44 (win)? Shame is I don't know Perl much... Maybe
somebody could give some hints on what to change in original script to
make it working...
Thanks a lot!
---
Oracle is certainly more full-featured, but if you know very little about
databases, Oracle is not the right choice. Only use Oracle if you have a
full-time fix-figure-salary Oracle expert AND you actually need Oracle's
features.
If you don't specifically know you need Oracle, you don't.
On W
Oh you're actually from MySQL -- I didn't notice that.
That'll be very cool when you get that finished. Also, having a datatype
specifically for credit card numbers would be cool. :)
On Thursday 22 November 2001 09:52 pm, Michael Widenius wrote:
> Hi!
>
> > "Ken" == Ken Kinder <[EMAIL PROTE
Is there anything like a "to_hours()" function ?
I need my query to to calculate how much time there is between two time
values
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
On Sat, 24 Nov 2001, Sinisa Milivojevic wrote:
> I think that our documentation is quite clear on that issue. . . .
Not quite:
"For a successful connection, the return value is the same as the value
of the first parameter, unless you pass NULL for that parameter." (Manual)
That is, if you pass
Hello all,
Can anyone tell me the "official" name of the MySQL 3.23.45 source code
file that is downloaded from the web site (www.mysql.com)?
I normally grab it with curl off of my local mirror but they didn't have
it yet so I used Internet Explorer to grab the file from another
(random) mirr
On Mon, 26 Nov 2001, Sinisa Milivojevic wrote:
> Quentin Bennett writes:
> > So, if you pass NULL in as the first parameter to mysql_real_connect, a
> > possibility opened up by the manual . . .
>
> There is no indication in our documentation that NULL should be passed
> as a first parameter in my
Try here:
ftp://mysql.valueclick.com/pub/mysql/Downloads/MySQL-3.23/mysql-3.23.45.tar.gz
I always find this FTP site with the most up-to-date files and is very reliable!
:)
>>On Mon, 26 Nov 2001 10:17:22 -0500, Erik Price <[EMAIL PROTECTED]> wrote:
>>
>>Can anyone tell me the "official" nam
This kind of voting is reductive as i for instance would answer both. They
both have its uses, and wise is the one that can recognize when to use one
or the other...
Cheers,
Luis Ferro
WebDev
-Original Message-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent: segunda-feira, 26 de Novemb
At 6:22 AM -0800 11/26/01, Erik Price wrote:
> > 1) Will there be a binary for MySQL 3.23.45 for MacOS X 10.0.x
>> (Darwin 1.3.x)?
>
>Isn't there one there? On the "Downloads" section of the site? I just
>wish my local mirror was updated to include it
No, it is not found on "Downloads for
Thanks! I'll change the name from "download.php" to
"mysql-3.23.45.tar.gz" in my source directory, and I'll remember the
valuclick mirror. I'm assuming that's in N. America somewhere.
Erik
On Monday, November 26, 2001, at 11:29 AM, Mike(mickalo)Blezien wrote:
> Try here:
> ftp://mysql.val
I'm a relative newbie to MySQL (most of my experience is with Oracle) and am
currently trying to set things up to use the Berkeley tables with
transaction processing.
I downloaded the mysql-3.23.44.tar.gz source and installed it on Linux Red
Hat 6.2. I configured it with the --with-berkeley-db op
On Monday, November 26, 2001, at 11:34 AM, Michael Collins wrote:
>
> No, it is not found on "Downloads for the 3.23 version" at:
>
> http://www.mysql.com/downloads/mysql-3.23.html
>
> Look for:
>
> MacOS X downloads
> Binary packages (tar.gz)
> MySQL 3.23.45 MacOS X Server 1.x (PowerPC) (4.7M)
Hallo,
I' am a newbee about replication and i can not find any information about
two-ways replication. Can you help me???
An application shall a two-ways replication substitute. I have found in the
MySQL Reference Manual a documentation about one-way replication and a
question in the FAQ Block (
I have an app that uses about 6-7 databases. But the MySQL server is now
restarting a lot. I was having a problem with this before - I had about 267
restarts in a matter of a month or two. I shut down the server, ran
myisamchk on the databases and it found a lot of open connections, and I
guess cl
From: Jonathan Hilgeman <[EMAIL PROTECTED]>
> ...MySQL server is now restarting a lot.
> mysqld got signal 11;
> ...any ideas?
I had something similar, very frustrating. I was advised by an acquaintance at MySQL
to upgrade to 3.23.42. I did and I haven't had the restarting problem since. I don'
Hi All,
I need to setup MyODBC DSN's for MySQL access.
Does anyone know how to build a simple installer that will create
User/System DSN's from a file? ie. like the odbc.inf file included with the
MyODBC installer?
Can odbcconf.exe be used to install a DSN? If so, what are the parameters
used
Sergei Golubchik wrote:
> Hi!
>>
>
> I didn't test it yet.
>
> The one thing I can say just now that unlike natural language search
> code (as exists in MySQL in 3.23) it need not to build the complete list
> of matched documents in memory in advance. It means that with LIMIT it
> should be
Tony Bailey writes:
> I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out
>how to get the query I
> need against the version without the union
>
[skip]
> 2)
> select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection,
>docs.docsubdir, docs.docm
Okay, unregard my question. I figured out what I was doing wrong.
It's too embarrassing to tell you guys.
Thanks,
--Walt
-Original Message-
From: Weaver, Walt
Sent: Monday, November 26, 2001 9:52 AM
To: [EMAIL PROTECTED]
Subject: Using Berkeley tables -- how to set up?
I'm a relative
On Mon, 26 Nov 2001, Julio Faerman wrote:
> Is there anything like a "to_hours()" function ?
> I need my query to to calculate how much time there is between two time
> values
Julio,
have a look at the UNIX_TIMESTAMP(date) and FROM_UNIXTIME(unix_timestamp)
functions. These allow to conver
Displaying timestamp columns are a PIK (pain in keester) if you ask me.
A Select statement will display the TmeStamp as 2005095105. Now I ask
you, how many users will understand this format?
Why not display TimeStamp in the same format as DateTime? At least then the
TimeStamp is in a meanin
M. A. Alves writes:
> On Sat, 24 Nov 2001, Sinisa Milivojevic wrote:
> Not quite:
>
> "For a successful connection, the return value is the same as the value
> of the first parameter, unless you pass NULL for that parameter." (Manual)
>
>
> Cheers,
>
> --
>,
> M A R I O data miner, LIA
Where can I find a copy of the latest MySQL 3.23 manual? All I've been able
to find is the newer 4.x.
A. Clausen [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
This is my second time posting this question to the mailing list. I
received no responses the first time I posted this.
In the MySQL documentation, it states that the binary log will be replacing
the update log, and it should be used in its place as it can do anything
the update log can. I'm n
Hi Kevin,
> -Original Message-
> From: Kevin Smith [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 9:25 AM
> To: [EMAIL PROTECTED]
> Subject: MyODBC: DSN Creation
>
>
> Hi All,
>
> I need to setup MyODBC DSN's for MySQL access.
>
> Does anyone know how to build a simple insta
Well, to do date calculations, use DATE_SUB() and DATE_ADD() functions.
To convert to some other functions, use DATE_FORMAT() function. For
templates that DATE_FORMAT() needs, please refer to documentation.
There're bunch of'em
--
sherzodR
On Mon, 26 Nov 2001, Thomas Spahni wrote:
>On Mon,
Greetings!
Introducing JudoScript, a full-fledged scripting
language that supports genuine JDBC scripting. Free
form SQL statements can be specified and executed
either individually or in a group or batch.
Expressions can be embedded in the SQL statements.
SQL statements can be prepared and run w
Dear Sir, Madam
I have a problem whit a tabel on a Mysql datbase V3.23 running on a Cobalt
Raq4I.
Some body whas create a tabel named kortbon . Now we have a SQL error on
line1. I cant drop the tabel from a telnet session or mysqlfront or phpadmin.
Question: can i rename the files in /usr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Lun 26 Nov 2001 00:42, escribiste:
> Hola a todos.
>
> Bueno,ya sabemos todos o casi todos que MySQL no tiene integridad
> referencial ni transacciones.Para mantener la integridad
> referencial es necesario hacerlo a mano. Por ahora todo correcto.
help,
I have a problem. I cannot access the mysqladmin fully. I know the only
existing users and the passwd's (without root). I can use mysqladmin while
modifying a table with one of their access'. I know the root to the
(Linux)server, but mysql must have a different one. How can I find out
wh
Now that the shutdown command has been repaired, are there other
outstanding issues specific to Mac OS X that the MySQL AB team has
under development for MySQL 3.x?
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA
But I have a backup, if I just knew how to restore it! The instructions read:
#mysqldump --opt database_name > database_name_File.txt
To restore database:
#cat database_name_File.txt | /path/to/mysql -u username -p database_name
So, if my installation is at /apache/mysql
and the database is /apac
On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote:
> I have an app that uses about 6-7 databases. But the MySQL server is now
> restarting a lot. I was having a problem with this before - I had about 267
> restarts in a matter of a month or two. I shut down the server, ran
> myisamchk o
I have a rhetorical question.
I'm learning as much as I can about MySQL. There is one little detail
that I don't *have* to know the answer to, but I'm curious about. Don't
waste your time replying if you're busy.
It appears that the display width is an option for certain types of
numeric co
Michael Collins writes:
> Now that the shutdown command has been repaired, are there other
> outstanding issues specific to Mac OS X that the MySQL AB team has
> under development for MySQL 3.x?
>
> --
> Michael
> __
> ||| Michael Collins |||
> ||| Kuwago Web Services ||| mailto:[
hi.
/path/to/mysql means the path to the mysql _executable_...
type 'which mysql' to see for sure, but it might be /apache/mysql/bin/mysql.
good luck.
-ravi.
-Original Message-
From: Ben Ocean [mailto:[EMAIL PROTECTED]]
Sent: November 26, 2001 2:38 PM
To: [EMAIL PROTECTED]
Subject: HEL
> then I should be able to issue this command:
> cat lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber
> Why does it tell me that /apache/mysql is a directory (duh) and break the
pipe?
It really means to pipe that file to the mysql command line client, not the
mysql directory. Try
No - it's a FreeBSD binary, I believe. However, I noticed that there were
two perl scripts running that got stuck in infinite loops and were taking up
99% of the CPU. After killing them, it seems to be stable...
On a related note, any Perl gurus know how to force a Perl cron job to stay
below a c
On Monday, November 26, 2001, at 02:38 PM, Ben Ocean wrote:
> But I have a backup, if I just knew how to restore it! The instructions
> read:
> #mysqldump --opt database_name > database_name_File.txt
> To restore database:
> #cat database_name_File.txt | /path/to/mysql -u username -p
> databa
On Mon, 26 Nov 2001, Ken Kinder wrote:
> Oracle is certainly more full-featured, but if you know very little about
> databases, Oracle is not the right choice.
I agree. First of all the system requirements are high. For instance the
Oracle Universal Installer took something like three hours on
I am trying to understand how MySQL uses memory when executing a query on a
large table.
The server is running on RedHat 6.0 with pentium III 750 Mhz processor and 2
Gig of RAM.
I have my key_buffer_size set to 1600MB. My table cache is set at 512.
When I run top, I get the following out put:
Hello,
I know this is offtopic, but the new PostgreSQL book from OReilly is in
production. You can read it online at http://www.postgresql.info/ .
No we are not trying to start a flame war, but there is some really good
info on SQL queries in the book. It may be useful to some MySQL folk.
J
-
At 1:49 PM -0600 11/26/01, john wrote:
>this is not meant to be demeaning, but your not seriousely running a server
>with a Mac are you?
And why not? Are you at all familiar with Mac OS X and/or Darwin? It
is Unix BSD. Seems a fine choice for MySQL.
--
Michael
__
||| Michael Collins |||
Beno,
I cannot believe I am a beginner and the "pro" developer Mr. Sinisa
Milivojevic <[EMAIL PROTECTED]> could not answer your question. I believe you
are reading/issuing the command incorrectly. The "pro" developer Mr. Sinisa
Milivojevic <[EMAIL PROTECTED]> did not read your email properly.
From: Jonathan Hilgeman <[EMAIL PROTECTED]>
> On a related note, any Perl gurus know how to force a Perl cron job to stay
> below a certain CPU utilization?
Not a Perl thing. Do a man on 'nice'.
---
Rodney Broom
Programmer: Desert.Net
Spam filter: sql database
-
On Mon, 26 Nov 2001, john wrote:
> use:
> cat lefeber lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber
I have this strange feeling that the line should read
cat lefeber.txt | /apache/mysql/bin/mysql -u -p lefeber
But let's see who of us are right =)
Sincerely,
Jan
--
Mr. Jan-Aa
Excuse me, but I never intended on adding the world to that question, and
your defensive response tells me you have to fight for trash you are using.
I have utilized the Mac OS X long enough to run far far far away.
Until you can get a grip on criticsm, ease off buddy. Your gonna give
yourself an
my mistake, I copied the line and forgot to remove the first lefeber.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 2:36 PM
To: john
Cc: Ben Ocean; [EMAIL PROTECTED]
Subject: RE: HELP! Hosed Database!
On Mon, 26 Nov 2001, john wrot
On Mon, 26 Nov 2001, john wrote:
> my mistake, I copied the line and forgot to remove the first lefeber.
Mmm no, what I was referring to was that Ben might be confusing
"installation directory" with "mysql binary location". I think we all mean
the latter in this case. Which would then be '/apache
Hi!
On Nov 26, Mike Wexler wrote:
> Sergei Golubchik wrote:
> > Hi!
> >
> > I didn't test it yet.
> >
> > The one thing I can say just now that unlike natural language search
> > code (as exists in MySQL in 3.23) it need not to build the complete list
> > of matched documents in memory in advan
Hi!
Is it not possible to move a mysql column to after another existing
Column by using the CHANGE statement in ALTER TABLE?
I have the following columns:
id
ostron
newCol_2
And I'd like to move the "ostron"-column to after the newCol_2 column.
Is this not the syntax?
ALTER TABLE enu
Hi,
Could anyone help me with where I could find more information about how to
use SSL and let Java connect to MySQL using SSL??
Thanks,
Sebastian
(http://bast-i.dyndns.org)
-
Before posting, please check:
http://www.my
Hi Johnathon,
If you are running on FreeBSD 4.2 or earlier you will have random
problems, espcially 4.1, it had compiler and thread bugs. FreeBSD 4.3
and 4.4 work very nicely and have all known thread problems fixed.
Best of Luck
Ken
- Original Message -
From: "Jonathan Hilgeman" <[EMA
Dear sirs,
I'm running MySQL server on local machine (AMD Duron 650, 128 RAM, Linux
RedHat 7.1, MySQL 3.23.36) and have following problem:
after running SAFE_MYSQLD daemon starts, but ends almost immediately
log is as follows:
011126 16:44:08 mysqld started
011126 16:44:14 /us
1 - 100 of 151 matches
Mail list logo
