Backing up MySQL database in mysqldump
by Forrest Sheng Bao http://fsbao.net
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.sqlYou will be prompted the password. And then I will using
bzip2 newdrupal-20080614.sql to compress it. All materials on this site does not stand the prospective of Texas Tech University.
Copyleft and Copywrite 1984 -2008 Forrest Sheng Bao Contact me
Except where otherwise noted, Forrest's homepage is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.
Powered by Open Source Technologies Linux, Apache, PHP, MySQL and Drupal
Copyleft and Copywrite 1984 -2008 Forrest Sheng Bao Contact me
Except where otherwise noted, Forrest's homepage is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.
Powered by Open Source Technologies Linux, Apache, PHP, MySQL and Drupal