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 <Simon.Avery@atass-sports.co.uk> 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 <discuss@lists.mariadb.org> *Sent:* Sunday, June 25, 2023 12:06 PM *To:* discuss@lists.mariadb.org *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.

Glad you’ve got it sorted, Rob. From: robert k Wild <robertkwild@gmail.com> Sent: Monday, June 26, 2023 3:07 PM To: Simon Avery <Simon.Avery@atass-sports.co.uk> Cc: discuss@lists.mariadb.org Subject: Re: [MariaDB discuss] mysql restore error You don't often get email from robertkwild@gmail.com<mailto:robertkwild@gmail.com>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> wow fantastic simon, it works, thanks!!! On Mon, 26 Jun 2023 at 09:35, robert k Wild <robertkwild@gmail.com<mailto:robertkwild@gmail.com>> 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 <Simon.Avery@atass-sports.co.uk<mailto:Simon.Avery@atass-sports.co.uk>> 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 <discuss@lists.mariadb.org<mailto:discuss@lists.mariadb.org>> Sent: Sunday, June 25, 2023 12:06 PM To: discuss@lists.mariadb.org<mailto:discuss@lists.mariadb.org> 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.