PageSeeder installation and upgrade instructions

Configuring MySQL

Install MySQL

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


MySQL 8 is not yet supported by PageSeeder.

  • 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:


and to the end of the DBURL add


for example.


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.7\my.ini
  • Linux


Make sure that the encoding of this file is not changed from ascii when it is edited otherwise MySQL may not start.

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 overwriting an existing database it must first be dropped and recreated using commands like this:

$ mysql -u root -p
drop database pageseeder;
create database pageseeder character set utf8;
grant all on pageseeder.* to pageseeder@localhost;

If there is no existing database or pageseeder user they must be created using commands like this:

$ mysql -u root -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