Home Blog Page 1142

upgrade mysql version on linux server

You can upgrade your mysql version from 5.0 to 5.5 by using following steps

1. Enable remi repository for yum

wget http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
sudo rpm -Uvh remi-release-5*.rpm epel-release-5*.rpm

2. Run mysqldump to export data out from MySQL 5.0

mysqldump -uroot -p –all-databases > mysqlbackup.sql

3. Run ‘yum –enablerepo=remi install mysql mysql-server mysqlclient’

4. Run mysql_upgrade (part of mysql-server.rpm) to clean up the upgraded package

mysql_upgrade -u root -p

5. Adjust my.cnf (version 5.0) for version 5.5

6. Restart MySQL if needed

 

How to Find Your Linux Version or Distro Release, and Why It Matters

kernel release version

Quick quiz: How do you know which version of Linux you are using? Which kernel? Which distribution? Which release of your distribution?

Believe it or not, there are situations where this information could be of great importance. Say, for example, a new threat has been released (such as a rather serious OpenSSL-related security issue) which only affects specific releases. If the flaw only affects specific distributions, distribution releases, kernels, or packages you need to be able to quickly gather information about the distro you’re running, and act.

Outside of that very crucial example, there are other reasons why you will want to know about Linux releases—even release types—in order to better navigate the world of Linux and all the power that comes with the platform.

Before we get into how to discern the various bits of information on your desktops and servers, I want to discuss the two major types of Linux releases.

Rolling versus fixed release

There are, effectively, two types of releases in the world of Linux:

  • Rolling

  • Fixed.

The two different releases are quite different, so it is important to understand how they work. The easiest way to know the difference between a Rolling and Fixed released distribution is this:

A Rolling release is constantly being updated and works with one code branch.

There are two ways of dealing with this constant state of updating. The first, and most popular, is to release a steady stream of very small updates. With this release model, the distribution is in a perpetual state of having the most up-to-date software. The second method (one which Ubuntu Core is adopting) is to replace the full image of the operating system with a new one as it is made available. Clearly, the latter option is only viable for cloud deployments (as replacing a full image is really just a distribution upgrade or reinstallation).

The Fixed release is fairly standard. You install a release and, as long as said release is supported, security and patch updates to packages will be available to you as they are seeded to the distribution repositories. You may not see updates daily (or even weekly), but they will eventually appear as available to your desktop or server. The upside of the Fixed release is stability. For many, the major downfall of the Fixed release is the need to completely reinstall (or trust that a major upgrade will not have issues on a production machine) based on a distribution’s release schedule (such as Ubuntu’s six-month schedule).

Each release type has its pros and cons. For example, the Rolling release offers you a platform that almost always has the most up-to-date version of the software you use, but due to that bleeding edge nature, may suffer instability at times. The Fixed release most often will include software that is less than bleeding edge, but it may often enjoy a bit more stability.

For a full list of Rolling release Linux distributions, check out this Wiki page.

With that information out of the way, how do you “uncover” the necessary information about your particular Linux distribution? There are a few tools at your fingertips. Let’s use them.

It is also important to make mention of a particular release structure given to Ubuntu and its supported flavors (Kubuntu, Xubuntu, Ubuntu GNOME, etc). Every two major releases (i.e. 12.04, 14.04, 16.04, etc.) an Ubuntu release is considered Long Term Support. This means support for the release will extend for five years (on both desktops and servers). On standard, non-LTS releases, support is only valid for six months. An LTS release is Enterprise-focused, compatible with new hardware, and more thoroughly tested than non-LTS releases. With that said, if you want a more cutting-edge Ubuntu distribution, go with the non-LTS release. If you want stability and support, install only the LTS releases.

Finding your kernel release

There will be times when you must know your kernel release number. Fortunately, the developers saw fit to include a handy tool that will quickly display your kernel release number. Here’s what you need to do:

  1. Open up a terminal window

  2. Issue the command

    uname -r
  3. Take note of the information displayed (Figure 1).

Finding your distribution release

There may be times when you need to know the release number you currently use. Again, there’s a handy command to find that information. Do the following:

  1. Open a terminal window

  2. Issue the command

    lsb_release -a
  3. Take note of the information displayed (Figure 2).

distro release number

If your command fu isn’t what it should be, most distributions display their release numbers in Settings > Details > Overview (Figure 3).

Figure 3: The Ubuntu release number as seen from the Settings tool.

