I am trying to dump sql from local dev site to production server, I found that search_index & search_dataset these two tables are big, made the sql file really big.
I am guessing these two tables are about storing search indexes which I can always to re-index from scratch later. Correct me if wrong.
So is it OK/safe to delete all the records of them? then export the database, import to my server. By doing this I can reduce the file size of dump file.
Thanks!
drush sql-dump --structure-tables-list=search_index,cache,cache_form