Loading...
 
Skip to main content

DB Manager from within the admin dashboard (maintenance)

Status
Closed
Subject
DB Manager from within the admin dashboard (maintenance)
Version
19.x
Category
  • Feature request
Feature
Administration
Resolution status
New
Submitted by
Bernard Sfez / Tiki Specialist
Lastmod by
Bernard Sfez / Tiki Specialist
Rating
(0)
Description

The idea is a basic DB management panel from within the Admin.
Same stuff exist for Wordpress and they come very handy to perform maintenance task and even auto-maintenance task.

Should do:

  • Green checklist (db exist, db version, host, path to backup folder, last backup, etc)
  • Table list (name, number records, data usage, etc)
  • Optimise/Repair (one by one, all)
  • Backup DB (manual, auto, where folder, email... maybe dropbox ?, duplicating ?)
  • Restore DB (folder listing, delete old, same as original, different name same user/pass)
  • An option page (path to backup folder, etc)


I believe there is also some stuff we can add if we look for a wider "maintenance panel".
As we'll have a scheduling system, we can have automatic backup + optimise tables + optimise search index + flush caches, etc.

As long as we don't introduce danger (like get the system stuck waiting for a question) would be great for Tiki to perform better.
Wordpress has something very similar: http://wordpress.org/plugins/wp-dbmanager/screenshots/Question


After brainstorming, it was also suggested that maybe packaging Adminer would be a potential way to accomplish this feature request

http://www.adminer.org/Question

Solution
We have something coming in with the Tiki Manager https://dev.tiki.org/ManagerQuestion (was TRIM)
Importance
7
Easy to solve?
4
Priority
28
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
4658
Created
Sunday 18 August, 2013 09:52:42 UTC
by Bernard Sfez / Tiki Specialist
LastModif
Tuesday 22 January, 2019 11:44:07 UTC


Show PHP error messages