3 Aralık 2012 Pazartesi

Image Processing In Java

Debojyoti Majumder posted a fairly nice Image Processing Tutorial videos in Youtube:

http://www.youtube.com/view_play_list?p=BF587ED1F7B44361


But Debojyoti probably has forgotten to post the source code somewhere on the net:). I have uploaded the source code as a Maven project. You can downloaded the zipped project using following link.

https://docs.google.com/open?id=0BzOP9iB5jL6fMFJISDY4bjA5eUk

19 Eylül 2012 Çarşamba

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

18 Eylül 2012 Salı

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

8 Ocak 2012 Pazar

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