I'm starting to play around with MySQL and PHP on fedora 12.
With Fedora's fanatical devotion to churning out latest versions of everything, I'm just wondering what the rate of new MySQL versions that are non-backward compatible has been like.
Would I be better off using mysqldump and restoring databases across fedora releases as time goes on, or is just restoring the /var/lib/mysql datadir sufficient to retore databases most of the time?
Just curious about the best way to approach backups if I actually accumulate any useful data in these experiments...
On Sat, 2010-03-06 at 11:24 -0500, Tom Horsley wrote:
I'm starting to play around with MySQL and PHP on fedora 12.
With Fedora's fanatical devotion to churning out latest versions of everything, I'm just wondering what the rate of new MySQL versions that are non-backward compatible has been like.
Would I be better off using mysqldump and restoring databases across fedora releases as time goes on, or is just restoring the /var/lib/mysql datadir sufficient to retore databases most of the time?
Just curious about the best way to approach backups if I actually accumulate any useful data in these experiments...
---- you should have a regular plan to mysqldump your data (either database by database or the entire system or both). The fact that you have been able to migrate up or down merely by allowing mysql to handle the changes from version to version by altering the files in /var/lib/mysql directory merely trades on good fortune but if the conversions fail, the damage may be imperceptible for some time.
the best way to approach backups has always been dumping the database - nothing has changed there and is highly unlikely to change in the foreseeable future.
As for 'Fedora's fanatical devotion to churning out latest versions of everything' - despite the negative characterization you seemingly want to attach to it, is it actually possible that you don't understand what the mission of Fedora is? Just in case you missed it... http://fedoraproject.org/wiki/Overview If Fedora objectives don't track with your needs, there are plenty of other distributions available, some of which might track your needs more closely.
Craig
On Sat, 06 Mar 2010 09:53:01 -0700 Craig White wrote:
As for 'Fedora's fanatical devotion to churning out latest versions of everything' - despite the negative characterization you seemingly want to attach to it
No negative intent. I run fedora because of it (I need to know what curveballs future RHEL releases are likely to be throwing at me :-).