jorgehs91

# Get regular database gziped
mysqldump -h <database host> --user=<database username> --password=<password> --single-transaction <database name>  | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | gzip > /tmp/database_no-definer.sql.gz

# Restore regular database gziped
zcat /tmp/database.sql.gz | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | mysql -h <database_host> -u <username> -p <password> <database_name>

# Get database from docker container
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

# Restore database to docker container

jorgehs91

<VirtualHost *:80>
    ServerName magento2.dev

    SetEnv MAGE_RUN_CODE "base"
    SetEnv MAGE_RUN_TYPE "website"

    DocumentRoot "/var/www/html/magento2.dev/pub"
    <Directory "/var/www/html/magento2.dev/pub">
        AllowOverride All
        Order Allow,Deny