You are Here: FAQ ->Web Space & Access->Secure Shell Access (SSH)->Article #9


How can I backup my MySQL database using SSH?


Our systems automatically backup your database every 24 hours. This backup is a
safeguard in case there is a hardware failure. The backup is of the entire
database server so it is unable restore an individual database.

You can backup your database (dump your database) yourself at any time by following
the instructions below:

1. Please log in to your shell account via SSH and run this command:
mysqldump -hdbxxx.perfora.net -udbo1xxxxxx -pxxxxxx dbxxxxxxxx >outputfile name

Please replace this information with the MySQL log in data shown in your Control
Panel.

Once the dump has been completed you will find the output file in your web space.

SW3B401


Print Article
How useful was this article?
(From 5 = Very Useful to 1 = Not useful at all):
1 2 3 4 5


 © 2008 1&1 Internet Inc - About 1&1 Internet