Back up MySQL Databases in Linux

I am the administrator of a small and medium-sized Linux website. The system architecture is RHEL 4.0 + PHP 4.3 + Mysql 4.03 + Apache 1.23. The average daily IP Access volume is 200, a typical small Linux website. Because it is a small website, there is no cost to use a tape drive for system backup, using a DVD Disc recorder + network hard disk. As Linux is widely used, especially in network applications, a large number of network servers use Linux operating systems. Because there are still some differences between Linux desktop applications and Windows, in enterprise applications, Linux and Windows operating systems often coexist to form a heterogeneous network. Most servers use Linux and Unix, while Windows 9X/2000/XP is used on PC.


I. local backup

Using mysqldump for backup is very simple. to back up the database "phpbb_db_backup", run the following command:
# Mysqldump-u-p phpbb_db_backup>/usr/backups/mysql/phpbb_db_backup.2005.5.6
You can also use the gzip command to compress the backup file:
# Mysqldump phpbb_db_backup | gzip>/usr/backups/mysql/phpbb_db_backup.2005.5.6. Gz
Run the following command to restore data:
# Mysql-u-p phpbb_db_back </usr/backups/mysql/phpbb_db_backup.2005-5-6

1 2 3 Next Page

[Content navigation]
Page 1: local backup	Page 1: Back up data to a DVD Disk
Page 1: Network Backup