kelsS

drush @none dl utf8mb4_convert-7.x
drush cache-clear drush

kelsS

drush vset maintenance_mode 1
drush utf8mb4-convert-databases
drush cc all

kelsS

$databases['default']['default'] = array(
  'driver' => 'mysql',
  'database' => 'databasename',
  'username' => 'username',
  'password' => 'password',
  'host' => 'localhost',
  'charset' => 'utf8mb4',
  'collation' => 'utf8mb4_general_ci',
);

kelsS

sudo npm cache clean -f
sudo npm install -g n
sudo n stable
  *or sudo n latest for latest version*

kelsS

echo '#!/bin/bash' > restore.sh
echo sudo apt-get install `grep Remove /var/log/apt/history.log | tail -1 | sed -e 's|Remove: ||g' -e 's|([^)]*)||g' -e 's|:[^ ]* ||g' -e 's|,||g'` >> restore
chmod +x restore 
./restore.sh

kelsS

Create PS profile if it doesn't exist and add module accross all shell sessions

if (-Not (Test-Path $PROFILE)) { New-Item $PROFILE –Type File –Force }

Add-Content $PROFILE "`nImport-Module posh-docker"

Stop Powershell beeping

net stop beep

kelsS

AMPPS MySQL not working, Solution!

1. Open Ampps Application -> MySQL Tab -> Configuration.

2. In [mysqld] section, add the following line: innodb_force_recovery = 1

3. Save the file and try starting MySQL

4. Remove that line which you just added and Save.

kelsS

#!/bin/bash

# Delete all containers
docker container rm $(docker container ps -a -q)
# Delete all containers even running ones
docker container rm -f $(docker container ps -a -q)
# Delete all images
docker rmi $(docker images -q)

kelsS

docker container port container_name

• Shows what port is exposed to the container

docker container inspect --format

• Shows the IP address of the container which by default is different from the host IP
• Using Windows shell you need to replace the single quotes with double quotes
  • i.e.
    • "{{.NetworkSettings.IPAddress}}"
• docker container inspect --format "{{.NetworkSettings.IPAddress}}" container_name

-p or Publish flag for exposing ports

• Publishing ports is always in HOST:CONTAINER format

kelsS

Bootstrap 3/4 Accordions - Prevent default scroll jumping onclick

$('.aClass').click( function(e) { event.preventDefault(); });

• aClass is the class on the accordion anchor link
• Link resource: https://stackoverflow.com/questions/28977499/bootstrap-accordion-how-to-avoid-page-scroll-when-collapse-or-expand-elements