aleks_glushko
CCConvex Community
•Created by aleks_glushko on 11/18/2024 in #support-community
Dev to prod table export/import
@nipunn I have tried again the following:
- npx convex deploy
- backup dev branch data
- import into prod version the dev branch data
It doesn't work, because of the IDs conflicts, e.g. New table authAccounts has IDs that conflict with existing table activityLogs
The following solution didn't work:
2) Manually delete all the tables in your destination deployment (prod deployment in your case) before doing the import. Then it'll work.Error: Hit an error while importing: _id k1706d0778z3fx7gp8jnn317v574m313 cannot be imported into 'customerUsers' because it came from a different deployment and conflict with preexisting tables in this deployment. Try deleting preexisting tables or importing into an empty deployment. The following solution worked: 1) Create a backup on the dev branch and download 2) Extract the zip file 3) Manually clean the documents.jsonl for the tables that can be avoided to import, in the generated_schema.jsonl put "never" 4) Compress into zip again 5) Use the following CMD command: npx convex import --prod <path to the file>/<compressed file name>.zip
17 replies
CCConvex Community
•Created by aleks_glushko on 11/18/2024 in #support-community
Dev to prod table export/import
Thank you @nipunn , I will try one of the offered solution, while you are fixing the backend.
Quick question: is there a way to get an amount of unallocated concurrent actions that still could potentially run?
17 replies
CCConvex Community
•Created by aleks_glushko on 11/18/2024 in #support-community
Dev to prod table export/import
@Clever Tagline , thank you for your reply! Could you elaborate on what is the migration component exactly? If it is the convex ui components for backup and restore, then, unfortunatelly, it doesn't solve the issue
17 replies
CCConvex Community
•Created by aleks_glushko on 11/18/2024 in #support-community
Dev to prod table export/import
Restoring from a newly created backup also throws an error that one of the tables has unsupported IDs:
Hit an error while importing: _id k1706d0778z3fx7gp8jnn317v574m313 cannot be imported into 'customerUsers' because its IDs have a different format
Why, if all of the deployment tables are empty and schema is exactly the same
17 replies