You should be able to reference that table using `backticks` or `Acute` , not single quote
mysql>rename table `CDC_Stature_for_age_charts_2 _20` to CDC_Stature_for_age_charts_2_20;
Here is reference:
http://www.grassrootsdesign.com/intro/char.php
