CMS Made Simple Forums

Is there a recommended way of generating an alternative 'extra.sql' file from a CMS install that I can use for future installs ?

My daughter has constructed a sample site, which includes pages, css and templates.  I would like to be able to load this in place of the current content that gets installed when one selects the 'load examples etc' during an install.

I am hoping that there might be a tool that I can use to dump the database in the correct format i.e. adding the {cms_prefix}, changing \n\r and quotes etc.  If there isn't would it be appropriate to simply 'pg_dump' some of the tables in sql format i.e. -a -d. and replace the extra.sql file or parts of it ?

Any suggestions ?

After installation you could make a dump file from MySQL database, and then for the new website:
1) Import that .sql file into a new database
2) Point your new CMSMS installation to that database, and during installation make sure you UNcheck the check box that says something like "Install Sample data/tables"

It should work.

By the way, if you use Captcha mocule - you will have to open cms_module_settings (or similar name) table and edit the Font Path setting for Captcha.

That is the approach I have been heading towards.  I was wondering how the extra.sql file was created in the first place. I had hoped that one of the developers had a script that could be run on the database that would output the appropriate records in the appropriate format.  This was on the assumption that the file wouldn't be edited by hand between releases when updates need to be incorporated e.g. additional columns in tables or new global settings etc.

I didn't want to redesign the wheel, hence the forum query first.  But it can't be that hard to write.  More a case of what needs to be captured.  I might have a look at writing something today.

Usually you can generate database dump file with the tools provided by your web hosting provider in their Control Panel.
Search for phpMyAdmin tool to access and manage MySQL - there you can do export of your database and save into a .sql file.

Also check the modules page of CMSMS - do a search for "ackup"
http://dev.cmsmadesimple.org/search/?ty ... rch=Search

You will find at least 2 modules which seems can make a backup /dump file of your wesite.

Hope this helps.