I figure this out.
The looping is due to FORCE_HTTPS setting. My original server is running in HTTPS while my new server (development) is running in HTTP. If I import the database (the backup database) directly into my HTTP (development) server, there is a loop between HTTP, and HTTPS since FORCE_HTTPS is enabled.
In order to turn off FORCE_HTTPS, we can follow instructions in this post
IMO, is it possible to add an environment SET_FORCE_HTTPS such that entrypoint.sh can do this update at all?