Add nice output for slow MySQL replication

alexmuller · alexmuller · commit f85ccc375e1e · 2015-11-06T10:48:01.000Z
Importing the dump might take a while so this lets people know
what's going on.
diff --git a/mysql.py b/mysql.py
@@ -86,6 +86,10 @@ def replicate_slave_from_master(master):
     run_mysql_command("STOP SLAVE")
     run_mysql_command("SET GLOBAL slow_query_log=OFF")
 
+    with hide('running', 'stdout'):
+        database_file_size = run("stat --format='%s' dump.sql")
+
+    print('Importing MySQL database which is {0}GB, this might take a while...'.format(round(int(database_file_size) / (1024*1024*1024*1.0), 1)))
     run('sudo -i mysql -uroot < dump.sql')
 
     run_mysql_command("START SLAVE")
