- 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
/ 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; | |
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 | |
| /** | |
| * Question #1 | |
| * Scenario: | |
| * 1. We have a list of companies in the Company custom post type. | |
| * 2. Each Company has a ranking which is stored in post meta with a key called `ranking. The ranking is a decimal value between 0 and 100. A sample `ranking` is 94.9. | |
| * 3. Each Company can also be marked as sponsored. If a Company is sponsored, a post meta with a key called `sponsored` is updated to 1. Otherwise, the `sponsored` meta value is `0` for each Company. | |
| * | |
| * Problem: | |
| * Given the above scenario, provide the correct array of $args to pass into a new WP_Query instance so that we can return 100 companies with the "sponsored" companies first, and then after that sorted, from highest to lowest based off the `ranking` value. |