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.

Read More>

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

Read More>

May - 9th

Converting a UNIX .COM Site to Windows

Posted at 14:59 | Filed Under bsd, windows

M”crosöft Internal Distribution

Abstract

This white paper discusses the approach used to convert the Hotmail web server farm from UNIX [...]

Read More>

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

Read More>

Oca - 7th

MySQL ‘de max_connection değerini artırmak

Posted at 10:39 | Filed Under mysql

MySQL’de max_connection(aynı anda izin verilen en çok bağlantı sayısı) değerini artırmak icin /etc/rc.conf dosyasına mysql_args=”-O max_connections=XXXX” ifadesi eklenir.
Örneğin bu değeri 1000 yapmak için:
mysql_args=”-O max_connections=1000″

Read More>

Oca - 6th

cdn tests at mailman

Posted at 16:35 | Filed Under bsd

# wget -O /dev/null http://speedtest.voxcdn.com/test_tenmb.data
# wget -O /dev/null http://cachefly.cachefly.net/10mb.test
# wget -O /dev/null http://bitcast-a.bitgravity.com/bitgravity/10MB
# wget -O /dev/null http://test.vo.llnwd.net/o1/sales/tenmegfile.wmv
# wget -O /dev/null http://74.63.66.114/100MBtest.zip
# wget -O /dev/null http://www.tranxactglobal.com/speedtest/11mbtest
# wget -O /dev/null http://arpnetworks.com/100mb.bin
# wget -O /dev/null http://lg.denver.fdcservers.net/10MBtest.zip
[16:20:29] wget -O /dev/null http://speedtest.voxcdn.com/test_tenmb.data
–2009-01-06 16:20:34– http://speedtest.voxcdn.com/test_tenmb.data
Resolving speedtest.voxcdn.com… 208.122.31.15, 208.122.31.16, 208.122.31.17, …
Connecting to speedtest.voxcdn.com|208.122.31.15|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 10485760 (10M) [...]

Read More>