Have you seen Step by step CS databases backup and restore?
Migrate DB to new server - ChirpStack Application Server - ChirpStack Community Forum