Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
Hello Team,
I have taken user database backup in /bd/sybase/mariadb-10.2.15-linux-x86_64 version.
Trying to load it into /local/data/mariadb-10.3.8-rhel-6-x86_64.
prepare statement is failing with below error.
Please advise.
bash-4.1$ mariabackup --prepare --export --target-dir=/bd/sybase/backup --user=root --socket=/tmp/mysqld.sock --databases=Events --password=Happy1234
mariabackup based on MariaDB server 10.3.8-MariaDB Linux (x86_64)
mariabackup: auto-enabling --innodb-file-per-table due to the --export option
mariabackup: cd to /bd/sybase/backup/
mariabackup: This target seems to be already prepared.
mariabackup: using the following InnoDB configuration for recovery:
mariabackup: innodb_data_home_dir = .
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
mariabackup: innodb_log_group_home_dir = .
mariabackup: Starting InnoDB instance for recovery.
mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2018-07-12 6:00:13 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-12 6:00:13 0 [Note] InnoDB: Uses event mutexes
2018-07-12 6:00:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-07-12 6:00:13 0 [Note] InnoDB: Number of pools: 1
2018-07-12 6:00:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-07-12 6:00:13 0 [Note] InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
2018-07-12 6:00:13 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-12 6:00:13 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Last binlog file , position 0
Prepare export : executing "/local/data/mariadb-10.3.8-rhel-6-x86_64/bin/mariabackup" --mysqld --defaults-file=./backup-my.cnf --defaults-group-suffix= --datadir=. --innodb --innodb-fast-shutdown=0 --innodb_purge_rseg_truncate_frequency=1 --innodb-buffer-pool-size=104857600 --console --log-error= --bootstrap < mariabackup_prepare_for_export.sql
2018-07-12 6:00:13 0 [Note] mysqld (mysqld 10.3.8-MariaDB) starting as process 4803 ...
2018-07-12 6:00:13 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182)
2018-07-12 6:00:13 0 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000)
2018-07-12 6:00:13 0 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
2018-07-12 6:00:13 0 [ERROR] Aborting
With regards,
Kiran Kumar