PU Database Admin ComponentLanguage

From the creator of PU Arcade comes PU Database Admin. PU Database Admin, or PU DBA for short, is a lightweight database administration tool meant to provide the Joomla Administrator with the ability to do database management tasks without the need for an external tool. It requires no configuration, no hacks, and is very intuitive to use. Some of the tasks it allows you to perform include:
*Show all your tables
*Export, optimize, drop, truncate, show index, or explain any table with a single button click
*Export individual tables or the entire database to a sql file
*Run SQL commands
*Insert, Edit, or Delete any individual record
*Supports languages, and ships with 7 languages!
*More!

NEW! Now supports Joomla 1.5 (Legacy) and provides the option to repair tables!

Based on phpminiadmin by Oleg Savchuk

Report

bydtork on August 28, 2009
I have no SQL / Database knowledge. Needed to remove a faulty plugin. Recommedations was to delete it from the table. Stumbled on to this impressive tool - installed it and solved by problem within minutes due to the friendly interface.
I'd give this 5 stars except for the small problem I had getting it to run. To be fair, my php.ini had short_open_tags = Off, and once change to On, it worked fine. However, it took me some time and effort to figure this out, and this could easily be fixed by the author by avoiding the short php tags (i.e.,
bymarnie1310 on August 28, 2008
Easy to install, even easier to use. Exactly what I needed, although I have access to PHPMyAdmin, this just made the job of changing tables/data so much easier.
bymunalemj on June 26, 2008
Only thing I was not able to do so far with this is actually deleting a table. Although, it has features like repair table and other really useful ones.
bytgelvin on December 16, 2007
This tool saved my behind... I needed to fix a password on the admin and it worked... however, when I tried to change my personal account from Administrator to Super Administrator, it didn't work. Is there a good reason why this didn't work?

I would also be interested to see you guys develop a component to restore passwords when the db has somehow changed it, or even make this a neat addition to this component.
It makes accessing the tables & fields within your database easy. You can remove/add tables, fields, records, etc. Now you can maintain your database within Joomla instead of hosting server utilities. It can optimize tables, but you have to individually choose them, which is a pain. Also, you can't repair tables, which is a critical feature that is missing. Otherwise, a solid, worthwhile product for any Joomla! administrator.
Great component: a MUST HAVE if you don't have direct access to other tools like phpMyAdmin...

Improvements can be done, specially it will be nice to be able to edit the table structure (Alter table), without have know and manually input the sql query.
byCubAfull on May 30, 2007
One of the best Component fo Joomla!
PU DBase Admin gives a direct view into all the Joomla! tables and allows me to quickly see how extensions have created new tables. Great Tool! Simple and Clean Install.
bymarboo on May 21, 2007
This is absolutely fantastic! :-)
Together with JoomlaXplorer, it should be in the release versions! Thank you!!
byGeas on May 12, 2007
This is a must have for everyone.

Good job! Keep it up!
by147th on May 7, 2007
Everything can be performed in place, no matter external browsers with phpMyAdmin up to edit DB data. Optimization of tables included. Definitely worth a try.
byNeAlvey on April 25, 2007
Excellent Component!! My cpanel session expires after 30 minutes, and it's a pain to log back in since they do not give a direct link to myPHPAdmin. THANK YOU for this component (and the Arcade component...a site favorite!).
bybohn002 on April 25, 2007
Between this and JoomXplorer I may never have to go into any of my customers CPanel or Plesk again! Simple yet powerful! You really need to add this to your must have list.
byFerret on April 25, 2007
If this doesn't end up as an Editor's pick I'll eat my underpants!
byItchySox on April 25, 2007
Wow, that's so useful. Some tasks just got a whole lot easier. Thank you.
byedwardspek on April 24, 2007
This component is truly useful and should be made part of the Joomla core!

I found a conflict in this version with another component, however: Ircmaxell's Page Cache (version 1.0.6)
This has to be the BEST thing you could ever use on a Joomla! site.

I love the edit in place and ability to import/export data.

SoM