Backing up Databases

You can use the mysqldump command to back up your MySQL databases. The following command backs up all your MySQL databases.

 # mysqldump --opt --all-databases > /root/all-databases 

In this case, all databases on the local system are copied to the file all-databases in the root directory. You can also use mysqldump to back up a single database, several databases, or tables within a database. Refer to the mysqldump man page for further information.

Red Hat Fedora Linux 3 Bible
Red Hat Fedora Linux 3 Bible
ISBN: 0764578723
EAN: 2147483647
Year: 2005
Pages: 286 © 2008-2017.
If you may any questions please contact us: