7 hours ago, psauleda said:I tried, but still got a timeout error while upgrading database:
All files upgraded. Now upgrading database...
[Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Gateway Timeout " jqXHR: "
504 Gateway Time-out
on php i've got
max_execution_time = -1
and on apache:
TimeOut 150000
KeepAliveTimeOut 10000
So i don't know why the timeout in a few minutes...
there's no way of doing it with the cli but without doing the backup?
I'm not sure about that, but it might be sql server connection timeout.
Also working on a backup is much safer and doing it on your localhost gives you more resource to use. Do you know on which part of database it returns error?
What i would do is to try and do upgrade on a backup site with database without data from these large tables. Check if it works, then try to import data into those tables with exported table data.
Before you do that check the structure of both tables from your old prestashop and new one.
These is just my guess, so be careful before you do this on your proper site.
Hope this gives you some ideas.