Removing comments from database.
mikejd
Joined: 2006-06-30
Posts: 12 |
Posted: Mon, 2013-07-29 13:41 |
I have just had to update my website which is using Gallery2, as the host company was changing MySQL4 to MySQL5. This is now working correctly but I have a query about something I noticed while migrating the database. Some of the tables in the database are very large and I am not sure what these tables contain. One which is obvious is the 'Comments' table. This contains 4104 records and all appear to be spam. I do not have the comments module activated so I am unclear where they come from. Other large tables are : AccessSubscriberMap(4322), CacheMap(384), ChildEntity(4295), Entity(4322). How do I remove all the comments, and entries in other tables if possible. Can I just delete the records from the database?
|
|
Posts: 1642
Comments are now locked for this topic.