Database one-time import
About one-time database imports
One-time database imports allow you to easily transfer your database from one stack to another, using MySQL, PostgreSQL, MongoDB and Redis databases.
To use this feature, you will need two stacks with the same database type - one is the source and the other is the target for the data migration. This process will import the latest available managed backup from your source stack, replacing the contents of your target with the backup. We recommend that you backup your target database before running this.
Using one-time database imports
On your stack detail page, visit your database server group (eg. MySQL server) and click the name of your main database server. In the right sidebar, click Database Import, which will display a list of available source stacks.
Select the stack you want to use as a source and click Import, which will start the data import from your source to the target.
You need Control stack access rights to see the One-time data import icon. Additionally, you will only see source stacks that you have Stack administrator rights to.
It can happen that the desired stack is not listed when using DATABASE IMPORT, there could be a few reason behind this:
- Your user is not Administrator on the sources stack:
If you are not the account owner or in another word you are a team member, your role on the source stack may be different from Administrator, you can ask your organization owner to check this and make a decision based on that (either change your role on the source stack or the owner import the database).
- The backup on the source stack is Binary:
Since the Binary backups take the backup from the file system importing it to another stack (i.e different server) is a tricky, so we've opted out for not allowing users to import database when Binary.
You can check this by clicking on the backup link, and then edit to see if it a binary backup or not. If it is a binary backup you can change it to text first, run the back up and then go the destination stack and see that the source stack should be listed. After you are done with the database import you can go to the source stack and revert it back to Binary.