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.gzand.sql.zipfiles directly, which are much smaller than raw SQL. - Split large dumps into smaller files using a tool like
mysqldumpwith the--tablesflag to export one table at a time.