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

Migrate/Move/Backup/Restore Photos II on 4.2.27

recap72
Aspirant

Migrate/Move/Backup/Restore Photos II on 4.2.27

Hello together :idea:
i was trying to move my Photos 2 content from my PRO to my NVX. I read About here: http://www.readynas.com/forum/viewtopic.php?f=145&t=68076&p=378908&hilit=backup+photos+II#p378908 .

Now my Problem is, it seems mysql is not @ the same place or does just work different then on a nv+. Does someone know anything about and how I could manage to move my Photos 2?

ThanX for any Help.
Message 1 of 6
mdgm-ntgr
NETGEAR Employee Retired

Re: Migrate/Move/Backup/Restore Photos II on 4.2.27

Where do you get stuck in the procedure you linked to. Can you show the output you get?
Message 2 of 6
recap72
Aspirant

Re: Migrate/Move/Backup/Restore Photos II on 4.2.27

Hello, thank you for your reply: Following my steps:
On the Original (source) disks:
1. Connect the USB drive ----> OK
2. Login (SSH) to ReadyNAS as root ----> OK
3. Copy the contents of the .RNP2 directory to the USB drive - contains photos, titles and Music
cp -pr /c/.RNP2 /USB/USB*/.RNP2 ----> OK
4. Copy the contents of the mysql directory to the USB drive - contains the Host Name, Photographer, and Contacts
cp -pr /var/lib/mysql /USB/USB*/mysql ----> NOT OK

I simply do not have /var/lib/mysql .(SSH) Maybe the mysql is somewhere else, or it uses another db on 4.2.27 Systems?! So I cannot copy, nor stop the process.
Any idea? (By the way, I searched the same on the NVX (I made a new RNP2 Project on NVX to be sure and could not find such Directory either [I'm not a common SSH user, maybe here's the BUG])
Thank you...
Message 3 of 6
mdgm-ntgr
NETGEAR Employee Retired

Re: Migrate/Move/Backup/Restore Photos II on 4.2.27

Odd. I have /var/lib/mysql on my system which has Photos II installed.

PM me the output of

# cat /etc/mysql/my.cnf
Message 4 of 6
recap72
Aspirant

Re: Migrate/Move/Backup/Restore Photos II on 4.2.27

ThX will check later. Got info to search this way -> ls -lisa /var/lib(/mysql)

Will Keep informed
Message 5 of 6
recap72
Aspirant

Re: Migrate/Move/Backup/Restore Photos II on 4.2.27

MyNVX:/# ls -lisa /var/lib
total xx
63490 4 drwxr-xr-x 23 root root 4096 2014-10-15 22:57 .
63489 4 drwxr-xr-x 17 root root 4096 2014-10-15 22:57 ..
32 4 drwxr-xr-x 4 admin root 4096 2015-02-15 21:26 mysql

Oh my dear, here it is. Did not know they could be hidden... So here it is. Now Almost embarrassed, but thank you.
Here your request:
MyNVX:/# cat /etc/mysql/my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = admin
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
skip-name-resolve
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
# bind-address = 127.0.0.1
skip-networking
innodb_buffer_pool_size = 6M
key_buffer_size = 16k
myisam_sort_buffer_size = 16k
max_connection = 20
#
# * Fine Tuning
#
key_buffer = 16k
max_allowed_packet = 16M
thread_stack = 128K
#
# * Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 32768
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
#log-bin = /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size = 16384
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M

THANK YOU
Message 6 of 6
Top Contributors
Discussion stats
  • 5 replies
  • 3295 views
  • 0 kudos
  • 2 in conversation
Announcements