Unable to import SQL db into local WP site

[buzztone]

Hi Nakshatras,

I had exactly the same error on Windows 11 with .sql file size of 473 MB. I solved the problem using this earlier solution.

Unable to access database

Hey Everyone – We’ve been zeroing in on why this is happening and the general issue is that the wp db subcommands use the --no-defaults param which blocks out the custom MySQL config we provide. There is a solution but we ran into major issues when trying to implement it on Windows so we’re still working on a way to implement this in a way that works across the various environments. In terms of a workaround, as @kristarella mentioned, you should be able to do some of the basic things wit…

NOTE: The import in my case took a couple of minutes to run.