Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Transfer Tool and database versions

Discussion in 'Database Discussion' started by nickwuk, Jun 7, 2019.

  1. nickwuk

    nickwuk Active Member

    Joined:
    Jul 18, 2009
    Messages:
    26
    Likes Received:
    2
    Trophy Points:
    53
    How does the Cpanel Account Transfer Tool in WHM respond to the following situations?

    1) If the host database version is MySql 5.7 and the database being imported is v5.5. Does the transfer tool automatically upgrade the database from 5.5 to 5.7, or does that upgrade have to be completed before transfer?

    2) If the host database version is MySql 5.7 and the transfer is attempting to import a MariaDB database (which I understand is not possible), does the tool show a warning message? Does the import of others files halt, or does it continue without the database?
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,484
    Likes Received:
    187
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    The transfer tool makes a mysql dump file of the database and then runs that SQL file on the destination database so whatever conversions take place happen during the restore itself.

    I do not normally do what you are suggesting in scenario 2. However I dont think it's going to cause a problem but if you wanted to test it you could either just transfer one domain as a test or you could make a dump of a database on the mariadb server and try manually restoring on the destination server just to see if that goes through error free.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,466
    Likes Received:
    505
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    It is possible to move to different versions of MySQL/MariaDB in the event you're moving to a newer version on the new server and generally speaking if there are problems or there will be issues the transfer tool will output a detailed error. You can read more about the functions here:

    Transfer Tool - Version 80 Documentation - cPanel Documentation

    How to Move All cPanel Accounts from One Server to Another - cPanel Knowledge Base - cPanel Documentation

    If a transfer will not complete successfully the tool will fail and you'll be notified as well. If you're unsure I a normal transfer (as opposed to an express transfer) that way nothing will be affected in the event the transfer is unsuccessful.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice