Migrating MySQL database from U10.04 to U14.04 under ISPConfig3

Discussion in 'Installation/Configuration' started by Nap, Jul 27, 2014.

  1. Nap

    Nap Member

    I've just upgraded the OS on my VPS server and all that's left to do is the migration of the databases.
    I have exported all the data though phpMyAdmin to a .sql file from a backup server.

    My plan is to:
    1. use a script to export all the database users (and their permissions) from the backup server
    2. prune the list to remove the admin accounts (root, ispconfig, etc)
    3. import the sql data
    4. import user info into the new server

    I'm worried that I might confuse ISPConfig3 by doing this, since I won't be manually creating the databases and database user accounts in it.

    Also, I will need to do something similar for FTP and SSH users etc.

    Is this a good idea? What is the best way of migrating the user and database schema?


Share This Page