Linux command - basic

Type the following command at the shell prompt:
$ ssh loginname@server.hosting.com
Now type following command to import sql data file:
$ mysql -u username -p -h localhost data-base-name <>
If you have dedicated database server, replace localhost name with actual server name or IP address:
$ mysql -u username -p -h 202.54.1.10 databasename <>
OR use hostname such as mysql.hosting.com
$ mysql -u username -p -h mysql.hosting.com database-name <>
If you do not know the database name or database name is included in sql dump you can try out something as follows:
$ mysql -u username -p -h 202.54.1.10 <>

Dump database

mysqldump – h localhost –u root –p xxxx > nama.sql

xxxx=nama database

check port

ps –ef|grep java

kill

kill -9 no_port

show all the running task in terminal

top

choose specified task

press shfit + f, choose any alpha then enter