0 comments Sometimes you have to remove directories from your VCS tool.
find . -name .svn -exec rm -rf {} \;
find . -name .svn -exec echo {} \;
0 comments --head – performs HEAD http request (not GET).
curl --head https://www.wp.pl/
--get – performs GET request
-i – include headers
curl --get -i https://www.wp.pl/
0 comments Simple thing if you want to have min and max in SQL query.
ROUND((RAND() * (max-min))+min)
0 comments So, you have to copy one directory into another on your server and you don’t want to kill the machine?
Instead of
cp -r master master_copy
use
rsync --bwlimit=30000 -av master/ master_copy/
The –bwlimit=KBPS switch is for limiting I/O bandwidth.
0 comments Small thing but extremely useful. Getting context with grep.
-C – Print num lines of leading and trailing context surrounding each match. The default is 2 and is equivalent to -A 2 -B 2. Note: no whitespace may be given between the option and its argument.
grep -C 5 file.txt
0 comments Title: Agile w pracy agencyjnej – z dwóch perspektyw – programisty i project managera
Venue: LoGeek Night #2, 23.01.2014
Slides: Slideshare
0 comments If you have to remove large number of files, like hundreds of thousands, and don’t want to kill your production server, instead of rm -fr DIR you can use this little fella.
while [ true ]; do ionice -c 3 find DIRECTORY_TO_BE_DELETED -type f -print | head -50000 | xargs rm -f; sleep 50; done
0 comments Simple, yet useful. -e option does the trick.
zip -r -9 -e name.zip folder/
0 comments Title: Architektura to podstawa. Efektywny rozwój rozbudowanych projektów przy użyciu Symfony 2
Venue: DevCon GigaCon Wrocław, 23.06.2013
Slides: Slideshare
0 comments If you would like to dump all tables and triggers and stuff try this one:
mysqldump -uUSER -p -R --opt --triggers DB > DB_DUMP.sql
but if you have some troubles with permissions for locking tables use --lock-tables=false
mysqldump -uUSER -p -R --opt --triggers --lock-tables=false DB > DB_DUMP.sql
and to dump all databases you have
mysqldump -uUSER -p -R --opt --triggers --lock-tables=false --all-databases > DB_DUMP.sql
also, great post on StackExchange with a script for dumping all databases without databases like `mysql`, `information_schema`, `performance_schema`, `sys`.
MYSQL_USER=root
MYSQL_PASS=rootpassword
MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
#
# Collect all database names except for
# mysql, information_schema, and performance_schema
#
SQL="SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN"
SQL="${SQL} ('mysql','information_schema','performance_schema')"
DBLISTFILE=/tmp/DatabasesToDump.txt
mysql ${MYSQL_CONN} -ANe"${SQL}" > ${DBLISTFILE}
DBLIST=""
for DB in `cat ${DBLISTFILE}` ; do DBLIST="${DBLIST} ${DB}" ; done
MYSQLDUMP_OPTIONS="--routines --triggers --single-transaction"
mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} --databases ${DBLIST} > all-dbs.sql