Restoring MySQL database when moving hosting - Does it fail for anyone else?

[DudeThatsErin]

The below error is what I get when I try to import the entire DB.

I'm having to import each table separately because the limit in the php.ini file I need is insanely high and I don't feel comfortable changing it.
At least that was the only solution I could find in my google searches for this error in the past.

Is there a quicker way to do this? PHPMyAdmin says there are 6 pages worth of tables (with the default setting). That is insane.

[Mark H]

Importing a database which is larger than roughly 20 MB really should be done with the "mysql" command-line (SSH) utility. Using phpMyAdmin to import any database can be problematic.

If you have shell (ssh) access to your site, we'd recommend using that instead

[Miss_B]

If you do not have shell (ssh) access, try bigdump. It is an excellent tool that handles the import of the large files with ease.

[DudeThatsErin]

Alright, I will look into this in the future. I was able to do it as I found out PHPMyAdmin allows you to import multiple files at a time. When I realized that it made the process 1000x simpler but I'll check those if I have to do this again.