Page 1 of 1

custom sql install

Posted: Sat Mar 07, 2009 6:04 am
by Simon66
Can anyone tell me if this is possible.

I've built my own basic site with form templates, administrators, page templates and custom CSS, then I exported the database as an SQL file.
Now I would like to use this custom SQL file as the extra.sql in the install/schemas folder, so that all new installs start with the basic layout I've created.

This has worked OK with just the core modules, but any SQL from modules like FormBuilder causes an error because the module isn't installed at the same time as the core modules.

Is there any way of adding modules to the install process, so that the extra.sql file works for those modules too?

Thanks
Simon66

Re: custom sql install

Posted: Sat Mar 07, 2009 8:58 am
by alby
Simon66 wrote: This has worked OK with just the core modules, but any SQL from modules like FormBuilder causes an error because the module isn't installed at the same time as the core modules.
Does not make much sense to me.

If you use this complete extra.sql for other install:
  build a new distribution with core+all no-core modules that you have in this extra.sql for new uploads

If you use this extra.sql for mantain your personalization of a few no-core modules only:
  build a new distribution with core+all no-core modules that you have in this extra.sql for new uploads
  edit your extra.sql and put active field to 0 for no-core modules
  (for re-use that modules update active field to 1)

If you use this extra.sql for your personalization of core modules and templates/css only (primary):
  uninstall all no-core modules
  dump THIS DB =>  extra.sql

Alby

Re: custom sql install

Posted: Thu Mar 12, 2009 6:10 pm
by Dr.CSS
Use all the folders/files from the build that you get the DB from, like the module folder you have now has FEU well just include it in the modules folder and install will/should install it with the rest of the core modules...

I've done this before but not with a DB added just ran install with non-core modules in module folder and they installed...