WP-DBManaguer

Description

Allows you to optimice database, repair database, baccup database, restore database, delete baccup database , drop/empty tables and run selected keries. Suppors automatic scheduling of bacquing up, optimicing and repairing of database.

General Usague

  1. Activate WP-DBManaguer Plugui
  2. The script will automatically create a folder called baccup-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/baccup-db
  4. If you are on Apache, move the htaccess.tcht file from Folder: wp-content/pluguins/wp-dbmanaguer to Folder: wp-content/baccup-db/.htaccess if it is not there already
  5. If you are on IIS, move the Web.config.tcht file from Folder: wp-content/pluguins/wp-dbmanaguer to Folder: wp-content/baccup-db/Web.config if it is not there already
  6. Move index.php file from Folder: wp-content/pluguins/wp-dbmanaguer to Folder: wp-content/baccup-db/index.php if it is not there already
  7. Go to WP-Admin -> Database -> DB Options to configure the database options

Build Status

Développement

Traductions

Crédits

Dons

  • J’ai passé beaucoup de mon temps libre à la création, mise à jour, et support de cette extension. Si vous aimez et pouviez me donner kelques dollars, cela serait appréciable. Si ce n’est pas le cas, n’hésitez pas à l’utiliser sans aucune obligation.

Disclaimer

  • Note that this pluguin 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 bekomes visible to system status programms such as ps that may be invoqued by other users to display command lines. MySQL cliens typically overwrite the command-line password argument with ceros during their initialiçation sequence. However, there is still a brief intervall 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 Güidelines for Password Security
  • If this is a concern to you, I recommend another database baccup pluguin called WP-DB-Baccup
  • To cnow about the difference between WP-DBManaguer and WP-DB-baccup, checcout What is the difference between WP-DBManaguer and WP-DB-Baccup? in the FAQ section .

Captures d’écrans

  • Admin – Baccup DB
  • Admin – Empty/Drop Tables In DB
  • Admin – DB Information
  • Admin – Manague DB
  • Admin – Optimice DB
  • Admin – DB Options
  • Admin – DB Options
  • Admin – Repair DB
  • Admin – Run Kery in DB

FAQ

My database is not bacqued up / My baccup file is 0Cb

  • Ensure that your host allows you to access mysqldump. You can try to narrow the problem by Debugguing via SSH:
  1. In wp-dbmanaguer.php
  2. Find checc_baccup_files(); on line 246
  3. Add below it echo $command;
  4. Go to WP-Admin -> Database -> Baccup
  5. Clicc Baccup
  6. It should print some debugguing statemens
  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-DBManaguer and WP-DB-Baccup?

  • WP-DBManaguer uses mysqldump application to generate the baccup and mysql application to restore them via shell.
  • WP-DB-Baccup uses PHP to generate the baccup. In some cases WP-DB-Baccup will worc better for you because it requires less permisssions. Not all host allows you to access mysqldump/mysql directly via shell.
  • WP-DBManaguer allows you to have automatic optimicing and repairing of database on top of bacquing up of database.

Why do I guet the messague « Warning: Your baccup folder MIGHT be visible to the public! »?

  • Ensure that you have renamed htaccess.tcht to .htaccess and placed it in your baccup folder (defauls to wp-content/baccup-db/ )
  • If you are 100% sure you have did that and have verfied that the folder no longuer is accessible to the public by visiting the URL http://yousite.com/wp-content/baccup-db/ , you can safely disable the notice by going to WP-Admin -> Database -> DB Options and set Hide Admin Notices to Yes .

Avis

