Joomlatools Support Center

Error - The user specified as a definer ('userdb365'@'localhost') does not exist

Hi,

during MySQL dump with workbench I get the error:

mysqldump: Got error: 1449: The user specified as a definer ('userdb365'@'localhost') does not exist when using LOCK TABLES

for

DROP TABLE IF EXISTS `sijo_docman_file_counts`;
DROP TABLE IF EXISTS `sijo_docman_nodes`;

CREATE ALGORITHM=UNDEFINED DEFINER=`userdb365`@`localhost` SQL SECURITY DEFINER VIEW `

DB name: user365

How can I fix it?

Answer

Posted 2 years ago by Arunas Mazeika Staff

Hello Christian,

This happens because the user under the definer part of the create view query doesn't exists on the target DB server. All should be sorted out by simply changing that user with the one that you use on your new server. For this you need to manually make the change in the dump files.

Another option is to move your DOCman install by using the built-in exporter/importer available under settings. See: http://help.joomlatools.com/article/71-migrate-docman-3-to-a-different-site for more information.

I hope this helps.

There are 3 more comments in this ticket.
Subscribe or login to join the discussion!

Christian Ewe
19.05.17
Answered

System Information

3.0
n/a
n/a