I am needing to upgrade MySQL on Ubuntu, it is a production server and naturally cautious.
My many googles look to be essentially saying that I need to :
Backup my current mysql database and tables/data
Uninstall current mysql
Install new MYSQL 5+
Restore Databases/ tables and data
Hope and Pray I got it right ??
Something doesn't seem right, sounds like a lot of down time and risk
Am I missing something, or any simple solutions?
Upgrading from MySQL 4 to 5 on Ubuntu 10