Unable to import website – Database error
-
I am trying to import a website in a new hosting that I purchased from Hostinger. The database connection is successful but it fails at the next stage.
EXCEPTION: Access denied; you need (at least one of) the SUPER privilege(s) for this operation TRACE: #0 /home/u454638363/domains/***HIDDEN**/public_html/dup-installer/ctrls/ctrl.s2.dbinstall.php(68): mysqli_query() #1 /home/u454638363/domains/***HIDDEN**/public_html/dup-installer/ctrls/ctrl.s2.base.php(141): DUPX_DBInstall->__construct()
I even tried selecting the option “Remove DEFINER from CREATE queries” since I suspected it to be an issue due to a mismatch of users when migrating to a new host. However, it still resulted in the same error.
Any help will be appreciated. I do not think the shared hosting providers will provide SUPER access to the database so there is no point asking them for help. Also, it should be possible to recreate the tables without special privileges, but it is not clear why it requires so.
The topic ‘Unable to import website – Database error’ is closed to new replies.