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 space
mysqldump DATABASE-NAME | gzip > "FILE-NAME_`date +%e_%b_%Y`.sql.gz"
Import database
mysql DATABASE-NAME < FILE-NAME.sql
mysql mojtest_test1 < mojtest_test1.sql
Import compressed database .gz file
gunzip FILE-NAME.sql.gz
mysql DATABASE-NAME < FILE-NAME.sql
mysql mojtest_test1 < mojtest_test1.sql
*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.
wget https://domain.com/backup.tar.gz
