mysqldump

warning: Creating default object from empty value in /home/uo3mew6y2886/public_html/modules/taxonomy/taxonomy.pages.inc on line 33.

MySQLDump Script Snippets

The following are three script snippets to use for database backup procedures:

MySQL Dump Command

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.

Syndicate content