Posted by:
Mchl
(---.neoplus.adsl.tpnet.pl)
You can also copy the whole \mysql\mysqlx.y.z\data directory. This way you make a copy off all databases on the server, no matter if the tables are MyISAM, INNOdb or anything else.
To restore, just copy the directory in same place
Remember to shut down the mysql server before doing both backup and restore (or at least make sure nobody else is working on it at that time).
See [
dev.mysql.com] for more information.