#2969 (oK 3.2.6)import timeout when table already created
When I import a sql file comporting a CREATE TABLE statement without DROP one and lot of data for this table, phpmyadmin timeout rendering a blank page or not able to allocate memory.
exemples:
- create a table with sql file BDD_struct1.sql
- try to import again the same file
Result: phpMyAdmin report an error that the table is already created
- create a table with sql file BDD_struct1.sql
- try to import a file that create same table and insert 3 lines (BDD_struct-data1-3data.sql)
Result: phpMyAdmin report an error that the table is already created
- create a table with sql file BDD_struct1.sql
- try to import a file that create same table and insert 687 lines (BDD_struct-data1-687data.sql)
Result: blank page or memory allocation error after several minutes
- create a table with sql file BDD_struct1.sql
- try to import a file that only insert 687 lines (BDD_data1-687.sql)
Result: 687 line inserted correctly
tested with two config:
- phpmyadmin Version: 3.1.3.2
- Apache/2.2.11
- MySQL: 5.1.34
and
- phpMyAdmin Version: 3.2.4
- Apache/2.2.3
- Version du client MySQL: 5.0.32
Discussion
create only table
create table and insert 3 lines
create table and insert 687 lines
only insert 687 lines
About your two first tests, this is expected behavior. If you want to avoid the error, just use CREATE TABLE IF NOT EXISTS `phpbb_acl_groups`.
About your test #3, I can reproduce your problem under phpMyAdmin 3.2.5.
yes, sorry, I forgot to say that the test 1,2 and 4 were running as expected only the third one is wrong.
I was putting them to test that it was not a probleme with sql schema or data I wanted to import
Started to test this. If I add "IF NOT EXISTS" clause to the CREATE TABLE statement of test 3, it works.
Fixed in subversion, thanks for reporting.