You are here

Home » API reference » Database Administration 7

README.txt in Database Administration 7

Same filename and directory in other branches
  1. 5 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) '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:
--------
 - Can list all tables in your default database
 - Can view data from one or more tables
 - Generates annotated mysqlreport output for MySQL databases
 - Generates limited annotated sql report output for PostgreSQL databases
 - Can export data from one ore more tables into any of the following formats:
    o CSV
    o HTML
    o mysqldump (only works with MySQL databases)
    o OpenOffice Spreadsheet
    o OpenOffice Document
    o Microsoft Excel
    o Microsoft Word
 - Can truncate one or more tables
 - Fully supports MySQL, PostgreSQL and SQLite
 - Drush integration
    o drush dba-sqlreport: displays sqlreport output (ie mysqlreport)


Installation and configuration:
------------------------------
Copy the module into the appropriate modules subdirectory and enable it.

Credits:
-------
 - Written and maintained by Jeremy Andrews <jeremy@kerneltrap.org>
 - Pre Drupal-7 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) '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.  - Can list all tables in your default database

  16.  - Can view data from one or more tables

  17.  - Generates annotated mysqlreport output for MySQL databases

  18.  - Generates limited annotated sql report output for PostgreSQL databases

  19.  - Can export data from one ore more tables into any of the following formats:

  20.     o CSV

  21.     o HTML

  22.     o mysqldump (only works with MySQL databases)

  23.     o OpenOffice Spreadsheet

  24.     o OpenOffice Document

  25.     o Microsoft Excel

  26.     o Microsoft Word

  27.  - Can truncate one or more tables

  28.  - Fully supports MySQL, PostgreSQL and SQLite

  29.  - Drush integration

  30.     o drush dba-sqlreport: displays sqlreport output (ie mysqlreport)

  31. 

  32. 

  33. Installation and configuration:

  34. ------------------------------

  35. Copy the module into the appropriate modules subdirectory and enable it.

  36. 

  37. Credits:

  38. -------

  39.  - Written and maintained by Jeremy Andrews 

  40.  - Pre Drupal-7 PostgreSQL support provided by AAM 

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