Most efficient way to import large data dump from phpmyadmin?

I have a large data dump (export) from phpmyadmin my client just gave me - 200k - .

What’s the most efficient way to import that into a new database? The new db has not defined tables since that is part of the phpmyadmin export.

Thanks!

If you can use SSH:


mysql --password=[I]<password here>[/I] [I]<dbname here>[/I] < [I]<filename here>[/I]

got it - many thanks!

hello
when running this command, you are under which directory ?