Skip to content

Instantly share code, notes, and snippets.

View DavFount's full-sized avatar

Davidalen Fountain DavFount

View GitHub Profile
@DavFount
DavFount / AutoDBBackup.ps1
Last active February 23, 2025 21:30
Auto-Backup MariaDB Database (Windows)
param(
[Parameter(Mandatory, HelpMessage = 'Path to Maria DB Installation. C:\Program Files\MariaDB 10.9')]
[string]$SQLPath,
[Parameter(Mandatory, HelpMessage = 'Location to store backups. C:\DBServerBackups')]
[string]$BackupDirectory,
[Parameter(Mandatory, HelpMessage = 'SQL User with access to your DB.')]
[string]$User,
[Parameter(Mandatory, HelpMessage = 'Password for the SQL User.')]
[string]$Pass,
[Parameter(HelpMessage = 'Port Number for your SQL Instance. Default: 3306')]
@DavFount
DavFount / UploadCSVToMongoDB.py
Last active October 24, 2019 17:42
Versions Used during testing: pymongo - 3.9.0 Python- 3.7.3
import csv
import time
import tkinter as tk
from os import path
from tkinter import filedialog, END
from pymongo import MongoClient
uri = "mongodb://user:password@host/db?authSource=authdb"
client = MongoClient(uri)