In addition to what dimopoulos said:
I just checked the MySQL doc, and there's a RENAME TABLE command, so that might be a more "official" way of doing it.
Just make sure that no one is using the database at the time, and change the table prefix in the config file to match the table names.
Backing up the database first would be a good idea too.