upgrading mysql

[Ryan Worley]

What process do you guys usually follow when upgrading your version of
MySQL?  I have yet to perform an upgrade, but my first thought would be to
dump the databases, uninstall the old version (remove all the files),
install the new version, and import the dump file.  Is this a good plan, or
is there a better method?


-
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

Re: v4.0 feature list

[Ryan Worley]

>From this feature list, it sounds like you are creating methods
(multi-deletes, updates from joins) that will take the place of
transactions.  Is this the direction that MySQL is heading?  Do you believe
that these methods will be preferred over traditional rollback/commit
transactions with BDB or Gemini?


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 6:21 AM
Subject: RE: nested selects


Cal Evans writes:
 > Sinisa,
 >
 > Is there a published list of features for 4.0?
 >
 > Cal
 > http://www.calevans.com
 >


It is not complete yet.

But, new .frm files, multi deletes and updates from joins, UNION's and
many others.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-



-
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

Transactions

[Ryan Worley]

How exactly does the BEGIN/COMMIT/ROLLBACK transaction process work?  The
examples I have seen are like:

BEGIN;
statement 1;
statement 2;
statement n;
COMMIT;

Does this imply that if any of the statements fail then a ROLLBACK will be
called, otherwise it will COMMIT?


-
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