Translate Toolkit & Pootle

Tools to help you make your software local

User Tools


MySQL and Pootle

Pootle supports running with several database systems through Django. Using MySQL is well tested and recommended. You can migrate your current database if you already have data you don't want to lose.

To use a MySQL database for Pootle instead of the default SQLite you need to create a new database and database user:

 mysql -u root -p
 > CREATE DATABASE pootle CHARACTER SET = 'utf8';
 > GRANT ALL PRIVILEGES ON pootle.* TO pootle@localhost IDENTIFIED BY 'pootlepassword';
 > FLUSH PRIVILEGES;

Next edit the /etc/pootle/localsettings.py file (found under the main Pootle directory if running from checkout) and modify the DATABASE_* options to use your newly created database

DATABASE_ENGINE = 'mysql'               # 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
DATABASE_NAME = 'pootle'                # Or path to database file if using sqlite3.
DATABASE_USER = 'pootle'                # Not used with sqlite3.
DATABASE_PASSWORD = 'pootlepassword'    # Not used with sqlite3.
DATABASE_HOST = ''                      # Set to empty string for localhost. Not used with sqlite3.
DATABASE_PORT = ''                      # Set to empty string for default. Not used with sqlite3.

As described on the installation page, database tables and initial data will be created on the first visit to Pootle.