Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
430 views
in Q2A Core by
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)?
by
Sorry, When ungrade, ALTER sentences are procesed in qa-db-install.php ...

1 Answer

+1 vote
by
You need to use MySQL's RENAME TABLE operation:

http://dev.mysql.com/doc/refman/5.0/en/rename-table.html
by
Thank you gidgreen. Because "passcheck" field of qa_users table is BINARY, I was puzzled a little. But EXPORT / IMPORT with phpMyAdmin succeeded.
...