Timeline for Can I copy a MySQL database by copying the files? What do the files contain exactly?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 6, 2019 at 3:19 | comment | added | zeusstl | Regarding mysqlhotcopy:"This utility is deprecated in MySQL 5.6.20 and removed in MySQL 5.7" From: [dev.mysql.com/doc/refman/5.6/en/mysqlhotcopy.html] | |
| Jan 28, 2017 at 13:42 | comment | added | Olivier S | on recent distros lvm snapshots can be reverted to the origin, but it is probably not what you want for for managing database backups. | |
| Jan 21, 2016 at 8:50 | comment | added | Buttle Butkus | This seems like a fast way to backup the db. But what about switching that snapshot back so it becomes my live database again? That's the part I'm really concerned about. I can mysqldump my db in under 2 seconds. Restoring it is the slow part, taking 5-10 minutes. | |
| Nov 27, 2011 at 20:02 | history | answered | Olivier S | CC BY-SA 3.0 |