The CVSi [1] version of SERi [2] contains extensively improved database maintenance scripts. The scripts are called seri [3]_mysql.sh, ser_postgres.sh, and ser_dbtext.sh. In addition to MySQL we now also "officialy" support PostgreSQL database.

Those scripts are very simple shell wrappers that can be used to create, destroy, backup or restore SER database. Each script is extensively documented, you can find out available options using -h command line option. The script contains lots of command line options that can be used to change the default database name, usernames and so on.

The SQL statements used to create tables and import initial data are stored in a separate file which resides in the same directory as the script (depending on installation). Those files are called my_create.sql and pg_create.sql. You can use the SQL scripts to create the database contents manually even if you cannot or do not want to use the shell wrapper. The SQL files are automatically generated from a common XML description of SER database.