Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Dan Nelson

In the last episode (Aug 13), Don said:
> Thanks for the links to the manual.
> I still have a couple more specific questions...
> 
> Should I use a source or binary install?

Whichever you used to install 3.21 would be preferable.  That way they
install in the same place.
 
> Can I simply stop mysqld, then install over the current directory
> tree?

Pretty much.  Make sure you run mysql_fix_privilege_tables after you
start the new server, too, so you can use the extra privs.

-- 
Dan Nelson
[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-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Don

Thanks for the links to the manual.
I still have a couple more specific questions...

Should I use a source or binary install?

Can I simply stop mysqld, then install over the current directory tree?

+-Original Message-
+From: Dan Nelson [mailto:[EMAIL PROTECTED]]
+Sent: Tuesday, August 13, 2002 4:04 PM
+To: Don
+Cc: [EMAIL PROTECTED]
+Subject: Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51
+
+
+In the last episode (Aug 13), Don said:
+> Due to some recent headaches I have decided to come out of the dark
+> ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51.  I was
+> wondering if anyone had any upgrade tips and/or precautions to
+> recommend before I start.
+
+Definitely read the mysql manual wrt upgrading:
+
+http://www.mysql.com/doc/en/Upgrading-from-3.21.html
+http://www.mysql.com/doc/en/Upgrading-from-3.22.html
+
+Lots of new reserved words.  Lots of new features, too :)  Make sure
+you upgrade from ISAM table format to MyISAM or InnoDB (use the
+mysql_convert_table_format script).  
+
+-- 
+   Dan Nelson
+   [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-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Dan Nelson

In the last episode (Aug 13), Don said:
> Due to some recent headaches I have decided to come out of the dark
> ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51.  I was
> wondering if anyone had any upgrade tips and/or precautions to
> recommend before I start.

Definitely read the mysql manual wrt upgrading:

http://www.mysql.com/doc/en/Upgrading-from-3.21.html
http://www.mysql.com/doc/en/Upgrading-from-3.22.html

Lots of new reserved words.  Lots of new features, too :)  Make sure
you upgrade from ISAM table format to MyISAM or InnoDB (use the
mysql_convert_table_format script).  

-- 
Dan Nelson
[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-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Don

Hello,

Due to some recent headaches I have decided to come out of the dark ages and
upgrade from MySQL 3.21.33 to MySQL 3.23.51.  I was wondering if anyone had
any upgrade tips and/or precautions to recommend before I start.

Thanks,

Don
[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-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php