Search the Community

I have a problem that I think is database related. Prestashop is v1.6.0.6. I found that the db backup started to fail with an error that it could not find a schema for one table. I also had problems with a PrestaBackUP module that failed to complete, apparently timing out. Finding other reports suggested this might relate to the size of the database. The shop has only been online for a few months, with 300 orders placed, so not that many and not a huge site. But the database was 108Mb (compressed to 16Mb if backed up as .gz direct from phpMyAdmin). I tried to find out exactly what the Prestashop Cleaner module did with 'Database Cleaning', failed to locate information and ended up trying it. This reported removing 24 lines (only) from ps_cart. But I found huge numbers in the guest table - 65,000 of them - that had no attached data and I assume relate to robots. I deleted these as well as stats information in connections etc using a free module from catalogo-onliners that said 'This option delete all the fields from connections/expired vouchers/cart tables and optimize all tables'. It reported removing about another 65,000 entries. The database dropped from 108Mb to 91Mb, which still seems h uge. db Backup still fails to run. Is there anything else to try to make the database smaller? Is the database size related to the db Backup module not working, and how can its operation be repaired?

Presta 1.6.0.6. I have been developing a new shop in 1.6.0.6 and making frequent database backups using the native DB Backup. Worked fine: one click to accept the disclaimer and it makes a backup, one click to download the file. Now, first click brings the error message: 'The backup file does not exist', which of course doesn't exist because it hasn't made one (it's as if it has skipped to the second button and then found the first hadn't been used). Recent changes are a slew of module updates and the addition of a commercially released module for backups to Dropbox. The obvious thing is to blame this because it is the same topic - and because it does not work correctly in my shop. But the developer says that there is no connection between the module and the native D Backup files so there is no way that one can affect the other. I'd like to compare the DB Backup files with ones from a site backup and see if they have changed (and perhaps replace then to see if this solves the problem), but I don't know which files are involved. I obviously need to get DB Backup working again (it is a real pain to do an export from the host control panel). Has anyone any idea what has broken? How to fix this? Where the DB Backup files are located?

HI...I have successfully restored the database of my shop but they aren't reflecting any changes despite the fact that there was no error during the whole process