æä¾ä¸ç§æ¹æ³ï¼
1. RENAME DATABASE db_name TO new_db_name
è¿ä¸ªããè¿ä¸ªè¯æ³å¨mysql 5.1.7ä¸è¢«æ·»å è¿æ¥ï¼å°äº5.1.23åå»æäºã
æ®è¯´æå¯è½ä¸¢å¤±æ°æ®ãè¿æ¯ä¸è¦ç¨ç好ã
2.å¦æææ表é½æ¯MyISAMç±»åçè¯ï¼å¯ä»¥æ¹æ件夹çåå
å
³émysqld
ædataç®å½ä¸çdb_nameç®å½éå½å为new_db_name
å¼å¯mysqld
3.éå½åææç表
CREATE DATABASE new_db_name;
RENAME TABLE db_name.table1 TO new_db_name.table1,
db_name.table2 TO new_db_name.table2;
DROP DATABASE db_name;
温馨提示:内容为网友见解,仅供参考