MySQL Forums
Forum List  »  Backup

InnoDB understand cool backups.
Posted by: Pete Moreno
Date: July 15, 2014 11:15AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB understand cool backups.
2303
July 15, 2014 11:15AM
1419
July 17, 2014 04:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.