Symptoms
Restoration of the psa database fails with:
CONFIG_TEXT: ERROR 1265 (01000) at line 3506: Data truncated for column 'event_type' at row 265
Cause
Unclear.
Resolution
-
Connect to the Plesk server via SSH.
-
Switch to the directory with daily dumps:
# cd /var/lib/psa/dumps
-
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
-
Find the line that starts with:
CONFIG_TEXT: INSERT INTO `exp_event` VALUES
-
Put the courser at the beginning of this line and type "dd" to remove it.
-
Save the changes and close the file.
-
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
Comments
0 comments
Please sign in to leave a comment.