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

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

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

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

kelsS

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

kelsS

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

kelsS

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