Skip to content

Instantly share code, notes, and snippets.

View erdeidaniel's full-sized avatar

Erdei Dániel erdeidaniel

1 follower · 5 following
View GitHub Profile
@erdeidaniel
erdeidaniel / MySQL dump script without definer.md
Last active March 6, 2023 20:21
MySQL Dump

MysSQL dump with table, view, functions, triggers, data. Sed out the CREATE DEFINER command.

#!/bin/bash
if [ -z "$1" ]; then echo "usage: $(basename $0) [options] <db>"; exit 1; fi
mysqldump \
    --default-character-set=utf8mb4 \
    --add-drop-table \
    --complete-insert \
 --create-options \
@erdeidaniel
erdeidaniel / MySql-5.6-installation guide.md
Created March 4, 2023 15:56 — forked from vinodpandey/MySql-5.6-installation guide.md
Install MySQL 5.6.xx on Ubuntu 18.04 & Ubuntu 20.04

MySQL Download URL

https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz

Open the terminal and follow along:

  • Uninstall any existing version of MySQL
sudo rm /var/lib/mysql/ -R