• Skip to main content

Victor Font Consulting Group, LLC

Digital Business Strategists

Call Us:

+1 919-604-5828

  • Home
  • Care Plans
    • Care Articles
    • Optional Subscriptions
  • Consultations
  • Products
    • Code Snippets
    • Public GitHub Repositories
    • Gist Snippets
    • Pastebin Snippets (Free)
    • Free Plugins
  • FAQs
  • Support
    • Graphic Design
  • Our Team
    • Contact
    • Speakers
    • Portfolio
  • Resources
    • Free WordPress Video Training
    • Tutorials
    • Articles
    • Cybersecurity
    • EU Referral Network
You are here: Home / Code Snippet / How To Configure WP-DBManager and PHP

How To Configure WP-DBManager and PHP

By Victor M. Font Jr.
May 19, 2013Leave a Comment

Contents
  • WP-DBManager Installation Issues
  • suPHP
    • suPHP _ConfigPath
  • Securing php.ini
How To Configure WP-DBManager and PHP

WP-DBManager by Lester Chan is a popular WordPress plugin. With over 811,000 downloads as of this writing, WP-DBManager is a full-featured database management and backup tool that allows you to optimize, repair, backup, and restore your WordPress installation's MySQL database. In addition, the plugin can delete backup copies of your database, drop tables, and run selected queries. It also supports the automatic scheduling of back ups, optimization, and repair of your database. Sounds like a great tool, doesn't it?

WP-DBManager Installation Issues

It really is a great plugin once you get it running. Unfortunately, depending on how your host has PHP configured on your server, you are likely to receive the following error when you attempt to backup your database for the first time:

WP-DBManager and PHP Configuration Error

If the PHP installation is configured properly, you'll see the following screen instead:

WP-DBManager and Configured Properly PHP

Fixing your PHP installation so WP-DBManager works and you see the second screen instead of the first is as easy as adding the following code to your .htaccess file:

At this point, you're probably wondering what this code actually does. Let me explain.

suPHP

suPHP is a tool for executing PHP scripts with the permissions of their owners. It consists of an Apache module (mod_suphp) and a setuid root binary (suphp) that is called by the Apache module to change the uid of the process executing the PHP interpreter.

suPHP _ConfigPath

This option tells mod_suphp which path to pass on to the PHP-interpreter (by setting the PHPRC environment variable). Do *NOT* refer to a file but to the directory the file resists in. You must have a valid php.ini file for the version of php you are using in the directory specified in this path.

E.g.: If you want to use "https://c4u5s8j9.rocketcdn.me/path/to/server/config/php.ini", use "suPHP_ConfigPath /path/to/server/config".

Securing php.ini

The rest of this code secures the php.ini file in the specified path from access through a web browser. Restricting directory and/or file access s one of the most frequently uses of .htaccess. To deny all http requests for the restricted php.ini, add the "deny from all" directive as shown to your .htaccess file.

  • 0share
  • Facebook0
  • Twitter0
  • Pinterest0
  • LinkedIn0
  • Print
  • SMS0

About Victor M. Font Jr.

Victor M. Font Jr. is an award winning author, entrepreneur, and Senior IT Executive. A Founding Board Member of the North Carolina Executive Roundtable, he has served on the Board of Advisors, of the North Carolina Technology Association, the International Institute of Business Analysis, Association of Information Technology Professionals, Toastmasters International, and the North Carolina Commission for Mental Health, Developmental Disabilities, and Substance Abuse Services. He is author of several books including The Ultimate Guide to the SDLC and Winning With WordPress Basics, and Cybersecurity.

Reader Interactions

VictorFont.com runs on the Genesis Framework

Genesis FrameworkThe Genesis Framework empowers you to quickly and easily build incredible websites with WordPress. Genesis provides the secure and search-engine-optimized foundation that takes WordPress to places you never thought it could go.

Check out the incredible features and the selection of designs. It's that simple—start using Genesis now!

Click here to download The Genesis Guide for Absolute Beginners (PDF - 1.4 MB)

Leave a Reply Cancel reply

Your email address and website will not be published. Required fields are marked *
Posting a comment means that you agree with and accept our Comment & Product Review Policy

Call: +1 919-604-5828

Send us an E-mail

Accessibility Statement | Affiliate Marketing Disclosure | Capability Statement

Cookie Policy | Comment & Product Review Policy | Privacy Policy | Site Map | Terms & Conditions

Copyright © 2003–2021 Victor M. Font Jr.

Return to top of page
Cover image: 5 Things You Can Fix On Your Website In The Next Week To Increase Engagement

Attract New Customers Automatically for Free!

  • Learn how to use the Internet to attract REAL clients
  • Avoid the 3 big mistakes EVERYBODY makes
  • Put this system on AUTOPILOT with the tools the Pros use!

GET YOUR COPY!

This little ebook has helped hundreds of business professionals get real results.
Now it's your turn!

ebook lead capture
Privacy Policy
{"cookieName":"wBounce","isAggressive":false,"isSitewide":true,"hesitation":"","openAnimation":false,"exitAnimation":false,"timer":"","sensitivity":"","cookieExpire":"7","cookieDomain":"","autoFire":"","isAnalyticsEnabled":false}
We only use analytical cookies on our website that allow us to recognize and count the number of visitors, but they do not identify you individually. They help us to improve the way our website works. By clicking Accept you, agree to cookies being used in accordance with our Cookie Policy.OkNoCookie policy