can't restore db in phpmyadmin

When I’ve had .sql files that were too large to import via phpmyadmin, I’ve been able to sometimes work around the size limit by *carefully* splitting the .sql file into a series of files in a plain text editor.

https://www.gbmini.net/wp/2008/11/splitting_wordpress_export_import_file/

is there any other way to do this without splitting the file

Basically, there are four ways to do this. You’ve ruled out #1 and #3, so that leaves #2 and #4.

Since you are running on localhost, Option 2 might be “easiest.”

great, solution 2 worked. thanks! now i have another question though but I think it needs its own thread

thanks again!

@andrewmills

Putting the .htaccess in the local phpmyadmin folder worked for me.

In a WanpServer install, the phpmyadmin folder can be found in the wamp > apps folder.

Thanks so much.