InnoDB understand cool backups.

[Pete Moreno]

Hi.

Running MySQL 5.5.x.

I was reading about backups, specifically Cool Backups, under FreeBSD we don't have the LVM features, was wondering was is the best way in this case to backup innodb tables.

1;Do a slow shutdown of the MySQL server and make sure that it stops without errors.
2;Copy all InnoDB data files (ibdata files and .ibd files) into a safe place.
3;Copy all the .frm files for InnoDB tables to a safe place.
4;Copy all InnoDB log files (ib_logfile files) to a safe place.
5;Copy your my.cnf configuration file or files to a safe place.

Question a) if u create a batch, how u validate step 1 if was success?

!#/bin/sh
service mysql-server stop

I know that before this I had to enable this in my my.cnf

'innodb_fast_shutdown=0'

Question b) we have 2 db:

db1
db2

Innodb create 3 files where it saves the tables data:

ib_logfile0
ib_logfile1
ibdata1

I know that is the main files with our data for those 2 db's.

The backup process say that we need to backup this files + .frm files+my.cnf.

Now, my doubt is, suppose that we backup all this files daily and for some reason we need to return the db data from Yesterday for db2.

How can I just recover that db data and not all the db(db1/db2), because I see that we are not doing separate backups we are taking all the files with this process, once I return back the files I will affect all db's, do I'm wrong?

Any tip and answer will be appreciated, thanks.