PageSeeder installation and upgrade instructions

Configuring MySQL

Install MySQL

PageSeeder supports MySQL 5.6.4 or higher (but not 8.0 or higher) and if this is a new installation it is generally best to install the latest release of 5.7 from .

  • On Linux use commands (CentOS 6) like:
$ rpm -Uvh
  • Or (CentOS 7)
$ rpm -Uvh
$ yum install mysql-server


If upgrading from MySQL 5.6 to 5.7 you need to edit the pageseeder/webapp/WEB-INF/config/ and add ?useSSL=false to the end of the DBURL e.g.


Also add (or modify) the following line in your MySQL my.ini or my.cnf:


Finally ensure that you have the mysql-connector-java-5.1.39.jar or later in pageseeder/webapp/WEB-INF/lib and drivers folders. Restart PageSeeder after making these changes.

Install the JDBC driver

PageSeeder communicates with MySQL via the JDBC driver, therefore this must be installed on the server. Download and install on the server the MySQL Connector/J (JDBC Driver) for the existing MySQL version.

If the MySQL is the latest release, it is generally best to install the latest release of the MySQL Connector/J from .


Do not use Connector/J v8 or later due to the possible error: "The server time zone value 'AEDT' is unrecognized or represents more than one time zone". Older versions should be listed under 'Archive' in the 'Downloads' section of the MySQL website.

  • On Linux use commands like below (URL and latest version may have changed):
$ wget
$ tar xzvf mysql-connector-java-5.1.45.tar.gz

The PageSeeder installer will ask for the location of the JDBC driver .jar file to be identified.

Use UTF-8mb4 character set

So that PageSeeder can handle special characters correctly (see Character Encoding), MySQL must be configured for UTF-8mb4. Doing so requires editing the following:

  • Windows (to see the ProgramData folder you may need to show hidden items)
\ProgramData\MySQL\MySQL Server 5.6\my.ini
  • Linux

Just below [mysqld] (add it if it doesn't exist) add or modify the following line:


Change any other character-set properties to utf8mb4

Add (or modify) the following line as shown:


If the server has excess RAM it is usually good practice to increase the InnoDB buffer to 80% of available RAM (minus the amount taken for other processes). For example with 6GB total RAM and PageSeeder using 1GB, the InnoDB buffer could be set to 4GB by adding:


Restart MySQL on Windows via the Services Control Panel or on Linux by typing: service mysqld restart
or: service mysql restart


If using Amazon RDS the only thing that MUST be set using DB parameter groups is character-set-server=utf8mb4


To increase the number of Database connections see  Database Properties.

Backup and restore


When manually creating a pageseeder database DO NOT use uft8mb4, DO use utf8 as shown below. However when backing up use --default-character-set=utf8mb4 and -r flag.

To backup the pageseeder database a command like this can be used:

$ mysqldump --single-transaction -u pageseeder -p --default-character-set=utf8mb4 -r ps.sql pageseeder

To restore the pageseeder database a command like this can be used:

$ mysql -u pageseeder -p pageseeder < ps.sql

If recreation of the database is needed before restoring, a command like this can be used:

$ mysql -u pageseeder -p
create database pageseeder character set utf8;
create user pageseeder@localhost identified by '<password>';
grant all on pageseeder.* to pageseeder@localhost;


If pageseeder is running on a different server to MySQL you will need to replace @localhost with @"%"

Created on , last edited on