News: Welcome to the TinyPortal Support site.

Login  |  Register
HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

July 16, 2019, 10:20:11 PM

Login with username, password and session length

Recent

Members
Stats
  • Total Posts: 188515
  • Total Topics: 20736
  • Online Today: 265
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 0
Guests: 29
Total: 29

Author Topic: Help - Charecter Set Issue when restoring DB  (Read 3633 times)

0 Members and 1 Guest are viewing this topic.

yeshaib

  • Guest
Help - Charecter Set Issue when restoring DB
« on: February 10, 2009, 11:18:22 PM »
So here is the deal, I know this is not a TP issue but I really need help....
I was with a crappy host and one of my sites was hacked.
long story short my DB is in 8859-8-i (Hebrew) I exported the DB to my computer and I can read it and convert it to UTF-8

When I import the file into a clean DB all i'm getting is "???????"
I've tried importing in UTF8 and in Latin1 and in Hebrew (8859-8) and no luck on anything

I googled this and found so many issues like mine but not solution.

Any ideas????

Thank
Yeshai

Offline G6Cad

  • Friends
  • *
  • Posts: 12643
    • FamiljeGodis
Re: Help - Charecter Set Issue when restoring DB
« Reply #1 on: February 10, 2009, 11:26:05 PM »
Why do you need to convert it in the first place ?
If you just import the db to your new host, it should work as it did on the other host.

yeshaib

  • Guest
Re: Help - Charecter Set Issue when restoring DB
« Reply #2 on: February 10, 2009, 11:28:52 PM »
Well it seems that when I export the DB from the old host to my system I can get the correct character set both UTF and ISO but when uploading both ways I still don't get my Hebrew :(
I just thought it might be simpler to move on to UTF so this won't happen again....

Offline agridoc

  • Languages
  • *
  • Posts: 942
    • Aeromodelling GR
Re: Help - Charecter Set Issue when restoring DB
« Reply #3 on: February 11, 2009, 12:05:39 AM »
long story short my DB is in 8859-8-i (Hebrew) I exported the DB to my computer and I can read it and convert it to UTF-8

How is this conversion done?
  For Greek aeromodellers and our friends around the world  - Greek Button sets for SMF

yeshaib

  • Guest
Re: Help - Charecter Set Issue when restoring DB
« Reply #4 on: February 11, 2009, 06:48:56 AM »
I download the SQL db to my system open it with EditPad Light
Encode the document at 8859-8-i (hebrew) and now I can see the hebrew
Convert it to UTF8

Offline G6Cad

  • Friends
  • *
  • Posts: 12643
    • FamiljeGodis
Re: Help - Charecter Set Issue when restoring DB
« Reply #5 on: February 11, 2009, 11:59:30 AM »
If you skip the convert to utf8 part, and import the DB to your new host, and then let SMF administration do the converting for you, have you tried that

Offline agridoc

  • Languages
  • *
  • Posts: 942
    • Aeromodelling GR
Re: Help - Charecter Set Issue when restoring DB
« Reply #6 on: February 11, 2009, 11:33:06 PM »
Database conversion needs data conversion and changing collation of tables and string fields inside them. I believe the latter is not done, so the errors.

Database conversion is sometimes a tedious task. The safest way is doing it with SMF. As G6 suggested move your site in the new host, check that it works as it should, then use SMF for database conversion after testing convert entities too.

You can also test in your PC if you have an Apache server like XAMPP.

Be sure to keep a backup for quite some time even after final switch.

  For Greek aeromodellers and our friends around the world  - Greek Button sets for SMF

yeshaib

  • Guest
Re: Help - Charecter Set Issue when restoring DB
« Reply #7 on: February 12, 2009, 12:08:17 AM »
How do I convert with SMF?

Offline G6Cad

  • Friends
  • *
  • Posts: 12643
    • FamiljeGodis
Re: Help - Charecter Set Issue when restoring DB
« Reply #8 on: February 12, 2009, 12:41:24 AM »
In your SMF admin /Maintenance/

Offline agridoc

  • Languages
  • *
  • Posts: 942
    • Aeromodelling GR
Re: Help - Charecter Set Issue when restoring DB
« Reply #9 on: February 12, 2009, 01:16:31 AM »
Better test first is a test install or a copy in your PC.

Not ever checked myself for TP tables - fields.
  For Greek aeromodellers and our friends around the world  - Greek Button sets for SMF