I have a LAMP website with mysql backend with InnoDb engine for tables
I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. shutting down the website) for the duration of the backup.
I am surprised that I cant find this information anywhere - not even in the mySQL documentation. A lot of mention is made about mysqlhotcopy, but that only works for IMSAM tables - and is therefore of no interest/use to me.
Does anyone know if (how?) I can use mysqldump to take a copy/dump of a database that is still being used?.
A link to the official documentation would be very useful, since I want to make sure that I get this absolutely right.
I am running on Ubuntu 10.0.4 LTS