Tagged: backup and restore
20. March 2023 at 17:42 - Views: 208 #14938Gonçalo FariaParticipant
I am trying to do something as simple as creating a backup on a main host, move it to secondary host with otobo fresh installed and restore the backup from the main host, trying to make a DR strategy basically.
When i try to restore with otobo running i have this error message:
ERROR: Already existing tables in this database. A empty database is required for restore!
When it try to restore with otobo stopped i have this message:
DBI connect(‚database=otobo;host=db‘,’otobo‘,…) failed: Unknown MySQL server host ‚db‘ (-3) at /opt/otobo_install/local/lib/perl5/DBIx/Connector.pm line 31.
ERROR: OTOBO-restore.pl-08 Perl: 5.36.0 OS: linux Time: Mon Mar 20 16:23:38 2023
Message: Unknown MySQL server host ‚db‘ (-3)
Module: Kernel::System::DB::Prepare Line: 775
Module: /opt/otobo/scripts/restore.pl Line: 179
Can’t call method „fetchrow_array“ on an undefined value at /opt/otobo/Kernel/System/DB.pm line 860.
From the second message i assume it’s supposed to have it running, but should i wipe the DB before restoring?
ps: i am following this guide https://doc.otobo.org/manual/installation/10.1/en/content/backup-restore.html
Thank you very much,
21. March 2023 at 10:54 #14943marcel-grafParticipant
hello Gonçalo ,
I only used the backup and restore on a docker based installation.
Here I had to set the same database password for the new installation.
mysql -u root -p
Enter password: db password
SET PASSWORD FOR ‚otobo‘ = PASSWORD(‚the old One‘);
and i think you must drop the DB
DROP DATABASE otobo;
CREATE DATABASE otobo CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES ON otobo.* TO ‚otobo’@’%‘;
21. March 2023 at 18:02 #14953Gonçalo FariaParticipant
Thank you for the answer,
I managed to install the database, but i couln’t login with the root@localhost account from the original DB.
I will try to do a fresh install with a root@localhost password equal to the original DB, to check if i can see the data restored.
Thank you for the answer.
21. March 2023 at 19:19 #14960Stefan AbelParticipant
If you don’t know the root@localhost password, you can always reset it with the bin/otobo.Console.pl
- You must be logged in to reply to this topic.