backup and restore

[Gonçalo Faria]

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 2023 Message: Unknown MySQL server host ‚db‘ (-3) Traceback (1): 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,
Best,
Gf

[marcel-graf]

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‘);

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

 

 

[Gonçalo Faria]

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

[Stefan Abel]

Hello,

If you don’t know the root@localhost password, you can always reset it with the bin/otobo.Console.pl

Cheers,
Stefan

[Autor]

Beiträge