The simpler media website CMS
... From the beginning:
I have more than 25.000 photos in my ZenPhoto-Installation. For few weeks it is beginning to have problems with the load of pages in the admin-area by editing the photos. It got worse over time. In the end, it ended up in the webpages no longer being completely loaded in the admin area. At this point, data from the database was no longer read completely and this had the effect that zenPhoto created the data of the photos for which no data was loaded in the database because of the on-the-fly. So the database was destroyed.
Since I have edited a backup of the database from the last photo, I have imported it into a test database as a test. I received the error code # 1118. The time can be limited to the database table 'images'. With this the import was canceled.
Error code # 1118 means that the rows are too big. The problem can be read here: "Row Size Too Large"
There is also a solution to the import problem. With this solution it is possible to import a backup into the database, but the data from the database is still not completely displayed on the website.
My website has been completely broken for 2 days and I can't find a solution. The Searchengine Bots are already working hard on the Uprank of my website.
I tried a new installation on a new web space. I have problems with my backup in the new installation. I have a mysqldump * .sql file. Every time I import this into the database, the zenPhoto installation webpage is displayed and when I click on Run the database is emptied again.
So my question would be, how can I use a mysqldump * .sql backup file when reinstalling zenPhoto?