Question Attempt to restore the "psa" database from a dump fails.

[mariodieck]

Server operating system version

Debian 12.12

Plesk version and microupdate number

Plesk Obsidian 18.0.74 Update #1

Hello, I'm trying to restore the "psa" database from a previous dump. Unfortunately, this is failing.

I followed the instructions in this article:

https://support.plesk.com/hc/en-us/articles/12376961269783-Unable-to-restore-the-Plesk-psa-database-ERROR-1813-HY000-at-line-104-Tablespace-for-table-psa-tablename-exists-Please-DISCARD-the-tablespace-before-IMPORT

zcat mysql.daily.dump.5 | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin --default-character-set=utf8

outputs the following:

ERROR 1265 (01000) at line 8451: Data truncated for column 'event_type' at row 22


Then I followed the instructions in this article:

https://support.plesk.com/hc/en-us/articles/13302882691735-An-attempt-to-restore-psa-database-from-a-dump-fails-with-Data-truncated-for-column-event-type-at-row

But unfortunately, I then get an error message that looks like this:

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

outputs the following:

mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
--------------
/ !40000 ALTER TABLE `exp_event` ENABLE KEYS */
--------------


ERROR 1064 (42000) at line 8434: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '/ !40000 ALTER TABLE `exp_event` ENABLE KEYS */' at line 1

What's the problem with that?

 

[Sebahat.hadzhi]

Hello, @mariodieck . Is the database in question considerably large and can you confirm how exactly are you attempting to restore it, please?