Cannot import a database dump:
PLESK_ERROR: Unable to import the 'database_name' dump:
ERROR 1044 (42000) at line 21: Access denied for user 'user'@'localhost' to database 'database'
Traceback (most recent call last):
File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module>
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore
raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode)
Exception: program 'mysql' finished with non-zero exit code: 1
The dump is being imported under an existing user that already manages other databases.
- The database is absent on the server
Database dump contains permissions issued for another user that was utilized on a previous server.
Re-create the dump on the source, exporting only database tables and import the dump again.