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 -u root -p --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.




Fedora 6 and Red Hat Enterprise Linux Bible
Fedora 6 and Red Hat Enterprise Linux Bible
ISBN: 047008278X
EAN: 2147483647
Year: 2007
Pages: 279

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net