What’s the size of the dump.sql? It should be sizeable (a few MB at least). Can you take a look inside the file? e.g.
$ zgrep -i "CREATE TABLE public.users" dump.sql.gz
#output should be
> CREATE TABLE public.users (
If you don’t see this, the dump looks wrong.
Also, if you share your steps on how you are exporting the dump or paste your console output here, we can understand your issue better.