How to find database name in OTRS

To set up a migration from OTRS, you need to provide the database name. There are two ways to find it:

Option #1: Use SQL Box

1. Go to the Admin tab - System Administration section.
2. Find SQL Box.
3. Run the query: SELECT DATABASE()

IMPORTANT: Do not include a semicolon (;) at the end of the query.

Option #2: Use the OTRS Installation Directory

Navigate to the directory where OTRS is installed (usually /opt/otrs).

Find the Kernel subfolder and open Config.pm file.

Look for the database connection parameters:

# ---------------------------------------------------- #

# database settings                                    #

# ---------------------------------------------------- #

# The database host

$Self-{'DatabaseHost'} = 'dbs.internal.relokia.com';

# The database name

$Self-{'Database'} = "otrs_5";

# The database user

$Self-{'DatabaseUser'} = "otrs";

# The password of database user.You also can use bin/otrs. Console.pl Maint::Database::PasswordCrypt

# for crypted passwords

$Self-{'DatabasePw'} = '4EngxZVE9LyuUhy3';

# The database DSN for MySQL == more: "perldoc DBD::mysql"

$Self-{'DatabaseDSN'} = "DBI:mysql:database=$Self-{Database};host=$Self-{DatabaseHost}";