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