who knows how to import a large database on VPS via SSH . please help

[Ciul3x]

who knows how to import a large database on VPS via SSH
Hello
I bought vps. and I want to import a database large vps via SSH, I tried but I failed. who can help me. remain indebted. please
Thanks

Ciul3x Reviewed by Ciul3x on 27th Oct 2011. who knows how to import a large database on VPS via SSH . please help who knows how to import a large database on VPS via SSH Hello I bought vps. and I want to import a database large vps via SSH, I tried but I failed. who can help me. remain indebted. please Thanks Rating: 5

[l0calh0st]

You ever heard of Google?

http://lmgtfy.com/?q=how+to+import+sql+ssh

[Ciul3x]

http://zugec.com/linux/import-sql-via-ssh just like here I did not go look that says yes

[nba517]

do you mean import to mysql? move your database to /user/local/mysql/var

[Devilz]

If you want , I can do it for you

[Ciul3x]

So I downloaded the database from the host, and I put it on VPS. I tried a gram of tutorials but I failed. database is quite large 1.6 Gb

[Ciul3x]

Mr. Devilz. I left a private message if you can help me owe

[Devilz]

If your VPS is Not so strong enough , It may go unstable
PM Replied

[l0calh0st]

Where did you place the sql file? in /root/ ?

Then use this command:
"mysql -uYOURUSERNAME -pYOURPASSWORD -hlocalhost DATABASENAME < /root/database.sql"

Without ""

[JmZ]

Better to not put the pass on the command line, otherwise it'll appear in bash history.

mysql -u username -p dbname < /root/database.sql