Code Monkey home page Code Monkey logo

rss_admin_db_manager's Introduction

Textpattern database manager

The rss_admin_db_manager plugin adds three menu items to your Textpattern admin interface. Each contains different functionality to help manage your MySQL database. You can think of this plugin as a lightweight replacement for phpMyAdmin.

Database backup

The Database backup panel 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 panel 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

Backup preferences

Set several preferences related to your database backups. You can set these options on the Database backup panel. The options are:

  • Lock Tables – Your host may or may not support this option. If your backup fails, try setting this to “No”.
  • Include txp_log – Include or omit the txp_log table from the backup.
  • Debug Mode – Turning debugging on will echo the command being run to the screen.
  • Backup Path – Set the directory that your backups will be saved to. Defaults to your Textpattern temp directory.
  • Mysqldump Path – It’s likely that the default will work for you. If not, enter the full path to the executable.
  • Mysql Path – It’s likely that the default will work for you. If not, enter the full path to the executable.

Database manager

The Database manager panel 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, optimized, dropped or backed up from this listing.

  • Clicking on the name of the table will run a select * FROM [table name] SQL statement and take you to the Run SQL panel to display the results.
  • Repair a single (MyISAM) table by clicking its corresponding Repair link.
  • Repair all (MyISAM) tables by clicking the Repair all link at the bottom of the table.
  • Optimize a single table by clicking its corresponding Optimize link.
  • Backup a single table by clicking its corresponding Backup link.
  • Drop a single table by clicking its corresponding Drop link.

Run SQL

The Run SQL panel allows free form entry and execution of SQL statements. The SQL window accepts SELECT, INSERT, UPDATE, CREATE, REPLACE, TRUNCATE, and DELETE statements. If a SELECT statement is run, the results will be displayed below the SQL command in a table.

Major Ransom Contributors

  • Jan Willem de Bruijn
  • Heikki Yl

rss_admin_db_manager's People

Contributors

bloke avatar

Stargazers

 avatar  avatar  avatar

Watchers

 avatar  avatar  avatar

rss_admin_db_manager's Issues

Wrong path for files saved

I am using plugin version 4.8.6 (located in the 'Diag' panel) and the code seems to look for backups in the "files" folder by default but not into get_pref('tempdir', sys_get_temp_dir()). So the problem occurs when we change the default paths (for filesand tmp folders as recommended by your smd_prognostics plugin).

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.