Popular `mysql` terminal commands

Dump a MySQL database into a file

Dump a MySQL database, including its data, into a file.

Export MySQL database schema without exporting its data

Exports a MySQL database schema to a file without exporting its underlying data.

Authored by: Daric

Import a SQL file into a MySQL server

Imports an exported SQL dump into a MySQL server

Authored by: bansi

Import a MySQL dump with progress bar into a MySQL server

Import a mysqldump file into a MySQL server with a progress bar indicating time remaining

Authored by: Rob

Migrate from MySQL Database to PostgresSQL Database

Loads data from the MySQL database, transforms it to PostgreSQL compatible format and uploads it to the PostgreSQL database. Note - it requires pgloader to be installed and both PostgreSQL and MySQL hosts are accessible from the machine running this script.

Authored by: Dipak Parmar

Restore a dump file from a mysqldump

Authored by: Justin Bennett