- Stop mysql server
- Copy contents of datadir to another location on disk (~/mysqldata/*)
- Start mysql server again (downtime was 10-15 minutes)
- compress the data (tar -czvf mysqldata.tar.gz ~/mysqldata)
- copy the compressed file to new server
qutek
/ clear-node-modules.sh
Last active
March 11, 2021 09:46
[Clear Node Modules] Delete all node_modules directory #bash
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # This script will remove all node modules | |
| # | |
| # Author: Lafif Astahdziq | |
| # https://lafif.me | |
| # | |
| FOLDER_ROOT=${1:-.} # default to current directory |
qutek
/ webpack.mix.js
Created
September 16, 2019 15:31
— forked from kellymears/webpack.mix.js
[Gutenberg Webpack Mix] #gutenberg #mix #js
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const mix = require('laravel-mix'); | |
| const url = 'http://lab.tinypixel.test'; | |
| const app = './src'; | |
| const config = './config'; | |
| const resources = './resources'; | |
| const assets = './resources/assets'; | |
| const dist = './dist'; | |
| const externals = { |
qutek
/ .bash_profile
Created
April 16, 2019 18:25
[Custom cd function] Custom bash function to cd in my local server directory with autocomplete
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Use it with `goto project` | |
| goto () { | |
| # cancel if no arguments | |
| if [ -z "$1" ]; then | |
| echo "Mau goto kemana??" | |
| return 0 | |
| fi | |
| local UPPER=$(printf "%s" "$1" | tr '[:lower:]' '[:upper:]'); | |
| local P_DIR="/Users/qutek/LocalServer/_$UPPER"; |
qutek
/ command.md
Created
February 21, 2019 21:15
[Disable Mission Control] Disable mission control / spaces on drag to top of screen #mac
qutek
/ force-login.php
Last active
March 28, 2020 21:16
[ Force Login ] Force login WordPress user without password, use it as plugin or place the code under mu-plugins / wp-config.php ( after `require_once(ABSPATH . 'wp-settings.php');` )
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * Auto login user without password, access with <code>http://domain.com/?force_login=username</code> | |
| * [email protected] | |
| */ | |
| if ( ! defined( 'WP_CLI' ) ) { | |
| function force_login() { | |
| if( !isset($_GET[ 'force_login' ]) || empty( $_GET[ 'force_login' ] ) ) | |
| return; |
qutek
/ instruction.md
Last active
November 7, 2023 12:45
[Install ZeroMQ MAC] Install PHP ZeroMQ MAC #mac #php
qutek
/ debug-email.php
Last active
March 14, 2018 07:31
[Debug Email] Simple script to change all email recipients for debugging / development purpose #wordpress #email #development-tools
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * Plugin Name: Debug Email | |
| * Description: Simple script to change all email recipients for debugging / development purpose | |
| * Version: 0.1 | |
| * Author: Lafif Astahdziq | |
| * Author URI: https://lafif.me | |
| */ | |
| add_action( 'init', 'test_send_email' ); |
qutek
/ calculateStripeFee.js
Created
February 3, 2018 06:20
[Calculate Stripe Fee] Calculate stripe fee to ask customer to cover stripe fee #javascript #stripe
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Calculate stripe fee from amount | |
| * so you can charge stripe fee to customers | |
| * lafif <[email protected]> | |
| */ | |
| var fees = { | |
| USD: { Percent: 2.9, Fixed: 0.30 }, | |
| GBP: { Percent: 2.4, Fixed: 0.20 }, | |
| EUR: { Percent: 2.4, Fixed: 0.24 }, | |
| CAD: { Percent: 2.9, Fixed: 0.30 }, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * Convert object to array | |
| * @param [type] $obj [description] | |
| * @return [type] [description] | |
| */ | |
| function obj_to_array($obj) { | |
| if(!is_array($obj) && !is_object($obj)) | |
| return $obj; | |