Title: WP-DBManager
Author: Lester Chan
Published: <strong>3. januar, 2006</strong>
Last modified: 24. november, 2024

---

Søk i utvidelser

![](https://ps.w.org/wp-dbmanager/assets/banner-772x250.jpg?rev=1206751)

![](https://ps.w.org/wp-dbmanager/assets/icon.svg?rev=977538)

# WP-DBManager

 Av [Lester Chan](https://profiles.wordpress.org/gamerz/)

[Last ned](https://downloads.wordpress.org/plugin/wp-dbmanager.2.80.10.zip)

 * [Detaljer](https://nb.wordpress.org/plugins/wp-dbmanager/#description)
 * [Omtaler](https://nb.wordpress.org/plugins/wp-dbmanager/#reviews)
 * [Utvikling](https://nb.wordpress.org/plugins/wp-dbmanager/#developers)

 [Brukerstøtte](https://wordpress.org/support/plugin/wp-dbmanager/)

## Beskrivelse

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.

### General Usage

 1. Activate `WP-DBManager` Plugin
 2. 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 the folder
    and ensure that the folder is writable
 3. Open `Folder: wp-content/backup-db`
 4. If you are on Apache, move the `htaccess.txt` file from `Folder: wp-content/plugins/
    wp-dbmanager` to `Folder: wp-content/backup-db/.htaccess` if it is not there already
 5. If you are on IIS, move the `Web.config.txt` file from `Folder: wp-content/plugins/
    wp-dbmanager` to `Folder: wp-content/backup-db/Web.config` if it is not there already
 6. Move `index.php` file from `Folder: wp-content/plugins/wp-dbmanager` to `Folder:
    wp-content/backup-db/index.php` if it is not there already
 7. Go to `WP-Admin -> Database -> DB Options` to configure the database options

### Build Status

### Development

 * [https://github.com/lesterchan/wp-dbmanager](https://github.com/lesterchan/wp-dbmanager)

### Translations

 * [http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/](http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/)

### Credits

 * Plugin icon by [Freepik](http://www.freepik.com) from [Flaticon](http://www.flaticon.com)

### 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 appreciate it. If not feel free to use it without any obligations.

### Disclaimer

 * Note that this plugin passes your datababase password via –password in the command
   line of mysqldump. This is convenient but as a trade off, it is insecure.
 * On some systems, your password becomes visible to system status programs such
   as ps that may be invoked by other users to display command lines. MySQL clients
   typically overwrite the command-line password argument with zeros during their
   initialization sequence. However, there is still a brief interval during which
   the value is visible. Also, on some systems this overwriting strategy is ineffective
   and the password remains visible to ps. Source: [End-User Guidelines for Password Security](http://dev.mysql.com/doc/refman/5.5/en/password-security-user.html)
 * If this is a concern to you, I recommend another database backup plugin called
   [WP-DB-Backup](https://wordpress.org/plugins/wp-db-backup/)
 * To know about the difference between WP-DBManager and WP-DB-backup, checkout **
   What is the difference between WP-DBManager and WP-DB-Backup?** in the [FAQ section](https://wordpress.org/plugins/wp-dbmanager/faq/).

## Skjermbilder

 * [[
 * 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

## Ofte stilte spørsmål

### 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`.

## Vurderinger

![](https://secure.gravatar.com/avatar/cf3ce259feb3179936d0518e5191438c87deae0473573e5356fe6e77cd94e4b9?
s=60&d=retro&r=g)

### 󠀁[Remove all submissions in elementor](https://wordpress.org/support/topic/remove-all-submissions-in-elementor/)󠁿

 [modes200](https://profiles.wordpress.org/modes200/) 20. mai, 2025

Great plugin. I have used to clean up all submissions in elementor

![](https://secure.gravatar.com/avatar/21276ef0a192ecd0a7bef849cb6963537c147a3926b2de25d7b8c1b5a4b233ec?
s=60&d=retro&r=g)

### 󠀁[Best one for my particular needs, thanks!](https://wordpress.org/support/topic/best-one-for-my-particular-needs-thanks/)󠁿

 [robaxxx](https://profiles.wordpress.org/robaxxx/) 5. november, 2022

I use this along with a Windows program called Backup4All on my server to create
regular backups of my WP instances to Amazon S3. It’s also easy to do an instant
db backup and then zip up the site folder with the db inside on the server if I’m
doing something risky. I wanted something that was simple, affordable and logical
and found this one best after testing many others. Thanks heaps!

![](https://secure.gravatar.com/avatar/08b5d287140d20bc2ed07150fed85d5f4597b9928da8937aaef77c7d051e3587?
s=60&d=retro&r=g)

### 󠀁[This was one tool used to help me bring back my wp site](https://wordpress.org/support/topic/this-was-one-tool-used-to-help-me-bring-back-my-wp-site/)󠁿

 [jamesoutland](https://profiles.wordpress.org/jamesoutland/) 2. oktober, 2022

1st, I was able to target the files I wanted to clean. I would like to add just 
be careful what you remove. Then I was able to reinstall a program and it worked.
Not sure the tecnical reasons why it worked but it did. Thank you!

![](https://secure.gravatar.com/avatar/68d12b0bc5a279b854b74161cd3746f387b7549281de909163cf0399cd53e706?
s=60&d=retro&r=g)

### 󠀁[it doesnt work](https://wordpress.org/support/topic/it-doesnt-work-311/)󠁿

 [ntalam](https://profiles.wordpress.org/ntalam/) 29. august, 2022 1 svar

SELECT * FROM ‘…. returns me nothing

![](https://secure.gravatar.com/avatar/a9c3ca262ef07c913f046456d6540c01259d5ac0d19682921b716dde1fcca130?
s=60&d=retro&r=g)

### 󠀁[Version 2.80.7 works again](https://wordpress.org/support/topic/no-longer-usable-6/)󠁿

 [nonick08](https://profiles.wordpress.org/nonick08/) 19. juli, 2022 1 svar

From version 2.80.7 the menu is visible again without activated theme and plugin
editor. old Since version 2.80.6 only works with activated theme and plugin editor.

![](https://secure.gravatar.com/avatar/4883c89d4a8a6dc5c6b0a2e37e6fd71a29e85ea26ec992c566526aab3954a71f?
s=60&d=retro&r=g)

### 󠀁[Fantastic Plugin!](https://wordpress.org/support/topic/fantastic-plugin-1596/)󠁿

 [girirajnet](https://profiles.wordpress.org/girirajnet/) 14. juni, 2021 2 svar

I have been using this plugin for years and its working fine so far. I’m wondering
why it’s not getting any updates?! It updated a year back, but it’s supporting the
recent version of WordPress 5.7.2 (soon 5.8), and it’s working fine. My worry is
due to compatibility issue it may give problem while restore, and it may be data
risk. Hope the plugin author will update the plugin and make it compatible with 
current version of WordPress. I would like to take this opportunity to thank the
author. Its really simple and easy backup restore and with a lot of options, especially
no confusion in the settings. The plugin is worth more than 5 star. Thank You Giri

 [ Les alle 94 vurderinger ](https://wordpress.org/support/plugin/wp-dbmanager/reviews/)

## Bidragsytere og utviklere

«WP-DBManager» er programvare med åpen kildekode. Følgende personer har bidratt 
til denne utvidelsen:

Bidragsytere

 *   [ Lester Chan ](https://profiles.wordpress.org/gamerz/)

“WP-DBManager” har blitt oversatt til 11 språk. Takk til [oversetterne](https://translate.wordpress.org/projects/wp-plugins/wp-dbmanager/contributors)
for deres bidrag.

[Oversett “WP-DBManager” til ditt språk.](https://translate.wordpress.org/projects/wp-plugins/wp-dbmanager)

### Interessert i utvikling?

[Bla gjennom koden](https://plugins.trac.wordpress.org/browser/wp-dbmanager/), sjekk
ut [SVN-repositoriet](https://plugins.svn.wordpress.org/wp-dbmanager/), eller abonner
på [utviklingsloggen](https://plugins.trac.wordpress.org/log/wp-dbmanager/) med 
[RSS](https://plugins.trac.wordpress.org/log/wp-dbmanager/?limit=100&mode=stop_on_copy&format=rss).

## Endringslogg

### Version 2.80.10

 * FIXED: Don’t throw fatal error if unknown .sql files are inside the database 
   backup folder.

### Version 2.80.9

 * FIXED: Handle folder permissions properly

### Version 2.80.8

 * FIXED: Miss out database-backup.php.

### Version 2.80.7

 * FIXED: Changed ‘edit_files’ capability to ‘install_plugins’ instead.

### Version 2.80.6

 * FIXED: Remove ‘manage_database’ and use ‘edit_files’ to check for capability 
   instead.

### Version 2.80.5

 * FIXED: Changed utf8 to utf8mb4 for backing up

### Version 2.80.4

 * FIXED: Clear WP-DBManager cron jobs on uninstall

### Version 2.80.3

 * FIXED: Poly fill array_key_first() for PHP < 7.3

### Version 2.80.2

 * FIXED: Newer backup is being replaced instead of older backup

### Version 2.80.1

 * FIXED: 1970 date issues.
 * FIXED: Sorting order of backup files.

### Version 2.80

 * NEW: Prefix MD5 checksum to the database backup file to prevent user from guessing
   the filename.

### Version 2.79.2

 * FIXED: Arbitrary file delete bug by sanitizing filename. Props [RIPS Technologies](https://www.ripstech.com).

### Version 2.79.1

 * FIXED: Added default utf8 charset

### 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](http://webbyscots.com/)

### Version 2.63 (03-05-2011)

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

## Meta

 *  Versjon **2.80.10**
 *  Sist oppdatert **1 år siden**
 *  Aktive installasjoner **60 000+**
 *  WordPress-versjon ** 4.0 eller nyere **
 *  Testet opp til **6.7.5**
 *  Språk
 * [Chinese (Taiwan)](https://tw.wordpress.org/plugins/wp-dbmanager/), [Dutch](https://nl.wordpress.org/plugins/wp-dbmanager/),
   [English (Canada)](https://en-ca.wordpress.org/plugins/wp-dbmanager/), [English (US)](https://wordpress.org/plugins/wp-dbmanager/),
   [French (France)](https://fr.wordpress.org/plugins/wp-dbmanager/), [Greek](https://el.wordpress.org/plugins/wp-dbmanager/),
   [Japanese](https://ja.wordpress.org/plugins/wp-dbmanager/), [Russian](https://ru.wordpress.org/plugins/wp-dbmanager/),
   [Serbian](https://sr.wordpress.org/plugins/wp-dbmanager/), [Spanish (Chile)](https://cl.wordpress.org/plugins/wp-dbmanager/),
   [Spanish (Spain)](https://es.wordpress.org/plugins/wp-dbmanager/) og [Spanish (Venezuela)](https://ve.wordpress.org/plugins/wp-dbmanager/).
 *  [Oversett til ditt språk](https://translate.wordpress.org/projects/wp-plugins/wp-dbmanager)
 * Stikkord
 * [database](https://nb.wordpress.org/plugins/tags/database/)[manage](https://nb.wordpress.org/plugins/tags/manage/)
   [manager](https://nb.wordpress.org/plugins/tags/manager/)[table](https://nb.wordpress.org/plugins/tags/table/)
 *  [Avansert visning](https://nb.wordpress.org/plugins/wp-dbmanager/advanced/)

## Vurderinger

 4.4 av 5 stjerner.

 *  [  77 5-star reviews     ](https://wordpress.org/support/plugin/wp-dbmanager/reviews/?filter=5)
 *  [  3 4-star reviews     ](https://wordpress.org/support/plugin/wp-dbmanager/reviews/?filter=4)
 *  [  2 3-star reviews     ](https://wordpress.org/support/plugin/wp-dbmanager/reviews/?filter=3)
 *  [  0 2-star reviews     ](https://wordpress.org/support/plugin/wp-dbmanager/reviews/?filter=2)
 *  [  12 1-star reviews     ](https://wordpress.org/support/plugin/wp-dbmanager/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/wp-dbmanager/reviews/#new-post)

[Se alle omtalene](https://wordpress.org/support/plugin/wp-dbmanager/reviews/)

## Bidragsytere

 *   [ Lester Chan ](https://profiles.wordpress.org/gamerz/)

## Brukerstøtte

Har du noe å si? Trenger du hjelp?

 [Vis brukerstøtteforumet](https://wordpress.org/support/plugin/wp-dbmanager/)

## Donér

Vil du støtte videreutviklingen av denne utvidelsen?

 [ Doner til denne utvidelsen ](http://lesterchan.net/site/donation/)