spalladino

# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

fevangelou

# === Optimized my.cnf configuration for MySQL/MariaDB (on cPanel/WHM servers) ===
#
# by Fotis Evangelou, developer of Engintron (engintron.com)
#
# ~ Updated September 2024 ~
#
#
# The settings provided below are a starting point for a 8-16 GB RAM server with 4-8 CPU cores.
# If you have different resources available you should adjust accordingly to save CPU, RAM & disk I/O usage.
#

molotovbliss

Source: https://dba.stackexchange.com/questions/83125/mysql-any-way-to-import-a-huge-32-gb-sql-dump-faster

innodb_buffer_pool_size = 4G
innodb_log_buffer_size = 256M
innodb_log_file_size = 1G
innodb_write_io_threads = 16
innodb_flush_log_at_trx_commit = 0
Why these settings ?

innodb_buffer_pool_size will cache frequently read data

nunomorgadinho

# adduser nginx
adduser nginx

# Install linux update, followed by GCC and Make
sudo yum -y update
sudo yum install -y gcc make

# Install Nginx and PHP-FPM
sudo yum install -y nginx php56-fpm

jsonUK

#!/bin/bash
#
# USE FOR LOCAL DEVELOPMENT ONLY!!!
# 
EMAIL='[email protected]'
MYSQL=`which mysql`

echo -n "DB user/name for project (lowercase) [ENTER]:"
read DB

fgilio

/*
 * Handling Errors using async/await
 * Has to be used inside an async function
 */
try {
    const response = await axios.get('https://your.site/api/v1/bla/ble/bli');
    // Success 🎉
    console.log(response);
} catch (error) {
    // Error 😨

jessfraz

# Description: Boxstarter Script
# Author: Jess Frazelle <[email protected]>
# Last Updated: 2017-09-11
#
# Install boxstarter:
# 	. { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# Run this boxstarter by calling the following from an **elevated** command-prompt:

timvisee

Falsehoods programmers believe about time

This is a compiled list of falsehoods programmers tend to believe about working with time.

Don't re-invent a date time library yourself. If you think you understand everything about time, you're probably doing it wrong.

Falsehoods

• There are always 24 hours in a day.
• February is always 28 days long.
• Any 24-hour period will always begin and end in the same day (or week, or month).

loilo

This is about how to split a GitHub pull request, following a real in-the-wild example.

So it happened that I once wanted to fix a bug (#832) on the shelljs repository.

I forked the repository, cloned it and created a new branch called ln-directory-dest. I fixed the bug, created a pull request, and implemented initial review feedback.

At this point, I had added the commits A, B, C, D, E and [F](https://github.com/Loilo/shelljs/commit/946ab48bf5cf9c8aac03407

bikubi

Why

1. Sage doesn't come with Purgecss (or uncss, etc.)
2. Say, we use Bulma -- suddenly dist/main.css grows by 400K!
3. Let's purge it!
4. Oh dang, we need to whitelist /\.wp-/, /\.post-type/, /myfancylightbox/...
5. Wait we are whitelisting pretty much everything from /resource/assets/styles!
6. Isn't there an option to purge /node_modules/**/* only?
7. Nope.
8. purgecss start ignore, strategically placed, to the rescue!