You are here

Home » API reference » Database Administration 5

README.txt in Database Administration 5

Same filename and directory in other branches
  1. 7 README.txt
Overview:
--------
The dba module provides Drupal administrators with direct access to their
Drupal database tables from within the standard Drupal user interface.

WARNING:  If a user is granted (or manages to aquire) 'dba adminster 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!


Features:
--------
 - support for MySQL and PostgreSQL
 - ability to execute sql scripts and see the resulting output
 - overview listing all tables and total row counts for each
 - ability to backup one or more tables from database
 - ability to view table data
 - ability to view table description
 - ability to delete all data from one ore more tables
 - ability to edit a specific row (using simple form)
 - ability to delete a specific row
 - in MySQL, ability to check and repair one or more tables
 - two permissions: 'dba view database' and 'dba administer database'


Comments:
--------
The ability to edit or delete a specific row will only be available if the
given table has a primary key.  If the table does not have a primary key,
we can't safely modify a single row, so the options are not available.
Examples of tables that don't have a primary key include: accesslog, blocks,
filters and search_index.

Installation and configuration:
------------------------------
Installation is as simple as copying the module into your 'modules' directory,
then enabling the module at 'administer >> modules'.  If using a MySQL database,
you can optionally configure default values for the check and repair
functionality at 'adminsiter >> settings >> dba'.

If using a PEAR database (only PostgreSQL is supported at this time), you will
need to follow the additional directions found in README.pgsql prior to
enabling this module.


Credits:
-------
 - Written by Jeremy Andrews <jeremy@kerneltrap.org>
 - PostgreSQL support provided by AAM <aam@ugpl.de>
 - Co-maintained for a while by Derek Wright [http://drupal.org/user/46549]

File

README.txt
View source 
  1. Overview:

  2. --------

  3. The dba module provides Drupal administrators with direct access to their

  4. Drupal database tables from within the standard Drupal user interface.

  5. 

  6. WARNING:  If a user is granted (or manages to aquire) 'dba adminster database'

  7. permissions, they are able to directly alter the database.  At minimum, they

  8. are able to modify data, and possibly to drop tables.  Depending on how you

  9. have defined your database permissions, the user may also be able to modify

  10. other databases unrelated to your Drupal installation.  Use at your own risk!

  11. 

  12. 

  13. Features:

  14. --------

  15.  - support for MySQL and PostgreSQL

  16.  - ability to execute sql scripts and see the resulting output

  17.  - overview listing all tables and total row counts for each

  18.  - ability to backup one or more tables from database

  19.  - ability to view table data

  20.  - ability to view table description

  21.  - ability to delete all data from one ore more tables

  22.  - ability to edit a specific row (using simple form)

  23.  - ability to delete a specific row

  24.  - in MySQL, ability to check and repair one or more tables

  25.  - two permissions: 'dba view database' and 'dba administer database'

  26. 

  27. 

  28. Comments:

  29. --------

  30. The ability to edit or delete a specific row will only be available if the

  31. given table has a primary key.  If the table does not have a primary key,

  32. we can't safely modify a single row, so the options are not available.

  33. Examples of tables that don't have a primary key include: accesslog, blocks,

  34. filters and search_index.

  35. 

  36. Installation and configuration:

  37. ------------------------------

  38. Installation is as simple as copying the module into your 'modules' directory,

  39. then enabling the module at 'administer >> modules'.  If using a MySQL database,

  40. you can optionally configure default values for the check and repair

  41. functionality at 'adminsiter >> settings >> dba'.

  42. 

  43. If using a PEAR database (only PostgreSQL is supported at this time), you will

  44. need to follow the additional directions found in README.pgsql prior to

  45. enabling this module.

  46. 

  47. 

  48. Credits:

  49. -------

  50.  - Written by Jeremy Andrews 

  51.  - PostgreSQL support provided by AAM 

  52.  - Co-maintained for a while by Derek Wright [http://drupal.org/user/46549]