Hi there how are you doing?
Thanks for reading this question. We are in the process to migrate a Moodle 1.9.19+ site to restore it on a local Linux (ubuntu) machine for archive purpose. During the mysql dump restore process:
mysql -u root -p[password] archive < moodle_prod.sql
I ran into this error message:
ERROR 1449 (HY000) at line 29294: The user specified as a definer ('firstname.lastname@example.org') does not exist
How should I resolve this problem? I checked with the Moodle migration doc, but it doesn't seem to mention anything about this.
Basically I download the huge .sql (mysql dump) file from our hosting company, then did the "sed -e" thing to replace all the old domain names with the new archive server ip#. I created a new database named it "archive" and granted moodleuser the required rights for the database, but I guess the original DB (when the mysql dump was made) had different DB admin username and IP#. So should I just go ahead to replace ALL the DEFINERemail@example.com' SQL SECURITY DEFINER' with the new DB admin username (e.g. root, or moodleuser), with the new IP#?? Is that all needed to be done or should I do something different? Thanks!