By milksamsa on

I would like to create a sort of package which includes the localization and the modules I use the most already installed and configured the way I prefer.

I would like also to retain the user roles and the basic user names (Admin, Editor, ecc...).

In this way I could use and reuse the original website as a starting "Template".

I thought the best way to achieve this is to simply copy all of the files contained in the root of the source website to another folder, then I would like to duplicate the entire database.

In PhpMyAdmin, though I get the following error when I try to duplicate the database with the following query:

sql query: 
INSERT INTO  `SOURCE_DATABASE`.`users` 
SELECT * 
FROM  `NEW_DATABASE`.`users`

Message from MySQL: 
#1062 - Duplicate entry '1' for key 1

But my table was actually non existent!

Could someone point me in the right direction to achieve a proper clean "ghost" copy?
Thank you.

⋅ Categories: Drupal 6.x

Comments

milksamsa’s picture

milksamsa commented

Just a clarification:
Obviously I ran the "Copy database" script inside PHPMYADMIN, not just the query above, which is the one returning the error and causing the whole SQL to give up.