Home > database >  Mysql5.7 how to use the mysqlhotcopy to backup
Mysql5.7 how to use the mysqlhotcopy to backup

Time:01-29

I like using mysqlhotcopy to spare, fast!
But after 5.7 does not support, so I move the original mysqlhotcopy come in directly.
There was a problem but use:
101 tables Locked in 0 seconds.
DBD: : mysql: : db do failed: Table 'user' was not locked with LOCK TABLES at/usr/bin/mysqlhotcopy line 507.

I search for, presumably mysql tables in the lock, the copy before you
https://lists.mysql.com/commits/76105

I tried in accordance with the above method, still won't do,


Someone used?

If you do make uncertain, I can only use mysql5.6,
My database is big, need daily backup, use the mysqldump too time consuming
  • Related