My Favorite Total Commander Shortcut

Yet, it is hard to find, following is my favorite Total Commander shortcut:):

CTRL+ALT+Letter(s): Jump to a file/location


Thanks to http://www.keyxl.com/aaa8055/84/Total-Commander-keyboard-shortcuts.htm.

Mysql Start/Stop

Start Mysql:

mysqld

You can test whether your instance is up and running by issuing 'telnet localhost 3306'.


Shutdown Mysql:

mysqladmin -u [mysql_user] shutdown

JDBC ile Mysql'de Turkce Karakter Kullanımı

Mysql'de Türkçe karakterler sorunsuz kullanılabilmesi icin UTF8 karakter seti kullanılabilir. Mysql'de UTF8 kullanmak icin asagidaki adimlarin uygulanmasi gerekiyor:

1. Tablo olustururken standart karakter set olarak UTF8 seçilmeli.

CREATE TABLE 'video' (
...
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


2. JDBC ile baglanirken, JDBC url'de karakter set olarak UTF-8 verilmeli.

jdbc:mysql://localhost/youtube?useUnicode=true&characterEncoding=UTF-8

Mysql Backup and Restore

Backup

You can use mysqldump to create a simple backup of your database using the following syntax.

mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]

Following is an example of a database backup command:

mysqldump -u mysql_user -p mysql_pass clipbucket > clipbucket.sql

Restore 

The dump file retrieved from from mysqldump command can be restored using mysql command. Following is the general format of restore command: 

mysql -u [username] -p [password] [database_to_restore] < [backupfile] 


Following is an example of a database restore command:

mysql -u mysql_user -p mysql_pass clipbucket_2 < clipbucket.sql

Solaris: How To Disable/Enable Desktop GUI

To disable the GUI on startup, run the following command:

/usr/dt/bin/dtconfig -d

Restart the system using init 6 and you will see that GUI will no longer start automatically.

To enable it again, use the following command:

/usr/dt/bin/dtconfig -e

You may just want to start desktop manager without enabling it. Use the following command to start desktop manager, without restarting Solaris:
/etc/init.d/dtlogin start

When is my table last analyzed?

Following query shows the latest analysis time of tables in Oracle:

SELECT distinct stattype_locked, table_name, last_analyzed
FROM dba_tab_statistics 
WHERE owner = 'HR' order by last_analyzed desc;

Solaris: How To Download File In Command Prompt

wget command is used to download files in unix based operating systems. But in Solaris the command does not seem to exist:

# wget
wget: not found

Actually it exists in the file system. But it just isn't added into PATH by default. The location of command is /usr/sfw/bin/wget. Following is a usage example of wget in Solaris.

# /usr/sfw/bin/wget google.com
--2010-10-08 11:15:20--  http://google.com/
Resolving google.com... 74.125.87.99, 74.125.87.104
Connecting to google.com|74.125.87.99|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: http://www.google.com/ [following]
--2010-10-08 11:15:20--  http://www.google.com/
Resolving www.google.com... 74.125.87.104, 74.125.87.99
Reusing existing connection to google.com:80.
HTTP request sent, awaiting response... 302 Found
Location: http://www.google.com.tr/ [following]
--2010-10-08 11:15:20--  http://www.google.com.tr/
Resolving www.google.com.tr... 74.125.87.104, 74.125.87.99
Reusing existing connection to google.com:80.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: `index.html.2'

    [ <=>                                                                                       ] 9,005       --.-K/s   in 0.01s  

2010-10-08 11:15:20 (685 KB/s) - `index.html.2' saved [9005]