1

Setting automatic backups of MySQL database including table lock etc - MySQL Workbench?

view story
linux-howto

http://serverfault.com – We've got a Virtual Server with full ssh and root access running LAMP on Ubuntu Server. I've got a small computer in the office running ubuntu that isn't being used for anything. I thought I should use it to make and store (a copy of) our MySQL database backups. However, how do I go about backing up our databases? MySQL Workbench locks tables to avoid errors, amongst a host of other features, but does not have any planned automatic backup bits planned. MySQL Dumper doesn't specify that they can keep the database consistent. Source for information from this paragraph: I don't see the point o (HowTos)