Are you not able to restore any data at all or only partial data ? Timeseries aspects(profile, usage, etc) are not part of backup.
I would suggest following debug steps
1. Open and check if your backup.sql file has the relevant data (aspects) correctly.
2. If it is, check whether those aspects are correctly ingested in DataHub RDS(MySQL) i.e. datahub.metadata_aspect_v2
3. If it is, then this might be elasticsearch index issue, simply restoring indices should work.