MySQL Dump Command

warning: Cannot modify header information - headers already sent by (output started at /home/content/12/9797512/html/index.php:4) in /home/content/12/9797512/html/includes/common.inc on line 153.

To back up a big MySQL server use the following on the command line:

 mysqldump --all-databases --add-drop-table -c -u -p | bzip2 -c > .bak.sql.bz2

It will use mysqldump and it will compress the sql file. You will backup the entire server with this command.