Where are you backing up InnoDB data? You keep referring to DataDir but that is only for MyISAM.
Here is how we layout our customers:
basedir = /usr socket = /var/lib/mysql/mysql.sock tmpdir = /var/lib/mysql/tmp datadir = /var/lib/mysql/data log-error = /var/lib/mysql/log/error.log log-bin = /var/lib/mysql/binlog/binlog relay-log = /var/lib/mysql/relaylog/relaylog innodb-data-home-dir = /var/lib/mysql/innodb innodb-log-group-home-dir = /var/lib/mysql/innodb
If we only back'd up the datadir, we'd be missing out on tons of data necessary to completely rebuild a customer's database from the ground up.
« Back to merge proposal
Where are you backing up InnoDB data? You keep referring to DataDir but that is only for MyISAM.
Here is how we layout our customers:
basedir = /usr mysql/mysql. sock mysql/log/ error.log mysql/binlog/ binlog mysql/relaylog/ relaylog data-home- dir = /var/lib/ mysql/innodb log-group- home-dir = /var/lib/ mysql/innodb
socket = /var/lib/
tmpdir = /var/lib/mysql/tmp
datadir = /var/lib/mysql/data
log-error = /var/lib/
log-bin = /var/lib/
relay-log = /var/lib/
innodb-
innodb-
If we only back'd up the datadir, we'd be missing out on tons of data necessary to completely rebuild a customer's database from the ground up.