phpmyadmin export table fails

Question

I am currently running phpMyAdmin 4.7.1 against a mySQL 5.6.16 database on my Mac (El Capitan). Everything worked well, but in order to upgrade my test Moodle database, I had to upgrade my PHP installation from 5.5.38 to 5.6.30, which I did using the excellent installation instructions here (https://coolestguidesontheplanet.com/?s=El+Capitan+php). HOWEVER, as soon as I did so, my phpMyAdmin began behaving oddly. I can still log in, list table structure and browse contents, but then I run into problems.

ONE: When phpMyAdmin lists contents of a table, the select * from SQL is shown in the window at the top of the page. If I "refresh" this -- i.e., running SQL which phpMyAdmin successfully just ran, the window hangs with a message that it is trying to contact my Mac server (by name), then goes blank.

TWO: If I try to export table contents using the phpMyAdmin option, the window also hangs with the contact message, then goes blank.

There are no messages in /var/log/apache2/error_log, in /var/log/mysql/mysqld.error, or in /var/log/php/php_error.log. There are no messages in the system.log, so I am stuck without a clue as to the issue.

Replacing PHP 5.5.38 as my PHP engine makes phpMyAdmin work (but I can't use this version going forward because it doesn't work with other software I need to develop).

I have compared the php.ini files and extension files as much as possible, but I cannot find where the pertinent lie, other than that I am using a stricter developer version of PHP 5.6.30 than I was for PHP 5.5.38. Infrequently, the export will work -- so I must have a permissions issue or a resource issue in my environment.

Any suggestions will be greatly appreciated.

Answer 1

then try and install another php with the phpmyadmin server.. do backup your database you can get that from C:\xampp\mysql\data for windows user.

Answer 2

Try to export the specific tables, and not the entire database at one go, or just use mysql workbench.