Restoration of the psa database fails: Data truncated for column ‘event_type’ at row

Symptoms

Restoration of the psa database fails with:

ERROR 1265 (01000) at line 3506: Data truncated for column 'event_type' at row 265

Cause

Unclear.

Resolution

1. Connect to the Plesk server via SSH.

2. Switch to the directory with daily dumps:

   # cd /var/lib/psa/dumps

3. Unpack the .gz backup file from which you want to restore:

   # gunzip mysql.daily.dump.0.gz

   Open the file in a text editor. In this example, we are using the vi editor:

   # vi mysql.daily.dump.0

4. Find the line that starts with:

   INSERT INTO `exp_event` VALUES

5. Put the courser at the beginning of this line and type "dd" to remove it.

6. Save the changes and close the file.

7. Restore the database from the unpacked file:

   # cat mysql.daily.dump.0 | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin