Search Results for: phpmyadmin


export.php was not found while backing up databases through phpmyadmin

[error]export.php was not found while backing up databases through phpmyadmin[/error]


This error is mainly caused when database size is more and you are trying to backup it up using phpmyadmin.




Increase memory_limit in /usr/local/psa/admin/conf/php.ini to higher value and restart
Plesk Control Panel after that.

Ideally 512M of memory_limit should fix the issue.

Post to Twitter

Error on clicking phpMyAdmin

Warning: session_start() [_function.session-start_
( ]: SQLite: failed to open/create
session database `/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb
– unable to open database:

/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ on line 86

Fatal error: session_start() [function.session-start]: Failed to initialize storage module: sqlite (path:
/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ on line 86


1) Login to shell of the server using root login details and open the file /usr/local/cpanel/3rdparty/etc/phpmyadmin/php.ini using vi or any other editor

2) Search for [Session] and change the following



session.save_handler = sqlite
session.save_path =/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb


session.save_handler = files
session.save_path = /tmp


3) Save and exit

4) Restart apache service.

/scripts/restartsrv httpd

Post to Twitter

PHPMyAdmin :: Existing configuration file (./ is not readable

Accessing PhpMyAdmin from cpanel I get error

PHPMyAdmin :: Existing configuration file (./ is not readable


1) Ssh to server as root

2) check permission for file

root@Server[~]#ls -ld /usr/local/cpanel/base/3rdparty/phpMyAdmin/

It should be

-rw-r—– 1 root cpanelphpmyadmin 1749 Oct 11 23:06 /usr/local/cpanel/base/3rdparty/phpMyAdmin/

3)If not then change ownership and file permission to above.

chown root:cpanelphpmyadmin  /usr/local/cpanel/base/3rdparty/phpMyAdmin/

chmod 640 /usr/local/cpanel/base/3rdparty/phpMyAdmin/

4) That’s it, you are all done.

Post to Twitter


Change magento url

Some times there comes a situation when you need to change magento installation url.
Eg: change url from to


Before you make any changes make sure you have backed up your database.

Following are the the easy steps to change it.



Access phpmyadmin >> select database >> browse table core_config_data.


Now look for field’s like web/unsecure/base_url and web/secure/base_url

Corresponding to this field you will either see {{base_url}} or your original url for magento.


New: Edit field under value and change url as per your requirement.


Now you will need to clear cache for maganto. Magento stores cache under magento installation directory var/cache
you can rename var directory under magento.

4) Try accessing Magento with new URL now. It should work with no problem. 🙂

Post to Twitter

wordpress temporary url

Most of the time we require a temporary URL to check if site is working properly before updating name server.

But suppose you are using  wordpress, then temporary url will not work as wordpress is by default meant to work on domain name.

If you are on cPanel server then temporary url will be http://ipaddress/~username.

Note: IP address will be your actual server IP address

For temporary url to work you will need to to make replace your domain name with temporary URL in database for wordpress.

Refer to following steps.

1) Login to cPanel >> PhpMyadmin >> select database for wordpress.

2) Select wp_option table.

3) After selecting wp_option table, you will see different fields from table. in this locate for Option_name locate for siteurl and home and change value for both of this fields to your temporary url. replace with temporary url as shown in below image.

Make changes and select GO button at the bottom. That’s all

Post to Twitter