Knowledgebase

Import has exceeded the maximum execution time Print

  • database, cpanel, phpmyadmin, php, backup, troubleshooting, guide, howto
  • 0

A database or content import stopped partway.

WHAT IT MEANS

The import took longer than PHP permits and was terminated.

The database is now partly imported, which is worse than not starting.

THE FIX FOR DATABASE IMPORTS

Use the command line. Feeding a SQL file into the mysql client has no execution limit and is the correct method for anything substantial.

Over SSH, or ask us to run it.

IF YOU HAVE NO SSH

Raise max_execution_time and memory_limit in cPanel, then retry.

Split the SQL file into sections and import them in order.

Use cPanel partial backups rather than phpMyAdmin, which handle larger files.

FOR CONTENT IMPORTS

Most importers process in batches. If yours does not, look for one that does.

Reduce the batch size in the importer's settings where available.

BEFORE RETRYING

Drop the partly imported tables. Importing again over a partial result produces duplicate key errors on every row.

THE UNDERLYING POINT

Web requests are not the right tool for long operations. Use the command line.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot