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

[Lock Down]

That is very strange as it should never be stopped as an ssh command.

What happens to cause it to stop or abort?

I have a 6 gig db on a vps I restore that way and it takes about 4-5 minutes. Your host must having something set wrong.

Unless you are on a shared host.

[feronso]

As i said before, re-upload your Database and try again.

There is no issue with MySQL. its the fault of Database file not uploaded completely.

Upload the file again. not through the FTP. through HTTP. and try again.

the same issue i fix myself tomorrow. its exactly same issue was that.