In my Drupal database I have so many field_deleted_data_XX and field_deleted_revision_XX tables. I have disable the revision entity but I want to delete these existing revision created tables, can I delete these tables directly or Is there any SQL script to delete unused tables from the database.
1
-
1Just run cron a few times– Clive ♦Commented Feb 1, 2017 at 13:57
Add a comment
|
1 Answer
You can safely remove them yes. You can use drush to delete these tables: run drush eval 'field_delete_field("yourfield")' and run cron afterwards with drush cron.
answered Feb 1, 2017 at 13:59
-
OK thanks I will try using drush but how to run using cron? can you give some example. Commented Feb 1, 2017 at 14:10
-
drush cris a rebuild (drupal_flush_all_cachesplus some D8 specific things related to the autoloader),drush cronruns cron.– mpdonadio ♦Commented Feb 1, 2017 at 14:20 -
Also the run cron option from the system status report page will do it. Commented Feb 1, 2017 at 14:32