=== WP-DBManager === Contributors: GamerZ Donate link: http://lesterchan.net/site/donation/ Tags: database, manage, wp-dbmanager, manager, table, optimize, backup, queries, query, drop, empty, tables, table, run, repair, cron, schedule, scheduling, automatic Requires at least: 2.8 Tested up to: 3.3.1 Stable tag: trunk Manages your WordPress database. == Description == Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database. = Previous Versions = * [WP-DBManager 2.40 For WordPress 2.7.x](http://downloads.wordpress.org/plugin/wp-dbmanager.2.40.zip "WP-DBManager 2.40 For WordPress 2.7.x") * [WP-DBManager 2.31 For WordPress 2.1.x To 2.6.x](http://downloads.wordpress.org/plugin/wp-dbmanager.2.31.zip "WP-DBManager 2.31 For WordPress 2.1.x To 2.6.x") * [WP-DBManager 2.05 For WordPress 2.0.x](http://downloads.wordpress.org/plugin/wp-dbmanager.2.05.zip "WP-DBManager 2.05 For WordPress 2.0.x") * [WP-DBManager 1.00 For WordPress 1.5.2](http://downloads.wordpress.org/plugin/wp-dbmanager.1.00.zip "WP-DBManager 1.00 For WordPress 1.5.2") = Development = * [http://dev.wp-plugins.org/browser/wp-dbmanager/](http://dev.wp-plugins.org/browser/wp-dbmanager/ "http://dev.wp-plugins.org/browser/wp-dbmanager/") = Translations = * [http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/](http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/ "http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/") = Support Forums = * [http://forums.lesterchan.net/index.php?board=11.0](http://forums.lesterchan.net/index.php?board=11.0 "http://forums.lesterchan.net/index.php?board=11.0") = Credits = * __ngetext() by [Anna Ozeritskaya](http://hweia.ru/ "Anna Ozeritskaya") * Right To Left Language Support by [Kambiz R. Khojasteh](http://persian-programming.com/ "Kambiz R. Khojasteh") = Donations = * I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appericiate it. If not feel free to use it without any obligations. == Changelog == = Version 2.63 (03-05-2011) = * NEW: Added Auto Repair Functionality * NEW: Added nonce To All Forms For Added Security = Version 2.61 (30-04-2011) = * FIXED: Checks File Extension And Sanitise File Name That Is Pass Through The URL When Downloading Database File. Props to [Joakim Jardenberg](http://jardenberg.se "Joakim Jardenberg"), [Jonas Nordstršm](http://jonasnordstrom.se "Jonas Nordstršm"), [Andreas Viklund](http://andreasviklund.com/ "Andreas Viklund") = Version 2.60 (01-12-2009) = * FIXED: Bug In Cron Backup On Windows Server = Version 2.50 (01-06-2009) = * NEW: Works For WordPress 2.8 Only * NEW: Uses jQuery Framework * NEW: Ensure That .htaccess Is In Backup Folder By Informing The User If It Is NOT There * NEW: Use _n() Instead Of __ngettext() And _n_noop() Instead Of __ngettext_noop() * FIXED: Uses $_SERVER['PHP_SELF'] With plugin_basename(__FILE__) Instead Of Just $_SERVER['REQUEST_URI'] = Version 2.40 (12-12-2008) = * NEW: Works For WordPress 2.7 Only * NEW: Load Admin JS And CSS Only In WP-DBManager Admin Pages * NEW: Added database-admin-css.css For WP-DBManager Admin CSS Styles * NEW: Uses admin_url(), plugins_url() And site_url() * NEW: Better Translation Using __ngetext() by Anna Ozeritskaya * NEW: Right To Left Language Support by Kambiz R. Khojasteh * FIXED: SSL Support * FIXED: Bug In Downloading Backups In Other Languages by Kambiz R. Khojasteh * FIXED: Bug In Backup/Restore On Windows Server When Path To mysqldump/mysql Or Backup File Contains Space Kambiz R. Khojasteh * FIXED: In database-manage.php, $nice_file_date Was Calculated More Than Once by Kambiz R. Khojasteh * FIXED: Returning Only DBManager Cron Schedules = Version 2.31 (16-07-2008) = * NEW: Works For WordPress 2.6 * FIXED: Unable To Optimize Or Repair Tables If Table Name Contains - (dash) = Version 2.30 (01-06-2008) = * NEW: Uses /wp-dbmanager/ Folder Instead Of /dbmanager/ * NEW: Uses wp-dbmanager.php Instead Of dbmanager.php * NEW: Added Minute(s) Option To Backup And Optimize Cron Jobs * NEW: Uses GiB, MiB, KiB Instead Of GB, MB, KB = Version 2.20 (01-10-2007) = * NEW: Added --skip-lock-tables Argument When Backing Up Database * NEW: Limit The Maximum Number Of Backup Files In The Backup Folder * NEW: Ability To Uninstall WP-DBManager = Version 2.11 (01-06-2007) = * NEW: Sort Database Backup Files By Date In Descending Order * NEW: Added Repair Database Feature * NEW: Automatic Scheduling Of Backing Up And Optimizing Of Database = Version 2.10 (01-02-2007) = * NEW: Works For WordPress 2.1 Only * NEW: Removed database-config.php * NEW: Localize WP-DBManager * NEW: Added The Ability To Auto Detect MYSQL And MYSQL Dump Path = Version 2.05 (01-06-2006) = * FIXED: Database Table Names Not Appearing Correctly * NEW: DBManager Administration Panel Is XHTML 1.0 Transitional = Version 2.04 (10-05-2006) = * FIXED: Unable To Download Backup DB Due To Header Sent Error * FIXED: Some XHTML Code Fixes = Version 2.03 (01-04-2006) = * FIXED: Run Query Box Too Big * FIXED: Header Sent Error * FIXED: Extra Slashes For Mysql/Mysql Dump Path * FIXED: Mismatch Date Due To GMT = Version 2.02 (01-03-2006) = * NEW: Improved On 'manage_database' Capabilities * NEW: Added GigaBytes To File Size * NEW: Added ALTER Statement To Allowed Queries * NEW: Able To Empty/Drop Tables * NEW: Able To EMail Database Backup File * NEW: Splitted database-manager.php Into Individual Files * NEW: Merge Restore And Delete Backup Database * NEW: Included .htaccess File To Protect Backup Folder * NEW: Checking Of Backup Status * FIXED: Using Old Method To Add Submenu * FIXED: PHP Short Tags * FIXED: Redirect Back To The Same Page Instead Of Manage Database Page After Submitting Form = Version 2.01 (01-02-2006) = * NEW: Added 'manage_database' Capabilities To Administrator Role = Version 2.00 (01-01-2006) = * NEW: Compatible With WordPress 2.0 Only * NEW: GPL License Added == Installation == 1. Open `wp-content/plugins` Folder 2. Put: `Folder: wp-dbmanager` 3. Activate `WP-DBManager` Plugin 4. Rename `htaccess.txt` to `.htaccess` file in `Folder: wp-content/plugins/wp-dbmanager` 5. The script will automatically create a folder called `backup-db` in the wp-content folder if that folder is writable. If it is not created, please create it and CHMOD it to 777 6. Open `Folder: wp-content/backup-db` 7. Move the `.htaccess` file from `Folder: wp-content/plugins/wp-dbmanager` to `Folder: wp-content/backup-db` 8. Go to `WP-Admin -> Database -> DB Options` to configure the database options. == Upgrading == 1. Deactivate `WP-DBManager` Plugin 2. Open `wp-content/plugins` Folder 3. Put/Overwrite: `Folder: wp-dbmanager` 4. Activate `WP-DBManager` Plugin 5. Go to `WP-Admin -> Database -> DB Options` to re-configure the database options. == Upgrade Notice == N/A == Screenshots == 1. Admin - Backup DB 2. Admin - Empty/Drop Tables In DB 3. Admin - DB Information 4. Admin - Manage DB 5. Admin - Optimize DB 6. Admin - DB Options 7. Admin - DB Options 8. Admin - Repair DB 9. Admin - Run Query in DB == Frequently Asked Questions == = My database is not backed up / My backup file is 0Kb = * Ensure that your host allows you to access mysqldump. You can try to narrow the problem by [Debugging via SSH](http://forums.lesterchan.net/index.php/topic,4549.0.html "Debugging via SSH"). = What is the difference between WP-DBManager and WP-DB-Backup? = * WP-DBManager uses `mysqldump` application to generate the backup and `mysql` application to restore them via shell. * WP-DB-Backup uses PHP to generate the backup. In some cases WP-DB-Backup will work better for you because it requires less permissions. Not all host allows you to access mysqldump/mysql directly via shell. * WP-DBManager allows you to have automatic optimizing and repairing of database on top of backing up of database. = Why do I get the message "Warning: Your backup folder MIGHT be visible to the public!"? = * Ensure that you have renamed `htaccess.txt` to `.htaccess` and placed it in your backup folder (defaults to `wp-content/backup-db/`) * If you are 100% sure you have did that and have verfied that the folder no longer is accessible to the public by visiting the URL `http://yousite.com/wp-content/backup-db/`, you can safely remove it by deleting `add_action('admin_notices', 'dbmanager_admin_notices');` on `line 191` in `wp-dbmanager.php`.