I always make backup using "backup and migrate" module. But now, need to automate this process using scripts.
When execute backup using "backup and migrate" this module generate .mysql file with approximately 3.3 MB(compacted) and 9MB(uncompacted) , but using the following script command, file have 17MB(compacted) and 53MB+(uncompacted) and .sql extension.
mysqldump -u user_mysql -pMY_PASS --databases my_database | gzip > /home/my_user/my_docs/database.sql.gz
How generate ".mysql" extension file using "mysqldump"?