Hi All,
I would like to know the best way to back up and restore database with UTF-8 format.(multi language)
I am using SMF 1.1.4, and want to move my Forum to a new Server.
Thanks.
Problem solved,
backup and restore SMF database with UTF-8 charset:(the DB used in UTF-8 format)
PHPMyadmin can do everything if the DB is not too big.
Back-up:
Goto PHPMyadmin
Select SQL compatibility mode: MySQL 4.0
Export whole DB with structure, select zip or gzip for small size
Restore:
Create new DB and setup a fresh SMF
Import, specify source DB file select SQL type: MySQL 4.0
That's all.