Hi Gareth 
Thank you for your confirmation/clarification.
I’ve just tried the same on my Linux (Ubuntu) laptop - since I don’t have Mac here
and I could import the .sql.gz file that I exported from my Live site (from MyKinsta) to my local computer using the Adminer tool (Database manager) just fine.
After I exported my database from my Live Site (using PHPMyAdmin tool) into .sql file (and I compressed it to .gz file), I then launched the Database manager from DevKinsta and then I dropped all tables I had in my existing database as shown below (No tables):
Then, I chose the database file (.sql.gz) on my local computer and uploaded it:
After I clicked the “Execute” button, it showed the imported tables/data as follow:
So far I couldn’t replicate that error message that you got on your browser when importing the .sql.gz file using Database manager (Adminer tool) 
I also noticed from the error message you provided, the link mentioned:
%examplesite-migrate-20231129130605.sql.gz'
I’m not sure why it has %
in front of it ?
Could you please check your .sql.gz file in question and perhaps try to rename it with different name - and make sure there’s no “space” in front of it , and try to import that .sql.gz file again using the Adminer Database manager?
If it’s still not working properly on your browser, you might want to try to import your database using WP CLI instead, with the following steps:
-
Move or copy that .sql.gz
file in question to your ~/DevKinsta/public/examplesite
sub-folder and extract/de-compress it to .sql
file within that sub-folder.
-
Open Terminal program , and run this command:
docker exec -u www-data -it devkinsta_fpm bash
-
In that devkinsta_fpm
docker/container, type the following to go to your examplesite
sub-folder:
cd /www/kinsta/public/examplesite/
-
Then inside that /www/kinsta/public/examplesite/
sub-folder, be sure to check if the .sql
database file is there ( you can check with something like: ls -la yourdatabasefile.sql
)
-
After that, you can try to perform this WP CLI to import that .sql file to your existing database:
wp db import yourdatabasefile.sql
If all is well, you should see: Success: Imported from 'yourdatabasefile.sql'.
In case, it returns an error that such table(s) already exist(s), you may want to first make a backup of your existing local DB with WP CLI: wp db export
(and it will create a new .sql file in your /www/kinsta/public/examplesite/
subfolder).
After that you can empty that existing local DB with this WP CLI: wp db reset
(and answer with y
). Once it’s reset, you can then try to import the previous DB file with the same WP CLI above: wp db import yourdatabasefile.sql
When you’ve done with the DB import, you can type: exit
to quit from that devkinsta_fpm
docker/container, and you may then remove/delete that .sql file(s) in question.
Note:
Since you’re importing the .sql that you exported/dumped from your Live Site, the URLs in your local database may still be referencing to your live site’s domain URL, and if that so then you will need to perform Search and Replace too via WP CLI (to replace the live site’s domain URL with your .local domain URL).
Hope that helps!
Best regards,
Agus