I'm going to dump a considerable big datatabase (7gb) from a MySQL 5.1 instance running on Windows into a .sql script and import it into a MySQL 5.5 instance, also on Windows (another machine). I'd like to be able to monitor the process of both operations, since I believe they are going to take some time to execute.
Apparentely, this feature has not yet made into the target MySQL versions (http://stackoverflow.com/questions/8806435/how-to-implement-a-mysql-dump-restore-progress-bar). I also checked the solution suggested here, but it seems a lot of work (and also inserting more variables to this sensitive operation) to do something that should be simple.
By the time, ins't there any simple solution to monitor, somehow, the progress of these operations?
READ UNCOMMITTED
andcount(*)
the number of rows in your largest table. Not sure this is the best approach but it's just an idea. Alternatively, you can use Task Manager to make sure the processes are still running.