Skip to main content
cPanel Technical Support has been heavily impacted by hurricane Beryl and our ability to respond to tickets has been hindered as a result. We appreciate your understanding and patience as we address these delays.

How does the transfer tool work when using a remote MySQL server?

Comments

4 comments

  • radianation
    Another option is temporarily running two RDS simultaneously and migrating the databases to the new one. This creates a completely separate instance for staging purposes. I would then run a script to update the old RDS address to the new one for the websites. If there is a better way, I'm open to suggestions.
    0
  • cPRex Jurassic Moderator
    Hey there! I've been talking this over with a few people today and we all think the second option of creating another RDS system and performing the migration is the safest to avoid conflicts with how you want the migration to happen.
    0
  • radianation
    Thanks. I'm inclined to agree. The small fee of running them parallel is worth it for peace of mind. Would the permissions technically be the same on the new/old RDS? The steps look like this: 1. New server & RDS 2. Transfer the sites 3. Change remote MySQL connection to point to old RDS (at WHM level, not per site) If step 3 works, that could prevent me from manually updating many connection strings.
    0
  • cPRex Jurassic Moderator
    The only thing I would add is under step 2, you can choose to disable databases in the dropdown section under the account in Transfer Tool, as mentioned in step 4 here:
    0

Please sign in to leave a comment.