Database import fails: There can be only one TIMESTAMP column

Symptoms

The database import or migration either using Plesk interface or CLI utility fails:

PLESK_ERROR: Traceback (most recent call last): File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module> File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main restore(options, password) File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode) Exception: program 'mysql' finished with non-zero exit code: 1

# mysql -u USERNAME -p***** DATABASENAME < MYSQL_DATABASE.sql
ERROR 1293 (HY000) at line 52700: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Traceback (most recent call last): File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module> File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main restore(options, password) File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode) Exception: program 'mysql' finished with non-zero exit code: 1

Cause

The issue is caused by legacy code in MySQL/MariaDB. It has been resolved in MariaDB 10.0 and MySQL 5.6.5.

Resolution

To resolve the issue an upgrade of MySQL/MariaDB must be performed.

Please, refer to the article How to upgrade MySQL 5.5 to 5.6/5.7 on Linux.