DudeThatsErin Posted June 28, 2022 Share Posted June 28, 2022 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. Link to comment Share on other sites More sharing options...
Mark H Posted June 28, 2022 Share Posted June 28, 2022 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 1 Link to comment Share on other sites More sharing options...
Miss_B Posted June 28, 2022 Share Posted June 28, 2022 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. Link to comment Share on other sites More sharing options...
DudeThatsErin Posted June 29, 2022 Author Share Posted June 29, 2022 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. Link to comment Share on other sites More sharing options...
Recommended Posts