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.