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 http://www.mysql.com .
- On Linux use commands (CentOS 6) like:
$ rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm
- Or (CentOS 7)
$ rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
$ yum install mysql-server
If upgrading from MySQL 5.6 to 5.7, you need to edit:
and to the end of the
Also, add (or modify) the following line in your MySQL
Finally, ensure that you have the
mysql-connector-java-5.1.39.jar or later in
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 http://www.mysql.com .
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 https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.45.tar.gz $ 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
[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
service mysql restart
If using Amazon RDS, the only thing that MUST be set using DB parameter groups is
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
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; quit
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; quit
If pageseeder is running on a different server to MySQL, you will need to replace
Created on , last edited on