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

 

[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

 

[sady92]

Follow this.

http://www.wjunction.com/18-server-management-help/88270-database-import-problem.html

 

[JPC-Sabrina]

I was going to say that you could check your hosting provider and see if they offer some tutorials. Many good providers will offer flash tutorials for almost everything. I do see someone here has offered to do it for you. Tutorials don't work for everyone but they are a good option for learning new tricks and old basics.