Re: MySQL backward compatibility question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux