WP-DBManager

説明

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.

スクリーンショット

  • Admin - Backup DB
  • Admin - Empty/Drop Tables In DB
  • Admin - DB Information
  • Admin - Manage DB
  • Admin - Optimize DB
  • Admin - DB Options
  • Admin - DB Options
  • Admin - Repair DB
  • Admin - Run Query in DB

FAQ

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:
  1. In wp-dbmanager.php
  2. Find check_backup_files(); on line 246
  3. Add below it echo $command;
  4. Go to WP-Admin -> Database -> Backup
  5. Click Backup
  6. It should print some debugging statements
  7. Copy that line than run it in SSH
  8. If you need help on SSH contact your host or google for more info
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 disable the notice by going to WP-Admin -> Database -> DB Options and set Hide Admin Notices to Yes.

評価

Great plug-in

Have been using this for a long time and is still the most simple and effective DB backup tool.

Been using this for years

Has never done me wrong, and works as advertised. My one complaint is that I would love an option for MU for a global admin to only be available in the network. While each blog would only have an interface to tables specific to each blog.

Must-have plugin for me

This plugin allows me to automaticaly repair, optimize, and backup my database on whatever schedule I want. Or I can do it manually whenever I make any significant site changes, then send the backup file to myself by email. It is about as easy to use as it gets. There are other functions as well, but optimize and backup are 99% of what I use it for — and it’s perfect!

Overwhelmed

Totally do not understand all these instructions, explanations and nothing worked. At least have a payment section to expedite for beginners to fix this. I dont have the patience.

80件のレビューをすべて表示

貢献者と開発者

WP-DBManager はオープンソースソフトウェアです。以下の人々がこのプラグインに貢献しています。

貢献者

“WP-DBManager” はEnglish (Canada)に翻訳されています。 翻訳者のみなさん、翻訳へのご協力ありがとございます。

“WP-DBManager” をあなたの言語に翻訳しましょう。

開発に興味がありますか ?

Browse the code or subscribe to the development log by RSS.

変更履歴

Version 2.79

  • FIXED: Proper check for disabled functions

Version 2.78.1

  • NEW: Bump WordPress 4.7
  • FIXED: Undefined index: repair and repair_period

Version 2.78

  • FIXED: escapeshellcmd on Windows. Props Gregory Karpinsky.
  • FIXED: Move wp_mkdir_p() up before if check. Props Scott Allen.

Version 2.77

  • FIXED: Blank screen downloading backup
  • FIXED: Remove MySQL Version check to display tables stats

Version 2.76

  • NEW: Add wp_dbmanager_before_escapeshellcmd action just before escapeshellcmd()
  • FIXED: Missing / for Windows

Version 2.75

  • FIXED: When activating the plugin, copy index.php to the backup folder
  • FIXED: If you are on Apache, .htaccess will be copied to the backup folder, if you are on IIS, Web.config will be copied to the backup folder
  • FIXED: When choosing 1 Month(s) for Backup/Optimize/Repair, the next date calculation is wrong

Version 2.74

  • FIXED: escapeshellarg() already escape $, no need to double escape it

Version 2.73

  • FIXED: Unable to backup/restore database if user database password has certain special characters in them

Version 2.72

  • FIXED: Use escapeshellcmd() to escape shell commands. Props Larry W. Cashdollari.
  • FIXED: Do not allow LOAD_FILE to be run. Props Larry W. Cashdollari.
  • FIXED: Uses dbmanager_is_valid_path() to check for mysql and mysqldump path. Fixes arbitrary command injection using backup path. Props Larry W. Cashdollari.
  • FIXED: Uses realpath() to check for backup path. Fixes arbitrary command injection using backup path. Props Larry W. Cashdollari.

Version 2.71

  • NEW: Bump to 4.0

Version 2.70

  • New: Uses WordPress 3.9 Dashicons
  • NEW: Allow you to hide admin notices in the DB Options page
  • NEW: Allow Multisite Network Activate
  • NEW: Uses WordPress uninstall.php file to uninstall the plugin
  • NEW: Uses wp_mail() to send email instead of PHP mail()
  • NEW: New From E-mail, From Name & Subject template
  • FIXED: Issues with email from field if site title contains , (comma)
  • FIXED: Notices

Version 2.65

  • FIXED: Set default character set to UTF-8. Props Karsonito

Version 2.64

  • FIXED: Use intval() instead of is_int() when checking for port number. Props Webby Scots

Version 2.63 (03-05-2011)

  • NEW: Added Auto Repair Functionality
  • NEW: Added nonce To All Forms For Added Security