Advertisement:

Author Topic: How to backup and restore database with UTF-8 format ?  (Read 6642 times)

Offline target_locked

  • Jr. Member
  • **
  • Posts: 119
  • Gender: Male
How to backup and restore database with UTF-8 format ?
« on: December 04, 2007, 01:33:49 AM »
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ɥʍ ¡ʎǝɥ

Offline target_locked

  • Jr. Member
  • **
  • Posts: 119
  • Gender: Male
Re: How to backup and restore database with UTF-8 format ?
« Reply #1 on: December 04, 2007, 02:51:51 AM »
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ɥʍ ¡ʎǝɥ