# Error with Restore 12.0.2 **URL:** \ **Category:** Maintaining my Dolibarr\ **Created:** [August 22, 2020, 11:13am UTC](https://www.dolibarr.org/forum/t/error-with-restore-12-0-2/19444 "2020-08-22T11:13:43Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![genders](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/5e9695/32.png) [@genders](https://www.dolibarr.org/forum/u/genders)\ **Post date:** [August 22, 2020, 11:13am UTC](https://www.dolibarr.org/forum/t/error-with-restore-12-0-2/19444/1 "2020-08-22T11:13:43Z")
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 ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [August 22, 2020, 12:49pm UTC](https://www.dolibarr.org/forum/t/error-with-restore-12-0-2/19444/2 "2020-08-22T12:49:39Z")
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 ---
**Author:** ![genders](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/5e9695/32.png) [@genders](https://www.dolibarr.org/forum/u/genders)\ **Post date:** [August 23, 2020, 9:47am UTC](https://www.dolibarr.org/forum/t/error-with-restore-12-0-2/19444/3 "2020-08-23T09:47:29Z")
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