How to change table prefix ?

Question

Please teach the change method of table prefix for installed system.

【Edit Source】
qa-config.php
define('QA_MYSQL_TABLE_PREFIX', 'qa101_');
  ↓
define('QA_MYSQL_TABLE_PREFIX', 'qa_');

【Chune MySQL】
ALTER  TABLE ・・・　

Will it be OK only by upper operation?　Is the SQL sentence to change table name in upgrading program(e.g. V1.1)?

Comments

Sorry, When ungrade, ALTER sentences are procesed in qa-db-install.php ...

Answer 1

You need to use MySQL's RENAME TABLE operation:

http://dev.mysql.com/doc/refman/5.0/en/rename-table.html

Comments

Thank you gidgreen. Because "passcheck" field of qa_users table is BINARY, I was puzzled a little. But EXPORT / IMPORT with phpMyAdmin succeeded.