Moving databases

Discussion in 'Server Operation' started by dayjahone, Aug 29, 2008.

  1. dayjahone

    dayjahone Member

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

    SuSe 9.2
    ISPConfig 2.2.9

    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?
  2. topdog

    topdog Active Member

    To check the version use

    select version();
    To migrate the databases, just do a mysql dump then import on the other end.

Share This Page