I want to create a copy of my production site as testing site. Please suggest a method to copy the same database and link it to new site for testing.
bench --site SITENAME backup and find the backup in
sites/SITENAME/private/backups. Then mount it in the database of your test site with
bench --site TESTSITENAME --force restore PATH_TO_BACKUP_FILE