alathaVBO

# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

alathaVBO

CREATE OR REPLACE VIEW table_to_role AS (
    SELECT 
        tables.id as table_id,
        tables.table_name as table_name,
        ab_role.name as role_name
    FROM 
        tables
        LEFT JOIN ab_view_menu ON ab_view_menu.name = tables.perm
            LEFT JOIN ab_permission_view on ab_permission_view.view_menu_id = ab_view_menu.id
                LEFT JOIN ab_permission on ab_permission_view.permission_id = ab_permission.id

alathaVBO

#!/usr/bin/env python
# coding: utf8

# Script to create superset users

import pandas as pd
from sqlalchemy import create_engine
import datetime
import pexpect
import os

alathaVBO

Mysqldump from Docker container

docker exec -i mysql_container mysqldump -uroot -proot --databases database_name --skip-comments > /path/to/my/dump.sql

OBS

• This will generate a dump.sql file in your host machine. Awesome, eh?
• Avoid using --compact on your dump. This will make MySQL check your constraints which will cause troubles when reading your file (damm you MySQL). And don't use --force to fix this scenario: recreate your dump without --compact ¯_(ツ)_/¯