1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MSSQL / MYSQL migration between 2 servers

Discussion in 'Plesk for Windows - 8.x and Older' started by mircea_hosteur, Feb 7, 2006.

  1. mircea_hosteur

    mircea_hosteur Guest

    0
     
    how do I transfer several MSSQL servers when I am forced to manually migrate hosting accounts from a server to another !

    I have manually recreated about 150 sites on another new server, I have transfered the files, but I need to transfer databases also. Ok, I found the location of databases, but how do I proceed in order to retore connexions with Plesk ?!!
     
  2. igoldman

    igoldman Regular Pleskian

    26
    23%
    Joined:
    Sep 14, 2004
    Messages:
    212
    Likes Received:
    0
    Hello,

    why not to use Plesk Backup tool ?
    it will backup every thing.

    and then use plesk restore tool
     
  3. mircea_hosteur

    mircea_hosteur Guest

    0
     
    BUT MANUALLY

    I KNOW BUT I NEED TO RESTORE IT MANUALLY, BECAUSE OF SOME pLESK CRASHES
     
  4. OlegB

    OlegB Guest

    0
     
    The only way to make a connection between Plesk and SQL databases is to create that databases directly through Control Panel.
    It will create empty databases. If you want to restore backed up content you need remove that DBs from within SQL server and restore them from backup.
     
  5. Bogdan

    Bogdan Guest

    0
     
    Mircea,

    I migrated a few servers by backup/restoring to new boxes and if you try hard enough you will be able to make the backup work.

    If you still wanna do the transfer the 'hard core' way... here are a few things:

    You can transfer MSSQL db's using DTS from one SQL server to another and then add the databses and users in Plesk by editing the psa (just a few automated queries on the data_bases and db_users tables, very nice and easy).

    I has a very similar problem. I use an external dedicated SQL servers for all Plesk webservers and the migration process doesn't migrate remote dbs, so I have 2 little scripts that generate the mysql querries I need to run on the psa using data from the old Plesk server (domain name, db name, db user, uder passwd) and It doesn't take more that 10 mins for the whole process.

    If you need additional info, please contact me on IM.
     
Loading...