Wiki Snippets

du -sh /var
du -sh mysql/*
du -sh  .

docker cp test-mysql:/etc/mysql/my.cnf .

docker cp my.cnf test-mysql:/etc/mysql/my.cnf
docker start mysql
docker exec -ti mysql bash

git reset --hard origin/master

FROM debian:jessie
MAINTAINER user@server.com
RUN apt-get update
RUN apt-get install -y vim
RUN apt-get install -y apache2
RUN DEBIAN_FRONTEND=noninteractive apt-get install -y mysql-server
RUN apt-get install -y php5
RUN apt-get install php5-mysql
RUN apt-get autoremove
 
ENV APACHE_RUN_USER www-data
ENV APACHE_RUN_GROUP www-data
ENV APACHE_LOG_DIR /var/log/apache2
ENV APACHE_LOCK_DIR /var/lock/apache2
ENV APACHE_PID_FILE /var/run/apache2.pid
 
EXPOSE 80
# Launch all services
# CMD ["apache2ctl", "-D", "FOREGROUND"]
COPY startup.sh /
RUN chmod 777 /startup.sh
CMD ["bash","/startup.sh"]

cat > startup.sh
#!/bin/bash
 
apache2ctl -D FOREGROUND

docker build -t aghayevcomdockerfile:latest .

REPOSITORY             TAG                 IMAGE ID            CREATED             SIZE
aghayevcomdockerfile   latest          19e27a7ca24b        11 minutes ago      389MB
debian                 jessie              5d7d9c6338e8        3 weeks ago         129MB

docker run -d -t -p 80:80 -p 443:443 -p 3306:3306 -v /home/user/Projects:/home -v /home/user/Servers:/opt --name aghayevcom aghayevcomdockerfile:latest

CONTAINER ID        IMAGE                             COMMAND                  CREATED             STATUS              PORTS                NAMES
8946f43f47ea        aghayevcomdockerfile:version1.0   "bash /startup.sh"   2 minutes ago       Up 2 minutes        0.0.0.0:80->80/tcp   aghayevcom
 
p.s. Pay attention to COMMAND column, it should show which command will run first when u start container. In case of direct call of apache2ctl it shows this
#850703e85940        aghayevcomdockerfile:version1.0   "apache2ctl -D FOREG…"   2 minutes ago       Up 2 minutes        0.0.0.0:80->80/tcp   aghayevcom

docker start aghayevcom
 
p.s. It is possible to start container by direct calling Container ID
# docker start 8946f43f47ea

mkdir ~/remoteDir
ssh-keygen -t rsa
ssh-copy-id -i .ssh/id_rsa.pub user@hostname
sudo apt install sshfs
sshfs user@hostname:/ ~/remoteDir

fusermount -u ~/remoteDir

vi /etc/apt/sources.list

<?php
 
$dbname = 'dbname';
$dbuser = 'user';
$dbpass = 'pass';
$dbhost = 'hostname';
 
$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysql_select_db($dbname) or die("Could not open the db '$dbname'");
$test_query = "SELECT 1,2,3,4 FROM yourtable";
$result = mysql_query($test_query);
$tblCnt = 0;
while($tbl = mysql_fetch_array($result)) {
  $tblCnt++;
  echo $tbl[0]."<br />\n";
  echo $tbl[1]."<br />\n";
  echo $tbl[2]."<br />\n";
  echo $tbl[3]."<br />\n";
}
 
if (!$tblCnt) {
  echo "There are no tables<br />\n";
} else {
  echo "There are $tblCnt tables<br />\n";
}

bg -- Move running process to background --

jobs -- list the jobs in background and get id of the job you want to detach --

disown %1 -- use job id from previous query for detaching from the terminal --

SHOW FULL PROCESSLIST;

function getNearestMatch($number, $candidates) {
 
	$candidates = is_array($candidates) ? $candidates : array($candidates);
 
	$size = count($candidates);
	if ($size > 0) {
		//absolute difference between 0th element and input value
		$diff = abs($candidates[0] - $number);
		//element closest to input value
		$ret = $candidates[0];
		//loop through the rest of the array
		for ($i = 1; $i < $size; $i++) {
			$temp = abs($candidates[$i] - $number);
			if ($temp < $diff) {
				//set new difference and closest element
				$diff = $temp;
				$ret = $candidates[$i];
			}
		}
		return $ret;
	} else {
		return NULL;
	}
 
    }