dtwilliamsWork opened a new issue, #8186: URL: https://github.com/apache/incubator-devlake/issues/8186
I need to reinstall DevLake onto a new EKS cluster and don't want to reconfigure all my projects, connections, etc. I have connected to the MySQL pod using `kubectl -n dora exec -it pod/devlake-mysql-0 -- /bin/sh` and run the following command ``` cd && mkdir dump && cd dump mysqldump --host=localhost --user=merico --password=merico --quote-names --create-options --skip-comments --force --databases lake > devlake.sql ``` Once the backup has been completed, I can copy it to my local PC using ``` kubectl cp -n dora devlake-mysql-0:root/dump/devlake.sql ./devlake.sql --retries 10 ``` Once it's finished copying (it's 13GB), I can connect to our other EKS, connect to the MySQL pod using `kubectl -n dora exec -it pod/devlake-mysql-0 -- /bin/sh`, create a new /root/dump folder, and then upload the devlake.sql image from my local PC. ``` kubectl cp -n dora devlake.sql devlake-mysql-0:root/dump/devlake.sql --retries 10 ``` Once this has finished uploading, I connect to MySQL pod again and restore the db. ``` kc -n dora exec -it pod/devlake-mysql-0 -- /bin/sh cd /root/dump mysql -u merico -pmerico lake < devlake.sql ``` This seems to work to an extent, but I am missing all my projects. It has restored the connections, blueprints, and pipelines, but my projects list is empty. The blueprints even show the project names, but when you click on them, it goes to the projects page but can't find the project and just has a spinning loading icon. Is there a way to backup just the tables required so the backup isn't so large, making it easier and quicker to restore? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
