01 Oct 2006

Support Center » Guides & Tutorials » Database Backup Guide

Database Backup Guide Domains are deactivated automatically  by Plesk during the backup process and it appears that more often than not Plesk does not reactivate the domains when the backups are finished resulting in clients finding their domains offline and inaccessible. If you are finding your domain is offline for any reason please contact support to have it reactivated, this bug is currently out of our control, the only alternative we can recommend is to use the code below which will allow you to safely and reliably backup your critical databases. Unfortunately, this option does not backup your domain data, files etc. For an easy way to backup your databases daily and safely, please see the following CRON script below: /usr/bin/mysqldump --opt --host=localhost --user=db_user --password=db_pass db_name | gzip -c > /home/httpd/vhosts/domain.com/private/backup.sql Ensure you replace the above command aspects with the correct database name, user and password. You can also restore the backup with PHPMyAdmin. This will create a gzipped sql file in the private directory of the domain. Minute: 0 Hour: 6 Day of the Month: * Month: * Day of the Week: * That will back it up daily at 6am server time.  Back  Login [Lost Password]  Email: Password: Remember Me:    Subscribe  Search -- Entire Support Site -- Knowledgebase Downloads Troubleshooter

Home | Register | Submit a Ticket | Knowledgebase | Troubleshooter | News | Downloads | Guides & Tutorials | Network Status | Policies | Back to NetspaceOnline.net Language: English (U.S.)

Help Desk Software By Kayako SupportSuite v3.00.90