Hi guys, got a quick question:
I have a Master - Slave setup running. I’d like to copy the backed up files to offsite backups. Do i need to keep ibdata1?
I am taking a backup off of the slave:
$>innobackupex-1.5.1 --slave-info --user=root --password=XX --databases=“db1” .
Then I am running:
$> innobackupex-1.5.1 --apply-log 2011-03-02_14-20-10
After doing this, am i free to delete ibdata1???
ibdata1 is about 1 gig in size, the database directory: 2011-03-02_14-20-10/db1 is only around 12 meg.
Is it safe to just delete the ibdata1 file?
will everything i need be in 2011-03-02_14-20-10/db1 directory?
Thanks in advance
Jon