× NETGEAR will be terminating ReadyCLOUD service by July 1st, 2023. For more details click here.
Orbi WiFi 7 RBE973
Reply

Backup and restore Baikal database

chopin70
Virtuoso

Backup and restore Baikal database

Hi

 

can anyone help me manage backup and restore commands for Baikal database ?

Best regards

Model: RN524X|ReadyNAS 524X Premium performance Business Data Storage
Message 1 of 4
chopin70
Virtuoso

Re: Backup and restore Baikal database

Any help on this one ?

I digged everywhere into app folder and where I figured in root without a clue !

Message 2 of 4
chopin70
Virtuoso

Re: Backup and restore Baikal database

Further finding:

- Under Baikal /apps folder there is no populated database

 

There is actually a Baika database here:

/var/lib/mysql/baika/
root@NAS-01:/var/lib/mysql/baika

drwx------ 1 mysql mysql 414 Feb 1 14:32 .
drwx------ 1 mysql mysql 180 May 27 13:20 ..
-rw-rw---- 1 mysql mysql 8748 Feb 1 14:32 addressbooks.frm
-rw-rw---- 1 mysql mysql 8924 Feb 1 14:32 calendarobjects.frm
-rw-rw---- 1 mysql mysql 8968 Feb 1 14:32 calendars.frm
-rw-rw---- 1 mysql mysql 8716 Feb 1 14:32 cards.frm
-rw-rw---- 1 mysql mysql 65 Feb 1 14:32 db.opt
-rw-rw---- 1 mysql mysql 8642 Feb 1 14:32 groupmembers.frm
-rw-rw---- 1 mysql mysql 0 Feb 1 14:32 groupmembers.MYD
-rw-rw---- 1 mysql mysql 1024 Feb 1 14:32 groupmembers.MYI
-rw-rw---- 1 mysql mysql 12880 Feb 1 14:32 locks.frm
-rw-rw---- 1 mysql mysql 0 Feb 1 14:32 locks.MYD
-rw-rw---- 1 mysql mysql 4096 Feb 1 14:32 locks.MYI
-rw-rw---- 1 mysql mysql 8698 Feb 1 14:32 principals.frm
-rw-rw---- 1 mysql mysql 56 Feb 1 22:11 principals.MYD
-rw-rw---- 1 mysql mysql 8192 Feb 2 00:44 principals.MYI
-rw-rw---- 1 mysql mysql 8632 Feb 1 14:32 users.frm
-rw-rw---- 1 mysql mysql 48 Feb 1 22:11 users.MYD
-rw-rw---- 1 mysql mysql 3072 Feb 2 00:44 users.MYI

But, as you see, size is ridiculous compared to my data and time stamp shows it is not updated

 

Running "find" command at the root recursively for words such as "*baika*" or "*saber*" gives nothing useful

 

Under the config of the app from GUI, the path is 

/var/lib/mysql/baika

 

However, it is not used

Googling has no answer to this question too

I really want to be able to backup the database

Message 3 of 4
chopin70
Virtuoso

Re: Backup and restore Baikal database

This command seems to work:

mysqldump baika > '/volume_name/share_name/BaikalDump.sql'
Message 4 of 4
Top Contributors
Discussion stats
  • 3 replies
  • 3280 views
  • 0 kudos
  • 1 in conversation
Announcements