title: Method of migration of MySQL version to a new server
body: <p>For some technical reasons, I have to migrate our actual server, running on CentOS, to a new server, but running on Ubuntu.</p>
  
  <p>I MUST keep the SQL DB as it is now, same version of MySQL, etc.
  I have tried several dump scripts and methods, but impossible to import the dumps to a newer version of MySQL.</p>
  
  <p>So I'm thinking of copying the <em>/var/lib/MySQL</em> folder and other MySQL folders to the new server.
  What's your opinion about this ? Will it work ?</p>
  
  <p>I was also thinking of going to the recovery console of the old server and doing an <code>rsync</code> to the new server, this way I copy the entire system to the new server.
  But that's a bit heavy in my opinion. and I don't know Unix enough to <code>remount</code> discs and perform all tasks that would make the copy work.</p>