Import deleted group by mysql backup?
By Edease
Hi Elggers,
we came into a situation where a user deleted a group, so sadly this one is not available on the site anymore. This particular group had lots of activity and was also important for other users.
However, we have made mysql backups, if I search in these files, the specific group can be found.
Question: is it possible to import just this group back to the databse. If so, what would be the best approach?
Note: The 'Delete group' option button has already been removed so this mistake cannot happen again.
Beginning Developers
This space is for newcomers, who wish to build a new plugin or to customize an existing one to their liking
- Juho Jaakkola@juho.jaakkola
Juho Jaakkola - 0 likes
- Edease@Edease
Edease - 0 likes
- Juho Jaakkola@juho.jaakkola
Juho Jaakkola - 0 likes
- Edease@Edease
Edease - 0 likes
You must log in to post replies.It is very difficult to bring back all the data manually.
Could you just replace the current database completely with the backup? Or is the backup already too outdated?
The backup is too outdated I'm afraid. The best chance I figured is to manually remove all the non-related mysql lines and import it again via myAdmin. (Which would be a huge task considering 280 000 + lines) So we really need to think if it is worth the trouble.
Lesson well learned. Thanks for the reply!
Also all the files added to the group have been removed from the dataroot. So it wouldn't be enough to restore just the database.
Yes, you are right. But still got those! (Also once a month a complete ftp backup)