Help in importing DB from ssh

[badboyz]

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

[snakes1100]

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

[badboyz]

thats wat i did

[snakes1100]

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

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?

[badboyz]

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

this is wat i typed

mysql -u game_new -p bla12 < game.sql

[Eikinskjaldi]

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

[badboyz]

i entered this

mysql -ugame_new -pbla12 game_new< game.sql

its keep asking me to enter the details
nothign happens

[Dismounted]

Have you logged into MySQL?

[Eikinskjaldi]

i entered this


mysql -ugame_new -pbla12 game_new< game.sql

its keep asking me to enter the details
nothign happens

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

[Kirk Y]

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

[UltimateOreo!]

Just make it easier on everyone and do it on a web interface.

[Kirk Y]

SSH is the only reliable method of restoring and backing up a database. ;)