docker-sql-dump-restore

function dumpdb()
{
    # source https://stackoverflow.com/a/46042938/2223106
    # source https://gist.github.com/spalladino/6d981f7b33f6e0afe6bb
    local wkdir=`basename $PWD`
    local container='echo ${wkdir}_my-wpdb_1'
    docker exec ${container} mysqldump -uroot --password=password wordpress > backup.sql
}

function restoredb()
{
    # source: https://unix.stackexchange.com/a/390365/68860
    local wkdir=`basename $PWD`
    local container="${wkdir}_my-wpdb_1"
    cat backup.sql | docker exec -i ${container} /usr/bin/mysql -u root --password=dockerpass wordpress
}