Ubuntu Terminal: mysql -u username -p database_name < database.sql does not import completely
What I did was I used the mysql command line client. I think you have an idea now how i did it.
But here we go. In your terminal, type mysql -u <your_username> -p. Then type of course type the password when prompted.
Then run use <database_name>; press enter.
And then, source sqlfile.sql;
That should do the trick. Just wait for it to finish importing.