T3 DB Tools is a seditio database management plugin.

Features:
-- Backup all or selected tables of your seditio DB.
-- Table information and schema.
-- Browse tables (experimental)
-- Drop, truncate tables.
-- Option to export data, structure or both.
-- Support for gzip, bzip2 compression of the backups.
-- Restore database backup.
-- Run custom sed queries.
-- Extra security rights.
-- Check, analyze, repair and optimize tables.
-- Auto create the backup folder and the directory blocker protection.
-- 100% ability to translate.
-- Easy navigation and event reports.

2 : How to install?

The installation is pretty easy and very common as every other simple seditio plugin.

-- Upload folder dbtools to your plugins/ folder. (*)
-- Install / Reinstall the plugin through the admin cp plugins management.
-- Edit the plugin configuration to serve your needs.
-- Open the plugin from the seditio tools section, T3 DB Tools.

* If you are updating Delete all old files since v1.0 there are some major files changes.

3 : What's new ?

Version 1.6
------------
- Fixed bug of adding page output to the backup file.
- Fixed bug without sql sql_delimiter.

We Strongly recommend to use Admin Login with T3 Db Tools.

Version 1.5
------------
- Adopted phpMyadmin sql import procedure.
- Backup functions improved a lot. (faster and smaller results)
- Added bz2 compression.
- Added table information and schema.
- Added table browse.
- Added drop, truncate tables fuctions.
- Added online editing of config.php.
- Fixes and improvements everywhere.

The adoption of the import procedure from phpMyadmin fixed a lot of bugs but the performance took a serious hit.

but it's still fast enough.

Version 1.0
------------
- First initial release

4 : Special rights

As a tool plugin of seditio T3 DB Tools first is passing through the sedito groups rights system. Because of the plugin's nature it is necessary to have more options about this plugin for security reasons.

For example you might want your admins to be able to backup but you don't want them to restore backups or even download them. This is done by the configuration of the plugin. Since v1.5 you can edit the config.php online through the Plugin Cotrol Panel. The only person who can edit these rights online is the first site admin with userid=1.

In the settings you can add the user IDs of the people you want to do each thing. Separate each userid with a comma.

// ============================================|
// Specify who can access T3 DB Tools |
// ============================================|
$config['canaccessme'] = '1';

// ============================================|
// Specify who can run queries |
// ============================================|
$config['canrunqueries'] = '1'; //Danger//

// ============================================|
// Specify who can do database actions |
// ============================================|
$config['candbactions'] = '1';

// ============================================|
// Specify who can restore db backups |
// ============================================|
$config['canrestoredb'] = '1';

// ============================================|
// Specify who can donwload db backups |
// ============================================|
$config['candownloadbackup'] = '1';

// ============================================|
// Specify who can delete db backups |
// ============================================|
$config['candeletebackup'] = '1';

// ============================================|
// Specify who can drop tables |
// ============================================|
$config['candroptable'] = '1';

// ============================================|
// Specify who can truncate tables |
// ============================================|
$config['cantruncatetable'] = '1';

5 : Explanation of the main functions

By the main page you can do the following

* Backup the DB using these options:
    - Backup the selected tables.
    - Export data or structure or both of the selected tables.
    - Compress the output.
* Check the selected tables
* Analyze the selected tables
* Repair the selected tables
* Optimize the selected tabes

In the bottom you will find a select box with all the current backups on your ftp. You can download, delete or even restore one of them per time.

All the above are controlled by the special rights system of the plugin.

6 : Import dumps by other backup software

You probably mean to restore db backups from phpmyadmin. The main answer is yes you can do that and probably you will be able to restore backups from many other backup scripts if you follow some rules.

1- Don't insert comments in the same line where the query is.
2- Don't use the option to backup with extended inserts.
3- Make sure the collation of the db you took the backup is the same with the collation of the new db, or else you will have problems.
4- The backup must be in sql format or compressed with gzip (.gz) or bzip2 (.bz2)

7 : Run queries

This is a very dangerous part of the plugin if you don't know how to write your queries. If this tool is accessed by the wrong hands (hackers ?) your site could end up totally ruined.

That's why this section by default is locked even for you the admin. If you are 110% sure you can use it then edit the extra security rights and add your user ID to appropriate setting.

Some instructions:
-- Enter a query per line (avoid problems).
-- Remove comments.
-- Don't overdo it with number of queries you will run per time.