Install/Uninstall

No special measures necessary, follow the standard installation process & extract the module folder into the
\/modules
directory in your XOOPS installation. Install the module through Admin -> System Module -> Modules.
Detailed instructions on installing modules are available in the Chapter 2.12 of our XOOPS Operations Manual

Individual Features

Adminer

  • Connect to a database server with username and password
  • Select an existing database or create a new one
  • List fields, indexes, foreign keys and triggers of table
  • Change name, engine, collation, auto_increment and comment of table
  • Alter name, type, collation, comment and default values of columns
  • Add and drop tables and columns
  • Create, alter, drop and search by indexes including fulltext
  • Create, alter, drop and link lists by foreign keys
  • Create, alter, drop and select from views
  • Create, alter, drop and call stored procedures and functions
  • Create, alter and drop triggers
  • List data in tables with search, aggregate, sort and limit results
  • Insert new records, update and delete the existing ones
  • Supports all data types, blobs through file transfer
  • Execute any SQL command from a text field or a file
  • Export table structure, data, views, routines, databases to SQL or CSV
  • Print database schema connected by foreign keys
  • Show processes and kill them
  • Display users and rights and change them
  • Display variables with links to documentation
  • Manage events and table partitions (MySQL 5.1)
  • Schemas, sequences, user types (PostgreSQL)
  • Extensive customization options

Adminer Editor

  • Interface to select and edit data ready for your client
  • Table and column comments are displayed instead of identifiers
  • Separate set of login credentials different from the real database user and password
  • Single database per one instance of Editor
  • Links to referenced records
  • Works with the name of a referenced record, not its ID
  • Displays images stored in BLOB
  • Displays checkbox and icons for BOOL
  • Uses national format for DATE
  • Allows sending messages to e-mails found in table
  • No edit or display of SQL commands (only in HTML comment)
    BigDump
  • Imports large and very large MySQL Dumps (like phpMyAdmin dumps)
  • Does it even through the web servers with hard runtime limit and those in safe mode.
  • The script imports only a small part of the huge dump and restarts itself. The next session starts where the last was stopped.