### Prerequisites
1. Install mysql: `scoop install mysql`
1. Add `Local` connection to PHPStorm using local MySQL container.
1. Create new DB in `Local` connection using the following command:
    `CREATE DATABASE local_db;`

### Dump
1. Right click the schema you would like to export
1. Click on *Dump with 'mysqldump'*
1. In the *Path to mysqldump* field, put the following: `C:\dev\shims\mysqldump.exe`
1. Choose desired *Out Path*
1. Append the following flag to the auto-generated command in the text area (only if running MySQL >=5.0):
    `--column-statistics=0`
1. Click Run

### Import Dump
1. Right click on the schema you created earlier in your local DB
1. Click *Restore with 'mysql'*
1. In the *Path to mysql* field, put the following: `C:\dev\shims\mysql.exe`
1. Point to the path of the dumped file
1. Click run and wait for the import to finish