Having the same issue reporting in this closed thread: Can't import 130mb database - #4 by jasmink
I see a solution here with command line import, but need a little help getting the syntax correct:
docker exec -i [mysql_container_name] mysql -u[username] -p[password] [DB name] < [path/to/sql/file]
How do I make sure I’ve got the right file path to the sql file (on windows)? I’ve got it at c:\users\username (which is where terminal defaults to when I’m running the docker exec) so, I’ve put it together as follows with actual username/pw/db name replacing text in [ ]:
docker exec -i devkinsta_db mysql -u[username] -p[password] [DB name] < database.sql.gz
When I do this, I get what looks like the help menu, (no login error) but no import happens. I’m guessing I must be doing something wrong with the filepath? Or is there another step I need to do after running this command?