Sys Admin Guides, How To's, etc by Marios Maravelias

Parallels has a patched version of phpMyAdmin-2.11.?9.5-all-languages and script to migrate settings from phpMyAdmin-2.8.2.4 installed with Plesk.

To install phpMyAdmin 2.11.?9.5 you need to:

1. Download the archive and unpack it.

~# wget http://download1.parallels.com/Plesk/Autoupdate/phpmyadmin.zip
~# unzip phpMyAdmin.zip

2. Extract patched phpMyAdmin:

~# cd phpMyAdmin
~# tar -xzf phpMyAdmin-2.11.9.5-all-languages.tar.gz

3. Migrate settings from installed phpMyAdmin to new one:

~# cd phpMyAdmin-2.11.9.5-all-languages && sh ../migrate_settings.sh

4. Backup files of installed phpMyAdmin (you can remove it later):

~# mv /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin.old

5. Move files of new phpMyAdmin to Parallels Panel root directory:

~# cd ../
~# mv phpMyAdmin-2.11.9.5-all-languages /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin

Article source here

When you use phpmyadmin provided by plesk and you try to export a large database you may encounter the problem that it will always give you to download a file 0 kb.

This happens when the database is big and you need to increase some options in php.ini to make it work.

(more…)

If you face the error:

1016 Can’t open file: ‘phpbb_sessions.MYI’. (errno: 145)

then you will have to (more…)