-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU
.. SQL QUERY
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)
iD8DBQE+AWq9CVGYZ+r4ZncRAi+cAJ4xixt3NX3C7tVsM9kBfsmZONOiGwCfWurj
UKhCXx7Zs/mfAzANQ8IcfD0=
=MW3d
-END PGP SIGNATURE
implementations.
Thanks, and Best Regards,
Iikka
ps. didn't want to be rude, but these questions are simply out of line here.
:-)
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux
properly and then send them to MySQL via ODBC?
Iikka
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)
iD8DBQE99DkCCVGYZ+r4ZncRAu13AKCSK2DnfzQQq7TSY0lv7BniqVx5WQCeO/L/
uk3w
for mysqld you can specify any server port
you'd like your server to run on.
Regards,
Iikka
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.0 (GNU/Linux)
iD8DBQE97xG8CVGYZ
: http://www.mysql.com/doc/en/Which_OS.html
Linux, Solaris and Windows NT are good and easy choices.
Iikka
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-
Before posting
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
http
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
.
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
.
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check:
http://www.mysql.com/manual.php
?
http://www.mysql.com/doc/en/Server_parameters.html might help you.
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
-file=c:\blah.cnf parameter.
You can configure mysqld to use a log file by adding a line
log
into my.cnf.
Query logging is off by default, indeed.
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
Jack Chen, Stein Lab, Cold Spring Harbor Labs
1 Bungtown Road, Cold Spring Harbor, NY, 11724
Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
**
* Iikka Meriläinen
configuration for different databases, then
you'll have to install two or more separate server instances.
Hope this clears it. :-)
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
. instances) on a same _physical_ server (i.e.
box).
Getting more performance this way is unfortunately a false assumption,
though. More stability, perhaps, but not performance.
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED
(the symbolic link in this case) manually
after the system startup.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
the password somewhere, but I cant
access the mysql databsae,
Thanks in advance.
Start mysqld with --skip-grant-tables and reset your passwords.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
for
further learning, too.
Paul DuBois's book 'MySQL' is also very good.
Also, searching Google with these 'mysql tutorial' will help... :-)
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
, and the documentation is pretty thin on this
subject, unfortunately.
Best regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
ON *.* TO yourusername IDENTIFIED BY 'yourpassword';
This will give your users a broad set of permissions, please have a look at
the docs if you want to restrict those.
Best regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED
And then enter your root password.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
that this issue is resolved and over.
Best regards,
Iikka
- Original Message -
From: Iikka Meriläinen [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 2:11 PM
Subject: Re: RedHat 8 and mysql-server-3.23.52-3
Hi!
On Wed, 23 Oct
good .
Yep, I saw it. :-) But got your point anyway though.
Best regards,
Iikka
- Original Message -
From: Iikka Meriläinen [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 9:25 AM
Subject: Re: RedHat 8
the /etc/hosts of _that_ machine should be updated. Of course, depending on
where the error comes from. In this case it seems to be on the client side -
although the client computer seems to be running Unix.
Iikka
- Original Message -
From: Iikka Meriläinen [EMAIL PROTECTED]
To: Gelu Gogancea
,
nicholas calugar
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before
!
Well, testing that ought not to be too difficult. ;-) Just run a couple of
statements as those users and see what they can accomplish. MySQL states
pretty clearly when you don't have sufficient access to something.
Regards,
Iikka
**
* Iikka Meriläinen
, there.
Anyway, MySQL efficiency is awesome. If you don't really require transaction
support in your application, consider using MyISAM as your table handler.
Best regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED
updates key statistics for
MyISAM tables. CHECK TABLE equals myisamchk -m [table] with MyISAM tables.
All of this can be found on the manual, too. And much more, actually.
Best regards,
Iikka
Oh by the way: SQL
**
* Iikka Meriläinen
/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check
could have an external program
scanning your data directories for added/removed table files.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
tables from catalogName and get all the
tables in the db
'show tables'
But can you do a SELECT on the result set from that statement? Please let me
know if it's possible.
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED
. Then it should work,
at least you should be able to start the service by entering 'net start
mysql'.
Best regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
this quota feature will be added into MySQL in the future.
Best regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL
network IP Port Mapping
What is the simple way to do that ( MacOS X ).
Hi,
Consider using --port=1234 parameter to mysqld.
Also, if Mac OS supports it, you can specify those parameters along with
numerous others in my.cnf.
Best regards,
Iikka
**
* Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check
this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before
).
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check:
http://www.mysql.com/manual.php
that the inserting thread gets stuck, and checks
for free space once in a minute. Does the user running the inserting thread
get a specific error, others thatn a note in the error log?
Best regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL
to create a script file that contains the SQL statements you
are about to run.
./mysqld -u root -ppassword myscript.sql
Edit myscript.sql to contain your SQL code.
Best regards,
Iikka
Thanks.
Peter
On Fri, 27 Sep 2002, [ISO-8859-1] Iikka Meriläinen wrote:
Hi,
use this: mysql -u root
/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting
)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen
hlp me plz .
all screwedup .
toby
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
**
* Iikka Meriläinen
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check:
http
/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL
archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala
)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala
service as a ordinary
user (rather than the SYSTEM account) and grant that user full rights to the
whole data directory structure (make sure the subdirectories and files get
their correct permissions, too).
Regards,
Iikka
**
* Iikka Meriläinen
vat to do ...
i feel like takin the whole thing out n reinstallin it ... :S
vat else can i do
thnx a zillion guyz ...
toby .
From: Iikka Meriläinen [EMAIL PROTECTED]
To: toby - [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: access denied
Date: Wed, 25 Sep 2002 15
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
is already installed?
Regards
Peter Goggin
- Original Message -
From: Iikka Meriläinen [EMAIL PROTECTED]
To: Peter Goggin [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 10:30 PM
Subject: Re: Mysql Error
Hello,
Your Apache is OK, but you've got a PHP
, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check
/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please
simpler to use, after all. But
what I mean is that InnoDB can be used in all tasks MyISAM is suitable
for, and some tasks will be done faster using InnoDB.
Best regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
Hello,
When will the 4.1 source tree be made accessible by the public? How about
the first official 4.1 release? Any estimates?
Best regards,
Iikka
sql query
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check:
http
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
On Thu, 5 Sep 2002, Edward Peloke wrote:
So is there really any benefit to using MySql Max?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Iikka Meriläinen
Sent: Thursday, September 05, 2002 3:53 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject
/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED
automatically flush the cache?
MONTY:
I would like to see the Explain command to say if it is using the cache or
not (CACHE:Yes/No). This would help developers make better use of the cache
if they know how what affects it.
Mike
**
* Iikka Meriläinen
)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check:
http://www.mysql.com
://www.mysql.com/doc/en/Query_Cache.html
Read the entire 6.9 section.
It offers quite a bit of information on how the cache operates, how
you should configure it and so on.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED
MySQL frontends:
http://www.mysql.com/downloads/gui-clients.html
MyCC is pretty OK, but its development is still underway.
Hope this helps, feel free to ask further questions as needed.
Best regards,
Iikka
**
* Iikka Meriläinen *
* E
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
. You
will want RAID_TYPE=STRIPED configuration since that facilitates for the
spreading of the .MYD files.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
lines of it into here and I or somebody else will figure out what's
wrong.
Regards,
Iikka
Btw, this message would be better suited for the win32 list.
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
Hello,
Edit your my.cnf and add the following line in the [mysqld] section:
set-variable = max_connections=500
or set it to anything you need.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
-grant-tables,
change your root password to something you can use later.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
On Mon
Hi,
Try installing it in Safe Mode.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
On Sun, 18 Aug 2002 [EMAIL PROTECTED
of more people active on this list next week,
somebody of them might be able to solve your problem. :-)
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
Hi,
If I understood your message right, the answer is no. The only place
passwords are stored is the mysql database, so they're physically located
in the mysql.MYD file. They're encrypted there, too.
Iikka
**
* Iikka Meriläinen
Hello Alexander,
Yes, it is possible. Start your mysqld(-max)(-nt) instances with
--defaults-file=C:\windows\my.ini option and it should work.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
? ;-)
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
On Sun, 11 Aug 2002, Dave Reinhardt wrote:
I seem to have lost the mysql database
, but it's not always affordable.
Regards,
Iikka
**
* Iikka Meriläinen *
* IT Support *
* Vaalan kunta *
* -- *
* E-mail: [EMAIL PROTECTED
. You
can, however, control the behaviour of the mysqld(-nt).exe by using some
of the command-line startup parameters, if you like.
Hope this helps! :-)
Regards,
Iikka
**
* Iikka Meriläinen *
* IT Support
89 matches
Mail list logo