> Would someone help me out with these questions?
>
> I know these may be something obvious/ in the manual .. etc but I
would
> like to have someone showing me if I am on the right track and maybe
share
> some of these in greater detail. Greatly appreciated.
Since the experts are too busy, I'll put in my $0.02 - though I am NOT an
expert
>
> I am new using MySQL. I found out that the default table type used
in
> the binary isn't support transaction and would like to make MySQL uses
> another table type which supports transaction. The following are my
> questions regarding the issue:
>
> 1) which one should I use InnoDB or BDB? what kind of advantages given
by
> each type?
>
> 2) currently, I am using the default type - MyISAM, where I am running
> MySqld-nt. If I would like to switch to another
> table type. Do I just uninstall the service of MySqld-nt from
win2000
> and install MySqld-Max service??
Yes - the Max server support sevral table types at the same time.
> In addition to the daemond, I need to comment out the MyISAM config
>
> 3) what would happen to my existing MyISAM type tables which already
exists
> in MySQL if I do the switch over? and
> would I able to use/create MyISAM type table uder MySqld-Max??
The existing tables remain as they are, and will be handled in the same
way. The default remains MyISAM.
However, you can create new tables using different table types, and alter
your existing tables using the
ALTER TABLE command.
Alec Cawley
---------------------------------------------------------------------
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]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
