Kevin Shenk batonac
batonac
/ z_aiops_mysql.cnf
Last active
May 5, 2022 15:26
mysql configuration for zfs inside linux virtual server on runcloud proxmox with 128 MB ram limit
This file contains 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
| [mysqld] | |
| bulk_insert_buffer_size = 8388608 | |
| character-set-client-handshake = FALSE | |
| character-set-server = utf8mb4 | |
| collation-server = utf8mb4_unicode_ci | |
| innodb_buffer_pool_chunk_size = 67108864 | |
| innodb_buffer_pool_size = 67108864 | |
| innodb_checksum_algorithm = full_crc32 | |
| innodb_doublewrite = 0 | |
| innodb_file_per_table = 1 |
batonac
/ wp_normalize.ps1
Last active
June 5, 2023 19:33
Normalize WordPress Post Meta using PowerShell and CSV inputs
This file contains 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
| # Import the CSV files | |
| $posts_table = Import-Csv -Path "wp_posts.csv" | Group-Object -AsHashTable -Property 'ID' | |
| $postmeta_table = Import-Csv -Path "wp_postmeta.csv" | Group-Object -Property 'post_id' | |
| $relationships_table = Import-Csv -Path "wp_mb_relationships.csv" | Group-Object -Property 'from' | |
| # remove subdirectory "Posts" if it exists | |
| if (Test-Path ".\Posts") { | |
| Remove-Item -Path ".\Posts" -Recurse | |
| } |
batonac
/ wp_normalize_mb.ps1
Last active
June 5, 2023 19:33
Normalize WordPress Post Meta and Metabox Relationships using PowerShell and CSV inputs
This file contains 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
| # Import the CSV files | |
| $posts_table = Import-Csv -Path "wp_posts.csv" | Group-Object -AsHashTable -Property 'ID' | |
| $postmeta_table = Import-Csv -Path "wp_postmeta.csv" | Group-Object -Property 'post_id' | |
| $relationships_table = Import-Csv -Path "wp_mb_relationships.csv" | Group-Object -Property 'from' | |
| # remove subdirectory "Posts" if it exists | |
| if (Test-Path ".\Posts") { | |
| Remove-Item -Path ".\Posts" -Recurse | |
| } |
This file contains 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: Media Deduper Pro CLI | |
| Plugin URI: https://avu.nu/ | |
| Description: Provides WP-CLI commands for Media Deduper Pro. | |
| Version: 1.0 | |
| Author: Avunu LLC | |
| Author URI: https://avu.nu/ | |
| */ |
This file contains 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
| { autoPatchelfHook | |
| , curl | |
| , dotnet-runtime | |
| , dotnet-sdk | |
| , dpkg | |
| , fetchurl | |
| , gtk3 | |
| , icu | |
| , krb5 | |
| , lib |
This file contains 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
| let | |
| pkgs = import <nixpkgs> {}; | |
| in | |
| pkgs.callPackage ./naps2.nix {} |