Chapter 6. Creating The Initial WACS Databases

Table of Contents

Overview: WACS Database Creation
Creating Initial Databases With wacssetup
wacssetup itself
After wacssetup
Manual Database Creation Steps
1. Create the WACS database account (MySQL)
2. Create the necessary database schemas
3. Create default database contents (optional)
4. Import sample model records (optional)
5. Import sample set records (optional)

Overview: WACS Database Creation

Once you've installed the WACS packages on your computer, the next step is to actually get WACS itself up and running. Since WACS is expected to have a huge number of images and video clips to look after and a whole lot more information about how they relate to one another and what they contain, it uses a database to store all the information it needs. WACS can in fact use pretty much any relational database package for that although we currently support just two options: MySQL 5.x and Oracle 10/11. However before WACS can use that relational database, it needs to have it's own database account, workspace area, data structures and configuration data created. This can be fairly complex task unless you're an experienced DBA (DataBase Administrator) and this chapter will guide you through this process.

When it comes to creating the initial databases needed by WACS in order to function, you have up to three possible options:

[Tip]Tip

If you have installed WACS using either the Ubuntu .deb or Fedora .rpm packages, you'll almost certainly find that using the new wacssetup web application will be the easiest option.

[Note]Note

If you are doing the installation with easyinstall the necessary steps are taken as part of that process and you don't need to replicate them.