Chapter 4. Back Up the Node

Procedure

1. Backup all tables other than the mysql tables.

   mysql -u root -e "select distinct table_schema from information_schema.tables where engine='innodb' and table_schema != 'mysql';" -s -N | xargs mysqldump -u root --single-transaction --databases > openstack_database-$TIMESTAMP.sql

   Copy to Clipboard Toggle word wrap

2. Backup all grants and account info from the database.

   mysql -uroot -s -N -e "SELECT CONCAT('\"SHOW GRANTS FOR ''',user,'''@''',host,''';\"') FROM mysql.user where (length(user) > 0 and user NOT LIKE 'root')" | xargs -n1 mysql -u root -s -N -e | sed 's/$/;/' > grants.sql

   Copy to Clipboard Toggle word wrap

   The backup procedure requires separately backing up the user accounts and grants, because they use ISAM tables.