You are Here: FAQ ->Applications->MySQL Administration->Article #6


WebHosting 5.0 This article is for 1&1 Linux WebHosting only.


How can I backup my MySQL database using SSH?



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

You can backup your database (dump your database) yourself at any time. Please
follow the 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 login data shown in your Control
Panel.

Once the dump has been completed you will find the outputfile in your webspace.

Note: Not all packages have SSH Access. If you don't have SSH access, then
backup your database using phpMyAdmin.

SA1B1302


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