This method of discerning your distribution release information has the added bonus of handing you some details about your system hardware (memory, CPU, graphics, OS type, and disk size).

Finding a specific package release number

Let’s dig a bit deeper. Say you’ve read that OpenSSL has a security flaw that affects only specific releases. How do you find out which version of OpenSSL is on your system? This will depend upon your distribution.

For a Debian-based distribution (such as Ubuntu), you would issue the command:

dpkg -l openssl

Which would report all the information you needed for the package installed on your system. (Figure 4).

OpenSSL version info

If you’re using an rpm-based distribution (such as Fedora), the command to locate information about OpenSSL would be:

rpm -qa | grep openssl

The above command will return information on all installed openssl packages.

Figure 5: Details on OpenSSL installed on Fedora 22.

You now have the knowledge and tools to find your release information. You may never need to know any of this data … but on the occasion that you do, you’ll be glad it’s at your fingertips. It is of the utmost importance that, when you hear of critical issues surrounding packages like OpenSSL, SSH, PHP, etc. you check the versions installed on your machine against the affected packages and take action. Luckily, you now have the ability to do just that.

Cloud Music Player Tomahawk Updated for Linux

Tomahawk is a music player capable of using both local and cloud libraries. A new update has been released for this application and it comes with a few interesting changes.

Most of the music in your library is probably already available in various cloud services like Grooveshark or Beets, so developers made an app that is capable of using most, if not all of the cloud music services, and thus Tomahawk was born.

“Support for Qt4 in git-master won’t be dropped unless there… (read more)

Read more at Softpedia News

DRM Graphics Updates Sent In For The Linux 4.1 Kernel

David Airlie has sent in the big pile of DRM subsystem updates for the Linux 4.1 kernel that includes significant work to the Radeon, Intel, and Nouveau drivers along with the DRM ARM drivers and the introduction of the new VGEM driver…

Read more at Phoronix

VMware Starts Two Open Source Projects Focused on the Cloud

VMware has turned a significant corner, and is adopting open source in a big way. The company has announced two new open source projects focused on enterprise adoption of cloud-native applications — Project Lightwave, an identity and access management project for enterprise-scale and security to cloud-native applications; and Project Photon, a lightweight Linux operating system built for cloud-native applications.

These new open source projects are targete to integrate into VMware’s unified platform for the hybrid cloud — giving it options for providing private and public cloud to support cloud-native and traditional applications. “By open sourcing these projects, VMware will work with a broad ecosystem of partners and the developer community to drive common standards, security and interoperability within the cloud-native application market,” the company announced.

 

Read more at Ostatic

Canonical Is Now Using Phased Updates for Ubuntu Touch

A fresh Ubuntu Touch update was made available just a few days ago, and it was received very well by the community, but Canonical also introduced a new feature called phased updates.

Now that Ubuntu phones are in the wild, Canonical is trying to make everything so that the experience of those users goes as smooth as possible. For example, … (read more)

Read more at Softpedia News

Android Wear Poised to Get Big Update: Gesture Control, Wi-Fi and More Added

Google’s wearable-friendly Android Wear OS is bound to get a new important update in the upcoming weeks. It’s high time Google revamped its platform, since the previous major update rolled out back in October.

So in case you are curious what new features are incoming, Google is providing us with a list of improvements we should expect t… (read more)

Read more at Softpedia News

More eBPF Improvements Heading To Linux 4.1

With the in-development Linux 4.1 kernel one of the new features is for eBPF programs to attach to Kprobes but now there’s more eBPF work headed for this next major kernel version…

Read more at Phoronix

Kdenlive 15.04 Is a Great Free Multi-Track Video Editor for Linux

Kdenlive is one of the few free multi-track video editors for Linux that supports DV, AVCHD and HDV editing. The developers have reminded the community once more that a new major version has been released, 15.04.0, and that the project is now part of the KDE Applications suite.

The KDE project was recently split into KDE Applications, KDE Framework, and KDE Plasma, which means that the old KDE SC is no more. Users will still find KDE in the old formula in some of the distro… (read more)

Read more at Softpedia News

LLDB Is Getting Into Shape For Linux 64-bit Debugging

From Valve’s interest in the LLDB debugger to many other firms also being interested in LLVM’s debugger as an alternative to GDB on Linux, LLDB is getting into very usable shape for 64-bit Linux systems…

Read more at Phoronix