> `mysqldump --databases db1 db2 db3 db4 > backup.sql``` > mysqldump --all-databases > backup.sql If you get an error that says : Got a packet bigger than ‘max_allowed_packet’ bytes then increase your max allowed packet either in my.cnf or in mysql shell mysql>set global max_allowed_packet=200*1024*