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.
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
