All my wordpress blogs have wp-dbmanger. A wordpress database management plugin which 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 and optimizing of database of the site easily in one click. But it requires passthru() or system() or exec(). There is work around for exec() but passthru() is required during restoration of database backup generated by it
I know that functions are disabled by default due to security reasons. By default Innohosting disabled this function too. WP-DBManager checked PHP Functions (passthru(), system() and exec()) …
passthru() disabled.
system() disabled.
exec() disabled.
You can enable the disable functions using a custom php.ini file under your public_html folder or your current your wordpress folder.In your .htaccess file under your public_html folder, add the following:
suPHP_ConfigPath /home/user/public_html <Files php.ini> order allow,deny deny from all </Files>
Note: Make sure to change the user text above to your account username.
It worked !, Out put result :
Functions (passthru(), system() and exec()) …
passthru() enabled.
system() enabled.
exec() enabled.
But, I keep getting error when trying to send backup result to email address
Fatal error: Allowed memory size of 33554432 bytes exhausted
This problem solved by increasing the server’s PHP memory_limit = 64 M
create a custom php.ini file under your public_html folder and add any of the following that are needed:
upload_max_filesize = 32M post_max_size = 32M memory_limit = 64M upload_tmp_dir = 64M max_execution_time = 90
For servers running normal PHP (this will not work at server have suPHP installed on it, Internal Server Error : 500)
You can increase the PHP max upload size and PHP memory_limit for your account by adding the following to your .htaccess file:
php_value memory_limit "64M" php_value post_max_size "32M" php_value upload_max_filesize "32M" php_value max_input_time "120"
Database Backup File For ‘September 30, 2009 @ 12:42 am’ Successfully E-Mailed To ‘myemail@gmail.com’
Now wp-dbmanager works flawlessely.











































{ 1 comment… read it below or add one }
Hey, great blog…but I don’t understand how to add your site in my rss reader. Can you Help me, please