# see also https://adrhc.go.ro/wordpress/mysql-command-line/ #CREATE SYSTEM DB (first step and mandatory before using mysql) export SRVPATH=/ffp/opt/srv mkdir -p $SRVPATH/mysql/innodb/ mkdir -p $SRVPATH/mysql/innodblogdir/ mkdir -p $SRVPATH/mysql/binlog/ mkdir -p $SRVPATH/mysql/log/ mkdir -p $SRVPATH/mysql/tmp/ mkdir -p $SRVPATH/mysql/data cd /ffp # use your my.cnf […]
Commands
Common steps/commands when building/compiling
# These settings are (make sense) for NSA310 storage box with Fonz Fun Plug (FFP). # see also https://adrhc.go.ro/wordpress/configure-command-for-building-various-software/ export CFLAGS=”-march=armv5te -mfloat-abi=soft -mabi=aapcs-linux -fno-stack-protector -pthread -O2 -Wall -Wno-error” export BUILD_FLAGS=”$CFLAGS -I/ffp/include” unset LIBS export LDFLAGS=”-L/ffp/lib” export CPPFLAGS=”$BUILD_FLAGS” export CXXFLAGS=”$BUILD_FLAGS” NEW_BUILD_NAME=mpc […]
Recursively remove all empty or almost empty directories
find /i-data/md0/video/ -type d -empty -delete # print files/directories with size less 1M: cd /********/Videos/couchpotato-complete du -sh * | grep -P “\d+K” | awk ‘{for (i=2; i<NF; i++) printf $i ” “; print $NF}’ | sort du -sh * | […]
Linux commands
prints current path pwd network traffic info: #processes using 80 and 443 ports netstat -tulpn | grep -P “:80|443” sudo nmap localhost sudo nmap -T4 -A -v localhost download with curl curl -L -k https://ghost.org/zip/ghost-latest.zip -o ghost.zip scan/checks USB harddisk: […]
Linux uname command
Find linux version uname -a Linux nsa310 2.6.31.8 2 Wed Mar 27 16:43:46 CST 2013 armv5tel GNU/Linux
Linux ps command
Listeaza procesele ce in comanda de start a lor cuprind cuvantul polipo: ps -C polipo -o pid,pcpu,pmem,rss,state,stat,start,time,nlwp,args ps -C stunnel -o pid,pcpu,pmem,rss,state,stat,start,time,nlwp,args ps -C java -o pid,pcpu,pmem,rss,state,stat,start,time,nlwp,cmd ps -C httpd -o pid,pcpu,pmem,rss,state,stat,start,time,nlwp,cmd ps -C php-cgi -o pid,pcpu,pmem,rss,state,stat,start,time,nlwp,cmd Listeaza procesele userului […]
dos2unix
Conversie dos -> unix recursiva: find . -type f -name “*.sh” -exec dos2unix {} \; Compilare dos2unix: “ENABLE_NLS=” -> inseamna ca se dezactiveaza NLS (altfel pur si simplu nu gaseste ceva de libintl) make prefix=/ffp ENABLE_NLS=
Mysql command line
# connecting to exifweb database: mysql -u exifweb -p use exifweb insert into AppConfig values (null, ‘false’, ‘cpu summary: use sum on ps aux command’, now()); exit or CTRL+D # https://dev.mysql.com/doc/mysql-utilities/1.6/en/mysql-utils-intro-connspec-mylogin.cnf.html # avoid warning for commands like: mysql -u root […]
Compiling findutils
mkdir -p ~/temp/findutils make install DESTDIR=/ffp/home/gigi/temp/findutils/ cd ~/temp/findutils rm /tmp/findutils-4.5.15-arm-1.txz #makepkg findutils version buildnumber makepkg findutils 4.5.15 1 cp /tmp/findutils-4.5.15-arm-1.txz /usr/local/zy-pkgs/gui/ffp_0.7_armv5
How To Decompress Linux Archive Files
# extract archive: unrar e rar-archive.rar unzip sqlite-amalgamation-3071501.zip unzip -uo ghost.zip -d ghost -> extract ghost.zip to ghost tar xvzf mkvtoolnix-6.5.0-arm-1.tgz tar xvzf mkvtoolnix-6.5.0-arm-1.tar.gz tar xvzf ffp_0.7_arm_003.zpkg tar xvfp wget-1.16.tar.xz tar xvfJ archive.txz tar jxf libebml-1.3.0.tar.bz2 gzip -cd aria2c.1.gz > […]
Copy/extract iso
mount -o loop X-Men.Days.of.Future.Past.2014.NTSC.DVDR.Ro-playON.iso /mnt/iso #nohup cp -R /mnt/iso/* /i-data/md0/video/filelist9/X-Men.Days.of.Future.Past.2014.NTSC.DVDR.Ro-playON/ & umount /mnt/iso