How to import large mysql database on wamp server

Question

Hi, is there an easy way to import a large .sql file of my database on local host without using phpmyadmin. I am using the WAMP server. Thanks for any help.

Answer 1

If you have access to the console you can run mysql directly and just import the file.

something to the effect of:

mysql -u username -p database_name < sqlfile.sql