wow fantastic simon, it works, thanks!!! On Mon, 26 Jun 2023 at 09:35, robert k Wild <[email protected]> wrote:
> great, thank you simon, i will try the dump again and then the restore and > get back to you > > On Mon, 26 Jun 2023 at 07:49, Simon Avery <[email protected]> > wrote: > >> Hi Rob, >> >> >> >> Looks like that database has at least one stored function. Those aren’t >> exported by default but can be toggled with with --routines >> >> >> Try the same process, but with: >> >> >> >> mysqldump* --routines *-u root -p'password' aspera_console > >> /mnt/pixit/engineering/aspera_console/mysql_backups/20230623.sql >> >> S >> >> >> >> >> >> *From:* robert k Wild via discuss <[email protected]> >> *Sent:* Sunday, June 25, 2023 12:06 PM >> *To:* [email protected] >> *Subject:* [MariaDB discuss] mysql restore error >> >> >> >> hi all, >> >> i successfully backed up the database >> >> /opt/aspera/common/mysql/bin/mysqldump -u root -p'password' aspera_console > >> /mnt/pixit/engineering/aspera_console/mysql_backups/20230623.sql >> >> then i try to restore it, first i delete the database and create the >> database >> >> /opt/aspera/common/mysql/bin/mysql -u root -p'password' >> >> drop database aspera_console; >> >> create database aspera_console; >> >> then run the restore command and i get the error >> >> /opt/aspera/common/mysql/bin/mysql -u root -p'password' aspera_console < >> /mnt/pixit/engineering/aspera_console/mysql_backups/20230623.sql >> >> ERROR 1305 (42000) at line 80504: FUNCTION aspera_console.report_user_id >> does not exist >> >> luckily this is not the live vm, its a clone of the live, so im messing >> around >> >> thanks, >> >> rob >> >> >> >> -- >> >> Regards, >> >> Robert K Wild. >> > > > -- > Regards, > > Robert K Wild. > -- Regards, Robert K Wild.
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
