How can I increase the max db upload size?
So I imported a few databases with success. But there was one database that I wasn't able to import. And I think it's because the file size is too big. I did some research on the error, and some websites say I have to increase the max_allowed_packet_size. Other websites say that I have to increase the maximum upload db size and max upload. So which configuration file do I need to edit to fix this? I have tried messing with the php.ini file, but since this is php7, I am not sure which is the correct one that I have to configure.
- Attachments
-
- database.png (215.66 KiB)
-
myVesta
- Site Admin
- Posts: 932
- Joined: Fri Jun 19, 2020 9:59 am
- Has thanked: 8 times
- Been thanked: 6 times
for php values, see viewtopic.php?f=18&t=54
I suggest you to import dump from SSH console:
I suggest you to import dump from SSH console:
Code: Select all
mysql database_name < dumpfile.sql