Having Problem With Mysql Database Upload

[maverick79]

mysql -u hack -p hacker < backup.sql

'hack' is the user-name
'hacker' is the database name

password is asked interactively.

yes
used this method but i can restore only 106 tables out of the 217 tables i have in my database