Import / Export MySQL Database (BIG DB)

How to import or export MySQL database with command line. This is also useful when working with big databases. Export database info file mysqldump DATABASE-NAME > FILE-NAME.sql Export database into compressed file to save space mysqldump DATABASE-NAME | gzip FILE-NAME.sql.gz Export database into compressed file with date name to save…