We did a massive migration a while back, several hundred thousand rows. Needless to say we now have a bunch of migrate tables that we could do without.

I've disabled the migrate modules but before I dropped the tables (or should I truncate?) I wanted to make doubly sure that this will have no affect on anything.

Thanks in advance.

2 Answers 2


So, I deleted the tables (actually truncated them) on my dev server and there have been no side effects that I have noticed, so will try deleting the tables in their entirely. The migrate tables made up around 600mb in a dump.


It seems it's usefull to keep the migrate tables while you are working on migration, in case you need to see the mapping and revert/redoing stuff.

But actually I was having some troubling while using the migrate module for other pursings. This SQL error: SQLSTATE[HY000] [2002] No such file or directory did keeping show up when I did try to use drush migrate:... till delete those tables.

With this query you can delete all table with prefix migrate

               FROM information_schema.TABLES
              WHERE TABLE_SCHEMA = 'db'
                AND TABLE_NAME LIKE 'migrate\%');
SET @delStmt = CONCAT('DROP TABLE ',  @tbls);
-- SELECT @delStmt;
PREPARE stmt FROM @delStmt;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.