I have used the phpMyAdmin Export/Import functions many, many times to move a MySQL database from one computer to another. It has always worked beautifully and very simply.
I have a new computer to which I want to move six databases.
The six .sql files that are being imported range in size from 7 KB to a bit over 1 MB.
Only the smallest file was successfully imported. All the others complain of a syntax error here or there.
If I break up the import .sql file into smaller chunks, the database can be recreated perfectly – no syntax errors reported.
Might there be a parameter that limits the size of the imported .sql file? I found “max_allowed_packet”, but it is set to 1 MB.