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.