[MySQL - Snippets] Snippets, Gists and Scripts for working with MySQL #database

README.md

MySQL

MySQL Resources

Table of Contents

• Random

Random

• Select Random Rows - Selecting random rows from large tables.

mysql-dump-with-date.sh

#!/usr/bin/env bash
#
# Create a DB dump named with todays date and time.
#

USERNAME=""
DATABASENAME=""

mysqldump -u "$USERNAME" -p "$DATABASE_NAME" > $(date +"%m-%d-%y_%H-%M%p").sql