How to import or export MySQL database with command line.

This is also useful when working with big databases.

Export database info file
Export database into compressed file to save space
Export database into compressed file with date name to save space
Import database

Import compressed database .gz file

*If you want to export file in a particular folder you should first get in the folder and then run the export command using cd folder.

If you want to get the file from one server to another server then you should put the file to a public folder to the source server and just run the following command from the destination server.