MySQL Backup and recovery

Excerpt from: Http://safe.it168.com/a2009/1108/805/000000805490.shtml to back up the database "Phpbb_db_backup"

#mysqldump Phpbb_db_backup | gzip >/usr/backups/mysql/phpbb_db_backup.2005.5.6.gz

To restore the database "Phpbb_db_backup"

#mysql –u-p Phpbb_db_backup

Backup via Samba network

The core of Windows network sharing is smb/cifs, where you have to install and use the Samba package if you want to mount a disk share for Windows on Linux. The majority of popular Linux distributions now contain samba packages, and if you install a Linux system without samba, install Samba first. Of course, you can also download Samba packages to the www.samba.org website, which is now the latest version of the 3.0.10 edition. The Windows computer then establishes a directory (/ARC) and shares it, giving it read and write permissions. Also create a backup_share1 directory under the MySQL server/mnt directory and mount it:
# mount-t Smbfs-o username=cjh, password=xxxx//192.168.1.18/arc/mnt/backup_share

Finally, use the command to back up:
# mysqldump Phpbb_db_backup >/mnt/backup_share/phpbb_db_backup.2009-5-6

MySQL Backup and recovery