Frequently Asked Question
How does the "Backup DB" work
Last Updated 3 days ago
The backup DB makes a backup copy of the database that is stored on your website. You may download this copy to your computer or your cloud account. It will also "optimize" the database. This process reorganizes the physical storage of table data and associated index data, aiming to reduce storage space and improve I/O efficiency.
We wrote this PHP script so that our clients may perform this without going into the control panel and phpMyAdmin. It will do this to every table in the database.
For most clients, this process is done manually though your MyAdmin area on a page, usually named Backup DB. We can also set this up to automatically happen on a schedule of your choosing. i.e., monthly, weekly, daily, every four hours, etc., though this is typically not needed for many situations.
Another option is to alter the file naming schema to include the date (also hour, minutes, and second). This provides additional protection for errors not seen within the normal backup schedule. We recommend having us also limit these to no more than 3-5 backups as depending on your database size, this can add up to storage overusage.
Keep in mind that SWD servers also do backups.
The Notches server does a backup daily and is sent to the cloud. You can also create individual backups of your subscription, which includes databases, by visiting your control panel. These can be done on a schedule and also sent to a remote storage, including a Google Drive, Amazon S3 backups, and any Ftp or SFTP resource.
The SWD server does a monthly backup, currently stored on the server (typical). We are working on sending a copy to the cloud as well. Your account can also create a full backup, for moving to another server, or, restore a partial backup, such as databases only. Backups are created on the first of the month.
When a SWD team member works on your account, we will often back up and download your database. We may keep multiple copies of your database. We recommend that you back up your database at least once a month, or before you do a lot of work on it. You may want to rename the backup to include the date of the backup.
If you wish to discuss backing up your databases, and create a strategy that makes sense for you, please let us know.
We wrote this PHP script so that our clients may perform this without going into the control panel and phpMyAdmin. It will do this to every table in the database.
For most clients, this process is done manually though your MyAdmin area on a page, usually named Backup DB. We can also set this up to automatically happen on a schedule of your choosing. i.e., monthly, weekly, daily, every four hours, etc., though this is typically not needed for many situations.
Another option is to alter the file naming schema to include the date (also hour, minutes, and second). This provides additional protection for errors not seen within the normal backup schedule. We recommend having us also limit these to no more than 3-5 backups as depending on your database size, this can add up to storage overusage.
Keep in mind that SWD servers also do backups.
The Notches server does a backup daily and is sent to the cloud. You can also create individual backups of your subscription, which includes databases, by visiting your control panel. These can be done on a schedule and also sent to a remote storage, including a Google Drive, Amazon S3 backups, and any Ftp or SFTP resource.
The SWD server does a monthly backup, currently stored on the server (typical). We are working on sending a copy to the cloud as well. Your account can also create a full backup, for moving to another server, or, restore a partial backup, such as databases only. Backups are created on the first of the month.
When a SWD team member works on your account, we will often back up and download your database. We may keep multiple copies of your database. We recommend that you back up your database at least once a month, or before you do a lot of work on it. You may want to rename the backup to include the date of the backup.
If you wish to discuss backing up your databases, and create a strategy that makes sense for you, please let us know.