phpMyAdmin

phpMyAdmin Upload / Import Limit

DBEverywhere's phpMyAdmin instance has a file upload limit for imports. This is a PHP configuration constraint that applies to all phpMyAdmin installations.

What the Limit Is

The default upload limit is determined by the PHP settings in the phpMyAdmin Docker container. Typically this is around 50MB for file uploads. Files larger than this will be rejected by phpMyAdmin before the import even starts.

Importing Large Files

If your SQL dump or import file exceeds the upload limit, use the MySQL command line instead:

mysql -h your-database-host -u your-username -p your-database-name < file.sql

You'll be prompted for your password. This method has no file size limit and is significantly faster for large imports.

For compressed files:

gunzip < file.sql.gz | mysql -h your-database-host -u your-username -p your-database-name

Adminer as an Alternative

If you need a browser-based option and your file is moderately large, Adminer tends to handle larger file uploads better than phpMyAdmin. However, DBEverywhere automatically routes MySQL/MariaDB connections through phpMyAdmin, so this isn't a direct option for MySQL databases.

Tips for Staying Under the Limit

  • Export specific tables instead of the entire database when you only need a subset.
  • Use compression — phpMyAdmin can import .sql.gz and .sql.zip files directly, which are much smaller than raw SQL.
  • Split large dumps into smaller files using a tool like mysqldump with the --tables flag to export one table at a time.