Moving databases

[dayjahone]

To give you a more complete picture, I am trying to transfer websites from server A to server B with the following info:

SERVER A:
SuSe 9.2
ISPConfig 2.2.9

SERVER B:
Ubuntu 8
ISPConfig 2.2.24

I am not sure which version of MySQL I am running. How do I check? How do I upgrade?

Because just about everything that can be different probably is and I have relatively few sites to transfer over, I was going to just recreate them on the new server. The problem with this is some of the websites use databases for blogs and such. Is there a simple way to copy the db from a website on the old server and add it to a website on the new server?

[topdog]

To check the version use

select version();

To migrate the databases, just do a mysql dump then import on the other end.