To import sql dumps it's commonly used PhpMyAdmin. However, if the dump is too large, there some problems can appear such as file size limit, exceeding script execution time, memory shortage and so on.
So the best solution in this case (and the proper one) is to use mysql client utility via the console. For import sql dump we should use "source" statement.
tulvit
@tulvit
-desktop
:~$
mysql -uroot
-proot
;Welcome to the
MySQL monitor
. Commands
end with
; or \g
.mysql> use my_db;
Database changed
mysql> source ~/dump.sql;
...
