WSN Knowledge Base
Database Backup and Restore
Database Backup and Restore
By Paul

For the 5.1 series and earlier:

In your admin panel, click 'backup database' to reach your database backup and restore options. From this page you can download a current backup, upload an old one, or set an automated backup schedule. If you set an automated schedule, you must CHMOD 777 your admin directory. It will select a random file name and write to that file with the frequency you have told it to. You can stop it from continuing to write automatic backups by returning to the page and clicking the link that appears offering to stop backups.

You can restore a backup through WSN which was made in phpmyadmin, or restore a WSN-generated backup through phpmyadmin.

If backups don't work for you, this means PHP doesn't have permission to execute shell commands (probably it's in safe mode). If this is the case you'll have to use a tool such as phpmyadmin for backups.

Note: if you're trying to duplicate your site in a second location, use the clone utility instead of the backup utility.

For the 6.0 series:

Go to Admin Panel -> Maintenance -> Backups to manage your backups. These are sql database backups, not file backups. If your site doesn't function after rolling back to a database from a day when it did function, that means the database wasn't the problem and you need to overwrite the files instead (download the .tar.gz from the customer downloads area and perform a manual upgrade).

If you can't reach the admin panel due to a database error, check the "backups" subdirectory on your site. You can restore a WSN-generated backup via phpmyadmin or via SSH terminal.

The backups system saves the last couple of days, a week ago, and two weeks ago in order to give you a variety of restore point options. If this takes too much disk space for you, you can set it to save a smaller number of backups. If you set it to save 0, you'll be able to do manual ones but no automatic backups will be generated.

Note: if you're trying to duplicate your site in a second location, use the clone utility instead of the backup utility.

Rating:


2/5 based on 1 vote. The median rating is 2.

Submitted: 09/25/03 (Edited 04/12/10)

Description: Safeguarding your content.

Views: 1841 views. Averaging 1 views per day.
In the most recent 30 day period, there've been 0 views.

Previous Article

Features Showcase Purchase Services Resources Support