Error guide
max_allowed_packet Error
MySQL rejects a statement that is larger than the configured packet size.
SQL import error guides
Quick, practical fixes for the most common MySQL and phpMyAdmin import errors.
Error guide
MySQL Error 1064: SQL Syntax Error on Import
The parser rejects a statement — usually a bad split, a version mismatch, or a truncated file rather than a real syntax problem.
Error guide
MySQL Error 1146: Table Doesn't Exist
INSERTs ran before the table was created — an ordering problem, usually from importing split chunks out of sequence.
Error guide
MySQL Error 2006: Server Has Gone Away
Your import dies mid‑way because the server drops the connection or hits packet limits.
Error guide
MySQL Error 2013: Lost Connection During Query
The connection drops while importing a large or slow statement.
Error guide
phpMyAdmin Import Timeout
phpMyAdmin times out when the import takes too long or the file is too big.
Error guide
Access Denied: You Need SUPER Privilege (DEFINER Error)
Views, triggers, and routines fail to import because their DEFINER points to a user that doesn't exist on the new server.
Error guide
Unknown Collation: utf8mb4_0900_ai_ci
A MySQL 8 dump won't import into MariaDB or MySQL 5.7 because they don't recognise the utf8mb4_0900_ai_ci collation.