#4067 (ok 4.4.1) Import Resume at breakpoint failure


Issue: Importing 'large files'. With the 'Allow the interruption of an import in case the script detects it is close to the PHP timeout limit.' ticked. The PHP timeout is reached at varying points when importing an .sql.zip file. The zipped file is 4.6MB. The raw sql file is 32.7MB. Up to this latest version 4.0.5 of PhpMyAdmin the import would usually break and when reloaded would resume the import at the break point. Now, reloading the file, causes PhpMyAdmin to attempt to reimport the file from the beginning giving a fatal error that "Table Admin already exists". The only solution I have found is to start the import, wait until the timeout occurs, uncompress the upload file on my machine, delete the contents of the raw sql file that have managed to upload, recompress the remaining file and upload again. This sometimes requires that this process is repeated before the whole 32.7MB is uploaded with all the attendant risks of errors being made at each point. Can you please fix the import mechanism so that the import does indeed resume at the broken point. Thanks.


  • Marc Delisle
    Marc Delisle

    are you confirming that all was fine with version 4.0.4?

    Also, which PHP version are you running?

  • Hi Marc

    Thanks for the rapid reply.

    I manage a database (among other jobs) for a client Volunteer Centre. The
    database is held on a remote ISP (Orcon.net.nz New Zealand) system
    using PhpMyAdmin version 2.10.1. I have been required by the Board of
    Trustees of the Volunteer Centre to back up this database on an alternate
    ISP (FreeParking.co.nz New Zealand) system for their business continuity

    The second ISP has recently upgraded their system to the latest version of
    PhpMyAdmin (4.0.5) and since the upgrade I've been forced to find a work-
    around to the Import function. I did not record what version of
    PhpMyAdmin was in use previously but I can check with the ISP. The ISP
    does not record the version of PHP in use although I can request that php
    extension are processed using version '4' or '5'.

    I do have a note with them asking their techs to increase the PHP timeout
    period to try to overcome the problem but it will not solve the brokenness
    of the current version of PhpMyAdmin, only make my task easier if the
    timeout period is lengthened.

    All the best
    Chris Streatfield.

    Last edit: Marc Delisle 2013-08-25
  • Marc Delisle
    Marc Delisle

    Yes, it would help knowing their previous phpMyAdmin version before the upgrade.

  • Marc Delisle
    Marc Delisle

    how about versions 4.0.9 and 4.1.0-rc1 ?

  • Marc Delisle
    Marc Delisle

    • Priority: 5 --> Normal
    • assigned_to: Madhura Jayaratne
    • summary: Import Resume at breakpoint failure --> (ok 4.4.1) Import Resume at breakpoint failure
    • status: open --> resolved
    • Priority: Normal --> Low
  • Marc Delisle
    Marc Delisle

    • Status: resolved --> fixed