+def db_backup_mkdir(path):
+ p = db_backup_pstrip(path)
+ owner = p.split('/')[0]
+ p_owner = '%s/%s' % (PATH_AFS_BACKUP, owner)
+ p_owner_vol = '%s/%s/%s' % (PATH_AFS_BACKUP_VOL, owner[0], owner)
+ if not os.path.islink(p_owner):
+ os.symlink(p_owner_vol, p_owner)
+ if not os.path.isdir(p_owner_vol):
+ os.mkdir(p_owner_vol)
+ subprocess.call(['fs', 'sa', p_owner_vol, 'system:anyuser', 'none'])
+ subprocess.call(['fs', 'sa', p_owner_vol, 'system:authuser', 'none'])
+ if owner == 'root':
+ subprocess.call(['fs', 'sa', p_owner_vol, 'system:sql-backup', 'none'])
+ #print owner
+ #print ' ', p_owner
+ #print ' ', p_owner_vol
+
+def tables_in_ibdata(cursor):
+ for db in get_dbs(cursor):
+ table_engines = get_db_tables_engines(cursor, db)
+ innodb_tables = [x[0] for x in table_engines \
+ if x[1] and x[1].lower() == 'innodb']
+ for table in innodb_tables:
+ path = '%s/%s/%s.ibd' % (PATH_MYSQL_DATA, table[0], table[1])
+ if not os.path.isfile(path):
+ yield '`%s`.`%s`' % table