Feb 9, 2010

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 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 <>

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

xxxx=nama database
check port
ps –ef|grep java
kill -9 no_port
show all the running task in terminal
choose specified task
press shfit + f, choose any alpha then enter


Post a Comment

Jariku berkata:


My Chenta Hati

Daisypath Anniversary tickers

My Precious...

Daisypath Happy Birthday tickers
Copyright 2009 MyPalace. Powered by Blogger Blogger Templates create by Deluxe Templates. WP by Masterplan