Help in importing DB from ssh
 

hello.

im trying to import DB from SSH. after i entered

my details
mysqldump -u db_username -p db_name >backup.sql

it asks for password.

and after entered nothing happens.i checked on cpanel my DB is still empty.why is it

mysql -u -p dbname < /path/to/db.sql

thats wat i did

Not according to your first post it isn't, mysqldump is for exporting the database.

Do you have the right database name and path to the backup file correct?

Are you sure the backup file your importing from actually has anything in it?

oh
i want to import.yes i have the right DB and infor

this is wat i typed

Your problem is the spaces. there should be no spaces between the u and the username and the p and the password. Also, the mysql dump probably does not have a database in its specification.

instead of

mysql -u game_new -p bla12 < game.sql

use

mysql -ugame_new -pbla12 name_of_db < game.sql

i entered this

mysql -ugame_new -pbla12 game_new< game.sql

its keep asking me to enter the details
nothign happens

Have you logged into MySQL?

What details does it ask you to enter? Its hard to help you when you are so vague.

Is "game.sql" in the right location? The way you're executing the query, it should be located in the root - is it?