> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/install/10.2-install/pentaho-installation-overview-cp/archive-installation/archive-installation-process/use-mysql-or-mariadb-as-your-repository-database-archive-installation/initialize-mysql-or-mariadb-pentaho-repository-database.md). # Initialize MySQL or MariaDB Pentaho Repository database The sections in this article take you through the steps to initialize the MySQL or MariaDB Pentaho Repository database. To initialize MySQL or MariaDB so that it serves as the Pentaho Repository, you will need to run several SQL scripts to create the Hibernate, Quartz, Jackrabbit (JCR), and Pentaho Operations Mart components. **CAUTION:** Use the ASCII character set when you run these scripts. Do not use UTF-8 because there are text string length limitations that might cause the scripts to fail. **CAUTION:** If you have a different password or user, make sure that you change the password or port number in these examples to match the ones in your configuration. **CAUTION:** Pentaho 10.2.0.0 and earlier versions use Quartz 1.x library, which is designated with a `QRTZ5_` prefix in the database. Newer versions, beginning with 10.2.0.1, use Quartz 2.x library, which is designated with a `QRTZ6_`prefix in the database. When upgrading from a previous version to Pentaho 10.2.0.1 and later, you must create the `QRTZ6_` prefixed table in the database by repeating the procedure for Quartz database creation, and then optionally migrating the existing Quartz schedules to the new Quartz database using the migration script. During this upgrade procedure, executing the SQL create script resets the corresponding Quartz database without loss of the original data. However, the other associated repository databases in 10.2.0.1 will be reset by SQL scripts if run and data will be potentially deleted. Always follow best practices and backup your data prior to proceeding. **Important:** Failure to complete the Quartz upgrade results in a Pentaho Server error at start-up. In addition to the server error, the following exception message is generated in the `catalina.log` file: ``` Missing Quartz library database error ``` --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.pentaho.com/install/10.2-install/pentaho-installation-overview-cp/archive-installation/archive-installation-process/use-mysql-or-mariadb-as-your-repository-database-archive-installation/initialize-mysql-or-mariadb-pentaho-repository-database.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.