Schlagwörter: backup and restore
-
AutorBeiträge
-
-
20. März 2023 um 17:42 Uhr - Views: 764 #14938
Hi,
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 2023Message: Unknown MySQL server host ‘db’ (-3)
Traceback (1):
Module: Kernel::System::DB::Prepare Line: 775
Module: /opt/otobo/scripts/restore.pl Line: 179Can’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.htmlThank you very much,
Best,
Gf -
21. März 2023 um 10:54 Uhr #14943
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 passwordSET PASSWORD FOR ‘otobo’ = PASSWORD(‘the old One’);
FLUSH PRIVILEGES;
———————————————————–
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’@’%’;
———————————————————–
Greetings,
Marcel
-
21. März 2023 um 18:02 Uhr #14953
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.
Best,
Gf -
21. März 2023 um 19:19 Uhr #14960
Hello,
If you don’t know the root@localhost password, you can always reset it with the bin/otobo.Console.pl
Cheers,
Stefan
-
-
AutorBeiträge
- Du musst angemeldet sein, um auf dieses Thema antworten zu können.