Automation Of Site Configuration

Preparations of a SQL file including site configuration information from an existing website Step 1: Go to an existing website which all configurations under administer are done Step 2: Go to Home->Administer->Menus->Secondary links, delete all secondary menu Step 2: Go to Home->Administer->Content management->Backup and Migrate, click Backup/Export DB Step 3: In this screen: 3.1 Do NOT select any items under Exclude the following tables altogether (all tables will be included.) 3.2 Do NOT select the below items under Exclude the data from the following tables (the below tables’ contents will be included.) actions authmap blocks fckeditor_role fckeditor_settings filter_formats filters image image_attach languages ldapauth menu_custom menu_links menu_router node_access node_type permission role system themekey_paths users variable views_display views_view vocabulary vocabulary_node_types

3.3 Select No Compression radio button and Download radio button, Timestamp format is as: Y-m-d\TH-i-s, and check the checkbox of Save these settings Step 4: Click Backup Database button Step 5: The popup window allows saving the SQL file into the desktop.

Automation of Site Configuration for a Brand New Site Step 1: Create a brand new site Step 2: Open this brand new site, go to Home->Administer->Site building ->Modules, select Backup and Migrate, and save Step 3: Go to Home->Administer->Content management->Backup and Migrate, click Restore/Import DB Step 4: Browse a SQL file which includes site configuration information, and click Restore Database Step 5: Remove all users except admin and all roles except anonymous user and authenticated user from database tables 6.1 connect to new site database 6.2 delete from users where uid <>1 and uid <>0; 6.3 delete from roles where rid <>1 and rid <>2;