I’m a noob at this so please bear with me.
Installed xtrabackup via the yum repos and from what I noticed, it replaced my mysqld server. Gave me quite a nightmare thinking I’d loose my data but it’s all good. I only have one complain now … mysqld logs is not showing up now. I have the correct config in my.cnf pointing to /var/log/mysqld.log but it’s not writing there. How do I fix it?
I went ahead with the innobackup script and gzip it up and here’s what I saw after several long hours. Should I be concerned that the backup wasn’t done properly? The rest of the backups above looks fine with only that last message which I think could be ignored as it’s just trying to unlock the tables. It could cause some problems with my current db? Thanks in advance
innobackupex-1.5.1: Resuming ibbackup
xtrabackup: The latest check point (for incremental): ‘227719398386’
log scanned up to (227719401863)
xtrabackup: Transaction log of lsn (227704425299) to (227719401863) was copied.
innobackupex-1.5.1: Error: mysql child process has died: ERROR 2006 (HY000) at line 13: MySQL server has gone away
while waiting for reply to MySQL request: ‘UNLOCK TABLES;’ at /usr/bin/innobackupex-1.5.1 line 479.