$ mysqldump -h localhost -u username -p database_name > backup_db.sql
I can use the line above but it is just for one db in the server, can i have a complete backup of the all databases into one backup file?
Or is there some command which serializes this process?
something like below (i added -all which is most probably wrong):
$ mysqldump -u username -h localhost -p -all | gzip -9 > backup_db.sql.gz