Upgrading MySQL strategies

2004-06-24 Thread Doug Poland
Hello,
Does someone have a strategy for upgrading MySQL?  For example, I'm 
currently running 5.2.1-RELEASE with mysql-server-4.1.1_2.  The current 
MySQL version is 4.1.2.  If I simply run portupgrade, will the new MySQL 
 binary be OK with the older-style database files?   If I were to 
dump the 4.1.1 files then restore, there may have been changes in the 
schema that could make this problematic.

I've searched the archives and have turned up nothing useful.  One would 
think this would be covered in MySQL's excellent on-line docs, but I 
could find no mention of upgrading.

Thanks for your help.
--
Regards,
Doug
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Upgrading MySQL strategies

2004-06-24 Thread David Fuchs
Doug Poland wrote:
Does someone have a strategy for upgrading MySQL?

I've searched the archives and have turned up nothing useful.  One would 
think this would be covered in MySQL's excellent on-line docs, but I 
could find no mention of upgrading.

Hi Doug,
As a rule, you shouldn't trust that your database will be compatible 
with any version of MySQL besides the one it currently runs under. 
Dumping the database and re-loading it is the best option.  Make sure to 
check the changelog for the new version beforehand, just in case there 
have been important changes (possible inclusion of new reserved words - 
things of that nature).  Sometimes there are specific processes you need 
to follow for upgrading certain versions of MySQL (i.e. you'll need to 
run a contributed script or something) - where applicable, these 
processes are well-documented.

I think a good 'strategy' is the same one you would use for any kind of 
upgrade - one that allows you to test your changes safely and thoroughly 
before implementing them.  Always backup first, of course.  Run both the 
old and new versions of MySQL side-by-side with separate copies of the 
database (you'll need to modify your config appropriately to run two 
copies) and take your time with it to ensure things are running as expected.

Section 2.5 of the MySQL documentation has a lot of good information for 
upgrading.  You can view the HTML copy (with user comments) here:

http://dev.mysql.com/doc/mysql/en/Upgrade.html
--
Thanks,
-David Fuchs BCIS ([EMAIL PROTECTED])
 WWW:  http://www.davidfuchs.ca/
Blog:  http://blog.davidfuchs.ca/
 MSN:  [EMAIL PROTECTED]
 PGP:  http://www.davidfuchs.ca/aboutme/433EEC91.pgp
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Upgrading MySQL strategies

2004-06-24 Thread Doug Poland

David Fuchs said:
 Doug Poland wrote:
 Does someone have a strategy for upgrading MySQL?
  
 I've searched the archives and have turned up nothing useful.  One would
 think this would be covered in MySQL's excellent on-line docs, but I
 could find no mention of upgrading.


 Hi Doug,

 As a rule, you shouldn't trust that your database will be compatible
 with any version of MySQL besides the one it currently runs under.
 Dumping the database and re-loading it is the best option.  Make sure to
 check the changelog for the new version beforehand, just in case there
 have been important changes (possible inclusion of new reserved words -
 things of that nature).  Sometimes there are specific processes you need
 to follow for upgrading certain versions of MySQL (i.e. you'll need to
 run a contributed script or something) - where applicable, these
 processes are well-documented.

 I think a good 'strategy' is the same one you would use for any kind of
 upgrade - one that allows you to test your changes safely and thoroughly
 before implementing them.  Always backup first, of course.  Run both the
 old and new versions of MySQL side-by-side with separate copies of the
 database (you'll need to modify your config appropriately to run two
 copies) and take your time with it to ensure things are running as expected.

 Section 2.5 of the MySQL documentation has a lot of good information for
 upgrading.  You can view the HTML copy (with user comments) here:

 http://dev.mysql.com/doc/mysql/en/Upgrade.html

Thanks for the info.  Don't know how I could have missed that URL on MySQL's site.

-- 
Regards,
Doug
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]