Welcome to Geeklog Monday, November 20 2017 @ 11:25 pm EST


Status: offline

samstone

Forum User
Full Member
Registered: 29/09/2002
Posts: 820
What's your server control panel? Is it CPanel? Do you have a PHPmyAdmin?

Sam

Status: offline

trampoline

Forum User
Full Member
Registered: 24/02/2006
Posts: 392
I have OS X Server 10.4.11
SQL Administrator
Navicat
I could install PHPMYAdmin

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/2002
Posts: 820
I don't know about SQL Administrator, but PHPmyAdmin would let you easily dump the data the way you want it, or you have to use the commandline.

Sam

Status: offline

trampoline

Forum User
Full Member
Registered: 24/02/2006
Posts: 392
OK I have done it,
It took 20 minutes..
I used Mark's tutorial

at http://www.gllabs.org/wiki/doku.php?id=geeklog:utf-8

I downloaded ICONV with Darwin ports on my OSX machine.

I Used BBedit to change the Latin to utf-8 encoding (96) occurances in the text file.

Verified the output with ICONV

Uploaded the result to the new database

Changed the database that the site uses...

Done...

Thanks Everyone...


All times are EST. The time is now 11:25 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content