Recently I have been trying to duplicate Drupal’s database using MySQL queries. To copy MySQL table, it is enough to execute the following queries: CREATE TABLE table_new LIKE table_old; INSERT INTO table_new SELECT * FROM table_old; These queries will preserve original table structure and indexes. Everything looks OK until you try to copy Drupal’s “users” [...]