Skip to content

Instantly share code, notes, and snippets.

find -iname '*.mp3' -print0 | xargs -0 mid3iconv -eCP1251 --remove-v1
git rm -r --cached /
@mightydes
mightydes / Add sudoer
Last active August 29, 2015 13:56
Linux
useradd -d /home/my_user -m -U -G sudo my_user
nano /etc/passwd
# Reaplce `my_user:x:1000:1000::/home/my_user:/bin/sh`
# with `my_user:x:1000:1000::/home/my_user:/bin/bash`
visudo
# Replace `%sudo ALL=(ALL:ALL) ALL`
# with `%sudo ALL=(ALL:ALL) NOPASSWD: ALL`
Делаем бекап
mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql
Создаём структуру базы без данных
mysqldump --no-data - u USER -pPASSWORD DATABASE > /path/to/file/schema.sql
Если нужно сделать дамп только одной или нескольких таблиц
mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 > /path/to/file/dump_table.sql
Создаём бекап и сразу его архивируем
@mightydes
mightydes / Base fastcgi
Last active August 29, 2015 13:56
Nginx
# any php file
location ~ \.php$ {
# drop 404 on file not found
try_files $fastcgi_script_name =404;
# or route to index.php on file not found
#try_files $fastcgi_script_name /index.php?$args;
fastcgi_pass unix:/var/run/php5-fpm.sock;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
@mightydes
mightydes / Centos 6.2 for Web-Dev
Last active December 19, 2015 01:29
Centos 6.2 for Web-Dev: * php * nginx * mysql * php-fpm
Tools
$ yum install git tree httpd-tools
$ yum install ImageMagick
Add repos
$ wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
$ wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm