News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

How to backup and restore database with UTF-8 format ?

Started by target_locked, December 04, 2007, 01:33:49 AM

Previous topic - Next topic

target_locked

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.
SMF 1.1.4 now 1.1.8
¡uʍop ǝpısdn ɹoʇıuoɯ ʎɯ pǝuɹnʇ oɥʍ ¡ʎǝɥ

target_locked

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.
SMF 1.1.4 now 1.1.8
¡uʍop ǝpısdn ɹoʇıuoɯ ʎɯ pǝuɹnʇ oɥʍ ¡ʎǝɥ

Advertisement: