142 CHAPTER 4 ADDING CONTRIBUTED MODULES Database (Medical web site)
142 CHAPTER 4 ADDING CONTRIBUTED MODULES Database Administration Module Permissions To quote from the module s documentation: If a user is granted (or manages to acquire) dba administer database permissions, they are able to directly alter the database. At minimum, they are able to modify data, and possibly to drop tables. Depending on how you have defined your database permissions, the user may also be able to modify other databases unrelated to your Drupal installation. Use at your own risk! Clearly, the Dba Administer Database permission is not to be granted lightly. The second permission that this module defines is Dba View Database, which allows users possessing it the chance to see the contents of the entire database. This includes user e-mail, the encrypted hash of user passwords, any private profile information, and so forth. Judicious use of this module and sparing grants of these two permissions are advised. Automatic Database Backups To configure the dba module, navigate to administer . settings . dba (admin/settings/dba). One of the useful features of this module is the ability to make backup SQL dumps of your database, and it can mail these backups to your e-mail address. Dumps can be made from individual tables, in which case, the backup filename will bear the name of the table, or of several tables or even the entire database. The following are settings that pertain to database backups: Default backup filename: In the case of multiple tables, the name of the backup file is initially taken from this field, although this can be changed at the time you initiate the backup. Automatically backup database every (period of time): The automatic backups are disabled by default, but if you set this field to any of the given time periods, backups will be made as often as you have specified. Automatic backup path: This is the path to the directory on your server where the backups will be saved. Backups are not automatically deleted, so this is a cleanup task that will be left to you. Compress automatic backups: If compression libraries are available to PHP on your server, you can check this option, and backups will arrived in a compressed format, greatly reducing the size of the backup files. Mail backup to administrator: Checking this option will result in the automatic database backups being mailed to the administrator s e-mail account (as defined on the site settings page, admin/settings). Database Integrity Checks The dba module, when used with the MySQL database, allows you to check the data integrity of your database. This is useful for routine maintenance as well as diagnosing problems. The Default Check Type field lets you tell MySQL which type of check to make. Here are the various
Note: In case you are looking for affordable and reliable webhost to host and run your business application check Vision ftp web hosting services