Ara - 10th
Büyük databaseleri yedek almak
Posted at 11:48 | Filed Under Uncategorized, mysql, shell
Büyük tablo adedi çok databaseleri yedek alırken şöyle bir hata ile karşılaşıyorsanız,
mysqldump: Got error: 1016: Can’t open file: ‘./databasename/table.frm’ (errno: 24) when using LOCK TABLES
mysqldump -u MyUsername -p MyDatabase –lock-tables=false
yazarak dump alma işlemine devam edebilirsiniz.
Ağu - 10th
Convert lower case to upper and upper to lower case using tr
Posted at 14:22 | Filed Under shell
lower to upper
tr ‘[a-z]‘ ‘[A-Z]‘ < lower-upper-case.file > upper-lower-case.file
upper to lower
tr ‘[A-Z]‘ ‘[a-z]‘ < upper-lower-case.file > lower-upper-case.file
Oca - 20th
How to tar and untar files in UNIX?
Posted at 16:44 | Filed Under shell
tar
tar -czvf folder-$(date "+%Y%m%d").tar.gz folder
untar
tar -zxvf folder-20090120.tar.gz
