Backup the SUBDREAMER database tables as SQL files

Why Importance of Backup? Computers fail. They break down, hard disks fail, memory chips forget. And it always happens an hour before the big meeting! Of course there are other disasters, such as fire, flooding, burglary and lightning strike. The world has it in for your computer. Losing access to your computer can be bad enough, but the computer may take your data with it! You recover the machine to find that your valuable files have been damaged or missing altogether. That's when you realise that you don't have a recent backup of your data. A proper backup strategy is essential, both for business and personal users. Unfortunately it is all to often an area left neglected until after a major incident. This article is all about backup and how to protect your valuable data. How Often? You should back up all of your data at least once a week. Critical data, especially important files that change regularly, should be backed up daily.

How to backup the SUBDREAMER database tables as SQL files?

1. Login to your admin site. http://www.yourdomainname.com/admin

2. Go to Admin ->Database. You can use this tool to backup and maintain your Subdreamer databases. The maintenance commands available are :-
Check - Checks the table for errors
Optimize - Removes any wasted space (as reported in the 'Overhead' column)
Repair - Attempts to recover errors in the table

You can also use this tool to backup your database tables as SQL files which can be used to recover the database in the event of data loss.

3. Tick on the check box beside table name. It will tick all the table name from sd_categories untill sd_vvc.

4. Click on the Backup button after selecting the tables name.

5. You may see the backup files path below the database backups which include the size and last modified. The format is in .sql.gz.