Error with Restore 12.0.2

Maintaining my Dolibarr
1

Transferring a database from one installation to an other. The backup exportmethode was MySQL Dump (mysqldump). The errormessage is:
Error

Static analysis:

3 errors were found during analysis.

  1. Variable name was expected. (near " " at position 17)
  2. Unexpected beginning of statement. (near “mysqldump:” at position 0)
  3. Unrecognized statement type. (near “Error” at position 11)

SQL query:

mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces – -- Table structure for table llx_accounting_account – DROP TABLE IF EXISTS llx_accounting_account

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privile' at line 1

Gerhard

2

Hi,

Error message is saying that your database user doesn’t have the right to delete a table.
Use a different user or increase the rights of this user

3

Thank you for the answer.

In the meantime i checked the difference between the backup sql-file of the last positive re-import action with 11.0.4 and the actual sql-file. There is a difference in the log at the start. From 11.0.4 the log shows „(Provider) Server version 5.7.29-log“ and no error and from 12.0.2 the log „(Provider) Server version 5.7.31-log:

„mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces.“

After deleting this errormessage it was possible to import the sql-file. The installation is for testing. It seems to bee an error in the dump export routine of Dolibarr!

Gerhard