soft Jet engine - a small, relatively restricted database
engine.
At some time Microsoft's intention was to replace the Jet engine with MSDE
(SQL Server Desktop Edition) but I don't know if there's been any progress
on that front.
Cheers,
Iikka
=========
ual.php (the manual)
>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
>
==
working installation.
Iikka
Sh*t.. 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/m
ation on MSSQL that format
the data 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+r4ZncRAu13AKCSK2DnfzQQq7T
not other SQL 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
gt; >
> Default is 3306
And with -P=123 or --port=123 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-
V
ibe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Iikka Meriläinen
Vaala, Finland
E-mail: [EMAIL PROTECTED]
-
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/unsubs
this for platform notes: 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]
--
ts via BK.
====
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
n.
> I want to know what is the problem.
>
>
******
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Befor
on server?
http://www.mysql.com/doc/en/Server_parameters.html might help you.
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala
To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
**
* Iikka Meriläinen
th the
--defaults-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, F
++
> > 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 *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
verhead.
If you require different server 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-mai
Mr. Raymer means that he would get more performance when running
multiple _MySQL_ servers (i.e. 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
imple. Please help.
Hi!
See www.php.net documentation for MySQL functions. The generic document
concerning the MySQL interface contains a sample script that does just this.
Regards,
Iikka
******
* Iikka Meriläinen *
* E-mail: [EMAIL PROTEC
(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/uns
. Also try running
the script in /etc/init.d/rc3.d (the symbolic link in this case) manually
after the system startup.
Regards,
Iikka
******
* Iikka Meriläinen
expose your password but it won't help a cracker as he
doesn't have your certificate.
I haven't used this personally, and the documentation is pretty thin on this
subject, unfortunately.
Best regard
manual is excellent 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 *
*
Found invalid password for user:
>
> I guess that I need to change 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
***
ing password: NO)'
Hi,
mysqladmin -u root -p shutdown
And then enter your root password.
Regards,
Iikka
**
* Iikka Meriläinen
something like
GRANT all 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
olving. That is certainly
DNS functionality.
You talked about SERVER... it can be understood in many different ways.
But it seems to me that this issue is resolved and over.
Best regards,
Iikka
> - Original Message -
> From: "Iikka Meriläinen" <[EMAIL PROTECTED]>
&
rce
> Distribution or Red Hat distribution.
> I hope you understand exactly what i try to say.Unfortunately (for me),my
> english is not so good .
Yep, I saw it. :-) But got your point anyway though.
Best regards,
Iikka
> - Original Message -
> From: "Iikka Mer
seems to be a *NIX, so
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 Mer
= 1
> >
> > Could it be something to do with the startup/stop script because I
> > noticed something else odd. The script works for starting the daemon:
> >
> > [root@chimp etc]# /sbin/service mysqld start
> > Starting MySQL:[ OK ]
>
Hi!
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 *
* E-mail:
mysqldump process?
Regards,
Iikka
**********
* 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
> >
>
>
> ____
rs. It also 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 Meri
tures for examples.. ;-) Quite impressive numbers, 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
etc.
> > and i can do query like "select 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
***
tables, but
you would have to update it manually. Or you could have an external program
scanning your data directories for added/removed table files.
Regards,
Iikka
**
* Iikka Meriläinen
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (
le files must be owned by those restricted users.
I hope this quota feature will be added into MySQL in the future.
Best regards,
Iikka
**
* Iikka Meriläinen
n anyone suggest what I should do?
Hi,
Run mysqld-max-nt --install
first in order to install your new MySQL as a service. Then it should work,
at least you should be able to start the service by entering 'net start
mysql'.
Best regards,
Iikka
***
nf.
Best regards,
Iikka
******
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
-
Before posting, please check:
http://www.mys
OTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
if using 3.xx).
Regards,
Iikka
ps. The manual has a section on those can't-connect things (at least I think
I've seen this somewhere before).
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
*
thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
**
>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, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.c
ading the manual on full disk
conditions, I got the picture 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
**
test1;"
>
> Can anyone help?
Sure! You have 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
>
&g
;
>
> What do I do from here ???
>
> Thanks, DeNewbie
>
> -
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
>http://lists.m
;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, e-mail
> > <[EMAIL PROTECTED]>
>
w.mysql.com/manual.php (the manual)
>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/uns
they're
> not used during the operation of the db...? I don't know about that.
>
> --Pete
>
**
* Iikka Meriläinen
ne of u guys cud come
> >online on
> > > msn n hlp me plz .
> > >
> > >
> > > all screwedup .
> > >
> > > toby
> > >
> > >
> > > _____
> > > MSN Photos is the easiest
online on
> msn n 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
>
***
___
> 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 *
**
se check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> >
tp://www.mysql.com/manual.php (the manual)
>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
>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
>
***
dify
> what is already installed?
>
> Regards
>
> Peter Goggin
>
>
> ----- Original Message -
> From: "Iikka Meriläinen" <[EMAIL PROTECTED]>
> To: "Peter Goggin" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: We
is thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
VE given them all the rights i possibbly cud ... editting the grants and
> even revoking them ... but nothing seem to b workin
>
> n im lost at sea
> :'(
>
> n no clue vat to do ...
>
> i feel like takin the whole thing out n reinstallin it ... :S
&g
ount) 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 *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
*
gt; >>To unsubscribe, e-mail
> >><[EMAIL PROTECTED]>
> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >>
> >>
>
>
>
>
> _________
> MSN Photos is
. I don't
mean that MyISAM is bad, not at all. It's 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
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
**
* Iikka Meriläine
/ (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
>
***
tp://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
>
*
o request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
**
* Iikka Mer
this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
*
thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
sts.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this threa
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
|
> | Tel: +27 11 372-9800 Fax: +27 11 372-9801 |
> ||
>
>
>
> -
&
-
> 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, e-mail
><[EMAIL PROTECTED]>
>
a
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 Pel
st 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
> 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 *
e 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, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql
t;
> 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 *
* E-m
>
Hi,
Start by looking at the MySQL documentation:
http://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
**
* Ii
; Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
---
ed coverage. 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] *
* Vaa
gt; To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
*
want
to learn enough pure SQL to accomplish those tasks more effectively.
A URL for graphical 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.
last 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] *
* Vaal
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
ith --skip-grant-tables,
change your root password to something you can use later.
Regards,
Iikka
******
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
d
probably there are lots 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 PROT
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
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
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
ut backups? ;-)
Regards,
Iikka
******
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**
On Sun, 11 Aug 2002, Dave Reinhardt wrote:
> I seem to have lo
vironments, but it's not always affordable.
Regards,
Iikka
******
* Iikka Meriläinen *
* IT Support *
* Vaalan kunta *
* -- *
* E-ma
n't be specified runtime. 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
92 matches
Mail list logo
