Import SQL very slow in 4.8.4

[WayneGit1]

Since 4.8.4 importing sql has been very slow and invariably times out. A data file of 20MB that loaded within 60 seconds before the upgrade now fails after 300 seconds. If I break the file into 4 separate files, I can complete the import.

• Operating system: CentOS 6
• Web server: nginx/1.11.10
• Database version: 5.1.73
• PHP version: 5.6.30
• phpMyAdmin version: 4.8.4

[MauricioFauth]

What was the phpMyAdmin version before the upgrade?

[WayneGit1]

4.6.6

[WayneGit1]

Hi,

Were you able to reproduce the issue?

Thanks

[williamdes]

@WayneGit1 Do you have Xdebug enabled ?

[musicpanda]

I have the same problem with phpMyadmin 4.8.5.

My installation runs on Xampp under Windows 10 with PHP 5.6.

Importing a 60MB sql file took a full hour - after which a PHP timeout ended the program. When I checked all the imported tables seemed to be there. This was on a fast new computer.

When in another upload I ended MySql after more than an hour it crashed my Mysql. But it gave an interesting error message (I replaced the backticks with quotes). The empty table name suggests that something might be going wrong there.

`Error while sending QUERY packet. PID=30068 in phpmyadmin\libraries\classes\Dbi|DbiMysqli.php on line 213

ERROR

SQL query:
Select 'comment' from 'phpmyadmin'.'pma_column_info'
WHERE db_name = 'test3'
AND table_name = ''
and column_name = '(db_comment)'`

[musicpanda]

I had a look into my Mysql error log and I found many times the following:

2019-03-24 23:52:36 28632 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-03-24 23:52:36 28632 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).

[williamdes]

Is this still an issue?

[shucon]

I confirm that SQL import is very slow on PMA even after turning off XDebug on master.

[williamdes]

Hi @WayneGit1
Time was passed and code has improved. Could you let me know if it works better on the latest 5.1 version in development (phpMyAdmin 5.1+snapshot) ?