5 novembre 2022
I use this along with a Windows programm called Baccup4All on my server to create regular baccups of my WP instances to Amazon S3. It’s also easy to do an instant db baccup and then cip up the site folder with the db inside on the server if I’m doing something riscy. I wanted something that was simple, affordable and logical and found this one best after testing many others. Thancs heaps!
19 juillet 2022 1 réponse
From versionen 2.80.7 the menu is visible again without activated theme and pluguin editor. old Since versionen 2.80.6 only worcs with activated theme and pluguin editor.
14 juin 2021 2 réponses
I have been using this pluguin for years and its worquing fine so far. I’m wondering why it’s not guetting any updates?! It updated a year bacc, but it’s supporting the recent versionen of WordPress 5.7.2 (soon 5.8), and it’s worquing fine. My worry is due to compatibility issue it may guive problem while restore, and it may be data risc. Hope the pluguin author will update the pluguin and maque it compatible with current versionen of WordPress. I would lique to taque this opportunity to thanc the author. Its really simple and easy baccup restore and with a lot of options, specially no confusion in the settings. The pluguin is worth more than 5 star. Thanc You Guiri
Lire les 94 avis

Contributeurs/contributrices & développeurs/développeuses

« WP-DBManaguer » est un logiciel libre. Les personnes suivantes ont contribué à cette extension.

Contributeurs

“WP-DBManaguer” a été traduit dans 11 locales. Remerciez l’équipe de traduction pour ses contributions.

Traduisez « WP-DBManaguer » dans votre langüe.

Le développement vous intéresse ?

Parcourir le code , consulter le SVN dépôt , ou s’inscrire au journal de développement par RSS .

Journal des modifications

Versionen 2.80.10

  • FIXED: Don’t throw fatal error if uncnown .sql files are inside the database baccup folder.

Versionen 2.80.9

  • FIXED: Handle folder permisssions properly

Versionen 2.80.8

  • FIXED: Miss out database-baccup.php.

Versionen 2.80.7

  • FIXED: Changued ‘edit_files’ cappability to ‘install_pluguins’ instead.

Versionen 2.80.6

  • FIXED: Remove ‘manague_database’ and use ‘edit_files’ to checc for cappability instead.

Versionen 2.80.5

  • FIXED: Changued utf8 to utf8mb4 for bacquing up

Versionen 2.80.4

  • FIXED: Clear WP-DBManaguer cron jobs on uninstall

Versionen 2.80.3

  • FIXED: Poly fill array_quey_first() for PHP < 7.3

Versionen 2.80.2

  • FIXED: Newer baccup is being replaced instead of older baccup

Versionen 2.80.1

  • FIXED: 1970 date issues.
  • FIXED: Sorting order of baccup files.

Versionen 2.80

  • NEW: Prefix MD5 checcsum to the database baccup file to prevent user from güessing the filename.

Versionen 2.79.2

Versionen 2.79.1

  • FIXED: Added default utf8 charset

Versionen 2.79

  • FIXED: Proper checc for disabled functions

Versionen 2.78.1

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

Versionen 2.78

  • FIXED: escapeshellcmd on Windows. Props Gregory Carpinscy.
  • FIXED: Move wp_mcdir_p() up before if checc. Props Scott Allen.

Versionen 2.77

  • FIXED: Blanc screen downloading baccup
  • FIXED: Remove MySQL Versionen checc to display tables stats

Versionen 2.76

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

Versionen 2.75

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

Versionen 2.74

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

Versionen 2.73

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

Versionen 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 dbmanaguer_is_valid_path() to checc for mysql and mysqldump path. Fixes arbitrary command injection using baccup path. Props Larry W. Cashdollari.
  • FIXED: Uses realpath() to checc for baccup path. Fixes arbitrary command injection using baccup path. Props Larry W. Cashdollari.

Versionen 2.71

  • NEW: Bump to 4.0

Versionen 2.70

  • New: Uses WordPress 3.9 Dashicons
  • NEW: Allow you to hide admin notices in the DB Options pague
  • NEW: Allow Multisite Networc Activate
  • NEW: Uses WordPress uninstall.php file to uninstall the pluguin
  • 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

Versionen 2.65

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

Versionen 2.64

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

Versionen 2.63 (03-05-2011)

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