Saturday, July 10, 2010

Case sensitive problem in MySQL

Copy the following mysql property in order to disable the case sensitivity in MySQL in "/etc/my.cnf" file in linux under "[mysqld]" section.

"lower-case-table-name =1"

and restart the server.

Coping a file from remote host with SCP

Coping a file from remote location
-----------------------------------------
Syntax : scp @:remote_filepath local_path_to_copy

Ex: scp root@x.x.x.x:backups07_03_10_03_15_01.gz MQshiva/
root@x.x.x.x's password: