Skip to content

Instantly share code, notes, and snippets.

View erpriyanktrivedi's full-sized avatar

Priyank Trivedi erpriyanktrivedi

2 followers · 5 following
View GitHub Profile
@erpriyanktrivedi
erpriyanktrivedi / import-sql.md
Created April 27, 2023 12:29 — forked from ankurk91/import-sql.md
MySQL/Postgresql: Import database via command line

Import large database to MySql ⚡

cd /path/to/backups
mysql -u root -h 127.0.0.1 -p --default-character-set=utf8
# Switch to database 
USE database_name;
@erpriyanktrivedi
erpriyanktrivedi / install_lamp_ubuntu.sh
Created April 27, 2023 12:27 — forked from ankurk91/install_lamp_ubuntu.sh
Ubuntu 22 - PHP development (php 7.4 / 8.2, apache 2.4)
#!/bin/bash
set -euo pipefail
IFS=$'\n\t'
# Ubuntu 20/22 dev Server
# Run like (without sudo) - bash install_lamp.sh
# Script should auto terminate on errors
export DEBIAN_FRONTEND=noninteractive