Home > database >  Nyloader recovery problem
Nyloader recovery problem

Time:09-25

Backup, using mydumper tool command is as follows:
Reference
mydumper -u root -p t 5-123456 - B employees - c - 10000000-300 - s l o backup


When using myloader recovery, however, is always an error!
Reference
/root @ test3 ~ # myloader -u root -p sbtest - 123456 - B v t 5-3 - d backup
Message: * * 5 threads created
* * Message: Creating the database ` sbtest `
* * Message: Creating table ` sbtest `. ` employees `
* * Message: Creating table ` sbtest `. ` titles `
* * Message: Creating table ` sbtest `. ` dept_emp_latest_date `
* * Message: Creating table ` sbtest `. ` dept_emp `
* * Message: Creating table ` sbtest `. ` current_dept_emp `
* * Message: Creating table ` sbtest `. ` dept_manager `
* * Message: Creating table ` sbtest `. ` the departments `
* * Message: Creating table ` sbtest `. ` salaries `
Message: * * Thread 4 restoring ` employees `. ` dept_manager ` part 0
* * Message: Thread 1 restoring ` employees `. ` titles ` part 0
Message: * * Thread 3 restoring ` employees `. ` the departments ` part 0
Message: * * Thread 2 restoring ` employees `. ` dept_emp ` part 0
Message: * * Thread 5 restoring ` employees `. ` employees ` part 0
Message: * * Thread 3 restoring ` employees `. ` salaries ` part 0
Message: * * Thread 4 shutting down

* * (myloader: 17625) : CRITICAL Error restoring sbtest. Titles from the file employees. Titles. SQL: MySQL server has gone away
* * Message: Thread 1 shutting down

(myloader: 17625) : * * * * : CRITICAL Error restoring sbtest. Dept_emp the from file employees. Dept_emp. SQL: MySQL server has gone away
Message: * * Thread 2 shutting down

(myloader: 17625) : * * * * : CRITICAL Error restoring sbtest. Employees from the file employees. Employees. SQL: MySQL server has gone away
Message: * * Thread 5 shutting down

(myloader: 17625) : * * * * : CRITICAL Error restoring sbtest. Salaries from the file employees. Salaries. SQL: MySQL server has gone away
Message: * * Thread 3 shutting down
* * Message: Creating table ` sbtest `. ` current_dept_emp `
* * Message: Creating table ` sbtest `. ` dept_emp_latest_date `



Ask why this is, a total of eight tables, 8 table has returned to success, the rest have imported without an error table data, but the rest of this a few why complains form data import process? The basic data were not online!
  • Related