denihida1216

copy file local to server
scp /nama_folder_lokal/backup.sql [email protected]:/nama_folder/

copy file server to local
scp [email protected]:/nama_folder/backup.sql  /nama_folder_lokal/

backup db mysql
docker exec -i mysql mysqldump -u root -p --skip-set-charset nama_database > backup.sql

restore db mysql

denihida1216

#!/bin/bash
set -e

echo "=== Update sistem ==="
apt-get update && apt-get upgrade -y

echo "=== Install paket pendukung ==="
apt-get install -y ca-certificates curl gnupg lsb-release

echo "=== Tambahkan Docker GPG key ==="

denihida1216

passwd
sudo nano /etc/ssh/sshd_config
PubkeyAuthentication no
PasswordAuthentication yes
ChallengeResponseAuthentication no
PermitRootLogin yes
sudo systemctl restart ssh

denihida1216

sudo rm -rf /usr/local/bin/npm /usr/local/share/man/man1/node* ~/.npm
sudo rm -rf /usr/local/lib/node*
sudo rm -rf /usr/local/bin/node*
sudo rm -rf /usr/local/include/node*
sudo apt-get purge nodejs npm
sudo apt autoremove
sudo apt-get install nodejs npm
sudo apt install -y npm
sudo npm install -g n
sudo n stable

denihida1216

# note 
# enp0s3 = match the label in the netplan ip configuration

sudo ufw allow in on enp0s3 to any port 4369

denihida1216

PHP-FPM Configuration (php-fpm.conf or www.conf):
location /etc/php/7.4/fpm/pool.d/www.conf

pm.max_children = 50
pm.start_servers = 5
pm.min_spare_servers = 5
pm.max_spare_servers = 35
pm.process_idle_timeout = 10s
pm.max_requests = 500

denihida1216

PHP Intelephense
Laravel Blade formatter
Laravel blade snippets
Laravel Extra Intellisense / Laravel intellisense
Laravel goto view
Laravel goto controller
Path Intellisense
Auto Rename Tag
Atom One Dark Theme
One Dark Pro

denihida1216

Delete largon/data/mysql-8
cd to laragon/bin/mysql8.0.0.x/bin folder via cmder (important for step 3)
run 'mysqld --initialize --console' (remember the password)
run 'start mysqld'
run 'mysql -u root -p'
put in the password from 3.
You are now in mysql shell and can remove the password again: "ALTER USER 'root'@'localhost' IDENTIFIED BY '';"
run 'exit' and ctrl + c the spawned tab from step 4.

denihida1216

Auto Rename Tag
css peak
Git Graph
indent-rainbow
IntelliSense for CSS
Live Server
Bracket Pair Colorization Toggler
One Dark Pro
PHP Intelephense
Prettier - Code formatter

denihida1216

dbcc checkdb (sirs) with no_infomsgs, all_errormsgs
https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver16