Backing up MySQL database in mysqldump

by Forrest Sheng Bao

MySQL official documentation provides two ways to backup. One is mysqldump. Another is mysqlhotcopy. But I don't like mysqlhotcopy since I don't like seeing so many table files. So I like mysqldump, giving me just one sql file.

 mysqldump --user=root -p drupal > newdrupal-20080614.sql

You will be prompted the password. And then I will using bzip2 newdrupal-20080614.sql to compress it.

No comments: