Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
DudeThatsErin Posted June 28, 2022 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.
Mark H Posted June 28, 2022 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
Miss_B Posted June 28, 2022 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.
DudeThatsErin Posted June 29, 2022 Author 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.
Recommended Posts