Content last modified Tuesday 17 June 2014
hop to #bottom
Categories:
Author:
Current version:
4.3
About It:
Get it:
Rate it:
  • Helpful?
  • 5 Yes
  • 0 No
Flag it:
Contact Reason [ ? ]

rss_admin_db_manager

The rss_admin_db_manager plugin gives you full control over your Textpattern database. It gives you the ability to backup your database, download your backups, restore your backups if necessary, view the current status of your database tables, repair them if necessary and run SQL statements against your data base. You can think of this plugin as a lightweight eplacement for phpMyAdmin.

Database Backup

The db backup tab allows you to backup, download and restore the MySQL database that is used for your Textpattern installation.
The database backups and restores are run using MySQL’s mysqldump command.
On this tab you are able to:

  • Create a .sql backup file on windows with the additional option of creating a gzipped backup on *nix operating systems
  • View a list of previous backup files
  • Restore your database from one of the previous backups
  • Download a backup file
  • Delete old backups

Database Manager

The db manager tab displays information about your MySQL database and all of its tables. A detailed list includes the name of the table, number of rows and file space usage.
You will also be alerted of any overhead or errors that need to be repaired. Tables can be repaired or dropped from this listing. Clicking on the name of the table will
run a select * [table name] SQL statement and take you to the run sql tab to display the results.

Run SQL Window

The run sql tab allows for free form entry and execution of SQL statements. The SQL window accepts
SELECT, INSERT, UPDATE, CREATE, REPLACE, and DELETE statements. If a SELECT statement is run, the results will be displayed to you below the SQL window.

Article Request Count:

Archived [?]: Does not work with Textpattern 4.4.0

Keywords/tags:
Initially released:
14 August 2005
Posted here:
24 Aug 2005
Article modified:
24 Feb 2013

If there is a comment form at the Information URL, you may want to leave your comments/questions there or at the Forum thread for quicker feedback. Otherwise, comment away:

Commenting is closed for this article.

Commented (15)

Mitchell Cain:
What the heck does ransomed mean??? Give me my download! AAARRRGGGHHH!
pompilos:
This plug sounds great, but must we pay for it? Did the author pay for his copy of Textpattern? Or for the help he received from the community of users? No, thanks.
Oh, c’mon people: I think we should be grateful that the authors of some of the great plugins (Zem also used to ransom and now he is a core TXP developer) find a way to fund their development habit.

Plus the donations are typically nominal: donate $5.00 or $10.00 USD—it all goes toward the ransom. Creating even simple plugins is a lot of work (especially when the bug reports come in), so I have no problem spending a few bucks for incredible functionality like this.

If you don’t want to pay then just wait until others pay and it is released—but please don’t complain about it: Just enjoy the TXP plugin social welfare system.
jw:
now at 99%

let’s get the thing out in the open, chip in the last dollar…..
It is available for everyone now.
It’s sexy, and it works well. Hats off to the dev.
Creates a 20 byte backup file, when the real sql file is 8.7 MB in size. Don’t know what causes this.
Rob, another great plugin ! The interface is far sexier than phpMyAdmin :-) Hats off indeed !

brilliant and essential plugin…

Can this be developed to save SQL queries with human readable names (like a list with titles i.e. comments between date1 and date2 which runs a saved sql query). If it is possible, I can maybe implement this to run reports etc etc

For TXP 4.0.6, the plugin code requires a small change as described in this post on the textpattern forum. An non-official edited version of the plugin is posted a few posts down there.

@Ruud van Melick —- Thanks…

Ben:

Could someone PLEASE update the code/link to include the current version’s ‘hack’?

Hello,

I have made some modifications to integrate the plugin in my TextPattern v4.5.4 installation.

You could download it from here (the code is available in this github repository)

Subscribe to this article's comments RSS feed. [ ? ]   View Recent Comments across the site.

Would you care to write a comment or visit the forum discussion?

You know you want to visit the Archives.

Browse

Categories


Articles

There are also tag clouds, 'cause those are fun.