5. Installing MySQL

FotoBilder requires a MySQL install of at least version 3.23.x, but highly recommends installing the latest stable release that is available, expecially if you're going to need clustering and replication abilities.

MySQL offers binaries for many operating aystems, including Win32 and several different ‘flavors’ of Unix. Installations on any of these systems should be fairly easy, as most offer a simple installation program that guides you through setup.

Create the Database.  Login to MySQL as the root MySQL user and create the database that will hold the FotoBilder data:

$ mysql -uroot -p
mysql> CREATE DATABASE fotobilder;
mysql> GRANT ALL PRIVILEGES ON fotobilder.* TO 
     > fb@'localhost' IDENTIFIED BY 'fbpass';

Note

If you know what you're doing, you can set this up however you like. You tell FotoBilder how to connect to its database server(s) in your fbconfig.pl, as detailed in: Section 2: Configuring %FB::DBINFO

Populate the Database.  In order to use your site, you're going to need to populate your MySQL database with the required information to get the service started.

$ cd $FBHOME
$ bin/upgrading/update-db.pl --runsql --populate
That'll bring your database schema up-to-date and populate it with any look-up data it needs.