Import large database in php my admin

If you’ve got SSH access, you can import it via WP-CLI:

https://developer.wordpress.org/cli/commands/db/import/

wp db import file.sql

This can handle large imports fine.

Note: wp-cli must be installed on the server (check with wp --info)
and target database must be empty (check with wp db check). You must manually upload the file.sql import file via sftp/plesk/cpanel first.