Backup/Restore...

Hi,

I try to make a Backup but i Get this error code? What should I do??
Thanks!!

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 16384 bytes) in /home/r269737/public_html/system/library/db/mysqli.php on line 18

Fatal error: Uncaught Exception: Error: Commands out of sync; you can't run this command now<br />Error No: 2014<br />REPLACE INTO `oc_session` SET session_id = '6bb58e24c07a8c83b541efb4b4', `data` = '{\"language\":\"fi-fi\",\"currency\":\"EUR\",\"user_id\":\"1\",\"user_token\":\"HylzrdIyO7OUr1Hm5Np4IGgLUcVbGuuy\"}', expire = '2022-08-24 10:45:02' in /home/r269737/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/r269737/public_html/system/library/db.php(45): DB\MySQLi->query('REPLACE INTO `o...') #1 /home/r269737/public_html/system/library/session/db.php(32): DB->query('REPLACE INTO `o...') #2 /home/r269737/public_html/system/library/session.php(81): Session\DB->write('6bb58e24c07a8c8...', Array) #3 [internal function]: Session->close() #4 {main} thrown in /home/r269737/public_html/system/library/db/mysqli.php on line 40

You could try increasing the PHP memory_limit setting. A better option is to do a backup through your hosting control panel or using phpMyAdmin.

I change it to 256, 512M but no help..

It is better to use your hosting backup than the one from Opencart

k2tec wrote: ↑

Wed Aug 24, 2022 8:28 pm

It is better to use your hosting backup than the one from Opencart

I totally agree. I use the backup function in Cpanel. Much better IMO.

As above, do this: https://www.antropy.co.uk/blog/opencart-backup-restore/

I would also logout of the OC admin and truncate the session table to optimize the platform due to this overloaded query.