- Database Management

Simple Adminer

Simple Adminer

Free | Database Management | mediahof
3
Score:
96
3 reviews
Our plugin adds Adminer as a quick icon to the admin section, Access is only allowed for Super Administrators. Adminer uses the data from Joomla configuration to log in automatically.
p
Collation and Engine - Changer

Collation and Engine - Changer

Paid download | Database Management | MCTrading
3
Score:
94
2 reviews
This Joomla 2.5 and 3.x plugin changing automatically the Database Collation and Database Character set including all tables and columns. It will also converting tables from MyISAM to InnoDB. The new Joomla 3.5 is designed to work with the UTF8mb4 collation and the InnoDB Engine of MySQL. This collation allows you to use Emoji and other multibyte characters such as certain Traditional Chinese glyphs, Cherokee etc. In this case you need to change the collation to “UTF-8 Multibyte”. Joomla 3.5 is doing this for all the own core tables while upgrading to the newest Joomla Version. But you may need to repeat that step for all the "old" extensions or after installing or upgrading extensions which are using other collation. After installing new extensions you are strongly advised to check this. If an extension involves fields with different collations then this could end in an error like: "Illegal mix of collations". The "Collation and Engine - Changer" can be used to switch the Database Collation and Database Character set including all tables and columns to UTF8mb4 (or to an other collation). It will also converting all tables from MyISAM to InnoDB. In this way you are using the same like Joomla 3.5 is doing for the core tables. All this can be easily done from your Joomla backend. Whenever you have one of these problems: you have to switch from one collation to an other you have to switch from MyISAM to InnoDB you got the error: "Illegal mix of collations" you have to migrate an website from Joomla 2.5 to 3.5 you are using extensions that are not using UTF8mb4 then the CE-Changer is your solution.
p
DB Tweaks

DB Tweaks

Free | Database Management | J-Plant team
3
Score:
93
1 review
The plugin can set sqlbigselects, sqlmaxjoinsize and maxallowed_packet MySQL system variables. It can be useful if some extension(s) on your site need loading large data from a MySQL database and above parameters are set in the way to disable working with large amount of data. *** CHANGELOG *** --- 1.1.0 --- Joomla! 3.0 support
p l
phpMyJoomla

phpMyJoomla

Free | Database Management | Luis Orozco
3
Score:
69
1 review
Manages and exports data bases very easy from the backend of Joomla!.
c
VJ Database Tool

VJ Database Tool

Paid download | Database Management | VJ Tools
3
Score:
60
2 reviews
VJ Database Tool - Comprehensive database management tool for Joomla! TOP FEATURES Multiple database types support VJ Database Tool supports: MySQL, PostgreSQL, SQLite, Oracle, MS SQL. Easily manage databases Manages databases, tables and fields simply through your Joomla! administration panel. All-in-one database tool This tool includes everything you need for an advanced database management through your Joomla! administration panel. Other Notable Features Create, remove, edit databases, tables, fields Creates dumps Multilingual 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 tables Change name, engine, collation, auto-increment, and table comments 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) This is open-source software under GPL license
c
phpMyAdminLink

phpMyAdminLink

Free | Database Management | Emil I Bohach
3
Score:
27
3 reviews
Creates a link, in the admin status area, to your phpMyAdmin program (either local or remote) for quick access without needing to go through the web hosts control panel. 4 steps to implement Set the position of the module to status. Set the URL of your web hosts phpMyAdmin (the default shows how most local phpMyadmin programs are accessed). Determine which users can view/access the links. Publish and save it. Complete documentation on implementation available. The phpMyAdmin link should now appear in the status bar at the top. This module is a fork of the original JooMyAdminLite module for Joomla 1.5 from Matthias Krauser of schwarz.de. I have converted it for Joomla 2.5
m
Optimize Your Tables

Optimize Your Tables

Free | Database Management | Emmanuel Lemor
3
Score:
0
2 reviews
Optimize Your Tables v1.2: A system level plugin for Joomla v1.7, v2.5 and now v3.x that once a day optimizes your database's tables so as to keep your site running at its peek performance by getting rid of the MySQL database overhead. This has only been tested on Joomla v1.7 and up. v1.0: Initial Release. v1.1: Bug fix - thanks to Ebo Eppenga v1.2: tested on Joomla 3.0, 3.1 and 3.2 NOTE: Optimize Your Tables is only guaranteed to work on PHP up to v5.4.x, there have been a few reports and confirmed tests on my hosting environment that it will not work in PHP 5.5.x due to MYSQL_QUERY extension having been deprecated in PHP 5.5.x. I'm looking for a way to update that to work for PHP 5.5.x - 7.0. Sincerely, Emmanuel. P.S.: If you are going to rate the plugin, please comment or contact me [exlemor@gmail.com] if you're having issues with it. [Someone rated it 1 out of 5 without any comments/review and without getting in contact with me so I couldn't help them :( ]. Credit: This is based on work by Joomlaportal.ru and their Joomla v1.5 plugin which they no longer maintain.
p
Art Adminer

Art Adminer

Paid download | Database Management | Artetics
3
Score:
0
1 review
Art Adminer is smart, fast and lightweight database management tool. This tool can be used if you need something faster and easier than phpMyAdmin. Features: Comprehensive database tool in your Joomla! administrator panel Connect to a database server with username and password or auto-connect to Joomla! database 3 default styles plus ability to add new Work with databases, tables, records Multilingual More Features: 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 Display users and rights and change them Display variables with links to documentation Manage events and table partitions We strongly recommend to protect administrator/components/com_artadminer folder with .htaccess and .htpasswd
c
EasyStaging

EasyStaging

Free | Database Management | Craig Phillips
3
Score:
0
1 review
EasyStaging is a Joomla! 2.5.4+ and 3.3.x+ component that simplifies the process of copying changes from a private "staging" version of a website to a "live" or public web server. EasyStaging allows you to replicate a "development" website to a "live" or "staging" location through replication plans. Using the concept of Plans you can copy the contents to multiple live/staging site locations. EasyStaging Plans allows you create Plans for specific users groups using Joomla! 2.5+ ACL model and control what the Plan will let them copy • all files or just those in a specific directory e.g. /images/dept/joes-files/ • all files that match a specific regex patter • or even exclude from the copy files matching a pattern • copy all tables in a database • copy a specific set of tables • or copy a table only if it doesn't already exist on the target site Version 1.2.2 adds some minor features and a range of bug fixes. For more details see the Changelog
c
Enhanced SQL Portal Bridge

Enhanced SQL Portal Bridge

Free | Database Management | David Flammer
3
Score:
0
0 reviews
This plugin serves as a bridge between Joomla! and an Enhanced SQL Portal for MySQL database management. It simply allows for single-signon capability: when logged in as a Joomla! admin, a user clicks on a link, and can access and manipulate the database using the Enhanced SQL Portal without needing a database password.
c
Reset Countdown

Reset Countdown

Paid download | Database Management | Roland Meier
3
Score:
0
0 reviews
With the Reset Countdown & Reset Countdown Admin modules you can display a countdown to every full hour or rest of the current day. So you are able to offer a Joomla Demo Site showing a countdown until next reset.
m