Date: Fri, 29 Mar 2024 08:42:25 +0000 (UTC) Message-ID: <1242623904.61.1711701745776@ee247a49ef7d> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_60_1239541691.1711701745776" ------=_Part_60_1239541691.1711701745776 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
If we are importing the database dump which has DEFINER entries it cause= s errors while importing the database because DEFINER contains the database= user and hostname of the database server. It has to match with the databas= e server and database user who is importing it. If it does not match then i= t shows errors like "Error 1227 (42000): Access denied; you need (a= t least one of ) the SUPER privilege(s) for this operation"
Change directory to the database dump file. Unzip the database dump.
unzip O= PENSPECIMEN_26-03-2019.zip or gunzip OPENSPECIMEN_26-03-2019.SQL.gz
sed -e = 's/DEFINER=3D[^ ]* / /' OPENSPECIMEN_26-03-2019.SQL > OPENSPECIMEN_26-03= -2019-NEW.SQL
To check all definer entries are removed open the newly generated dump f= ile and search for DEFINER keyword into it.
If no entry is found for DEFINER, import newly generated database dump i= nto the database.