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.

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

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.

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.