You are Here: FAQ ->Scripting and Programming Languages->MySQL Database->Article #8


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 restore an individual database.

You can backup your database (dump you database) yourself at any time. Please
follow the the instructions below:

Please log into your shell account via SSH and run this command:
mysqldump --no-create-db=true -hdbxx.perfora.net -udboxxxxxxxx -pxxxxxxxx dbxxxxxxxx > dbxxxxxxxx.dump.yymmdd

If you have a managed server and are connecting to a MySQL 5 database please enter :
mysqldump --no-create-db=true -hdbxx.perfora.net -udboxxxxxxxx -pxxxxxxxx dbxxxxxxxx -S /kunden/tmp/mysql5.sock > dbxxxxxxxx.dump.yymmdd

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.


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