I have been running ERPNext for a year as a Docker container. Unfortunately, the container became corrupted, and wouldn’t load any more.
I have re-installed the container but now have trouble accessing the database.
Everything from inside the container has gone, but I still have the sql database files:
root@Tower:~# ls -l /mnt/user/erpdata/
total 176212
drwx------ 1 65534 108 40960 Dec 9 2017 1bd3e0294da19198/
-rw-rw---- 1 65534 108 16384 Oct 2 2017 aria_log.00000001
-rw-rw---- 1 65534 108 52 Oct 2 2017 aria_log_control
-rw-r–r-- 1 root root 0 Oct 2 2017 debian-10.1.flag
-rw-rw---- 1 65534 108 50331648 Oct 30 09:58 ib_logfile0
-rw-rw---- 1 65534 108 50331648 Oct 30 09:58 ib_logfile1
-rw-rw---- 1 65534 108 79691776 Oct 30 09:58 ibdata1
-rw-rw---- 1 65534 108 0 Oct 2 2017 multi-master.info
drwx------ 1 65534 root 4096 Oct 2 2017 mysql/
-rw------- 1 root root 15 Oct 2 2017 mysql_upgrade_info
drwx------ 1 65534 108 27 Oct 2 2017 performance_schema/
I can re-install the docker container but if I point it at the saved database, it fails to start, apparently having trouble with the mysqld daemon which is stopping and starting repeatedly:
2018-10-30 12:44:57,707 INFO spawned: ‘mysqld’ with pid 503
2018-10-30 12:44:59,076 INFO success: mysqld entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2018-10-30 12:45:01,757 INFO exited: mysqld (exit status 0; expected)
2018-10-30 12:45:02,408 INFO spawned: ‘mysqld’ with pid 861
2018-10-30 12:45:02,408 INFO success: cron entered RUNNING state, process has stayed up for > than 10 seconds (startsecs)
2018-10-30 12:45:02,408 INFO spawned: ‘mysqld’ with pid 861
2018-10-30 12:45:02,408 INFO success: cron entered RUNNING state, process has stayed up for > than 10 seconds (startsecs)
2018-10-30 12:45:03,835 INFO success: mysqld entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2018-10-30 12:45:06,982 INFO exited: mysqld (exit status 0; expected)
2018-10-30 12:45:07,985 INFO spawned: ‘mysqld’ with pid 1219
2018-10-30 12:45:09,280 INFO success: mysqld entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2018-10-30 12:45:09,280 INFO success: mysqld entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2018-10-30 12:45:11,968 INFO exited: mysqld (exit status 0; expected)
2018-10-30 12:45:12,972 INFO spawned: ‘mysqld’ with pid 1577
2018-10-30 12:45:14,398 INFO success: mysqld entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2018-10-30 12:45:16,966 INFO exited: mysqld (exit status 0; expected)
2018-10-30 12:45:17,969 INFO spawned: ‘mysqld’ with pid 1935
2018-10-30 12:45:19,313 INFO success: mysqld entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2018-10-30 12:45:22,593 INFO exited: mysqld (exit status 0; expected)
2018-10-30 12:45:22,593 INFO exited: mysqld (exit status 0; expected)
I don’t have a ‘bench backup’.
Is there any way of recovering my data with a new installation of (dockerised) ERPNext?