The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database Corrupted

Discussion in 'Database Discussions' started by Jags, Dec 8, 2010.

  1. Jags

    Jags Registered

    Joined:
    Dec 8, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Hi All,

    Recently I took a complete database backup using the CPanel data backup. When I restored the databackup I found that the posts made in a different language were showing as garbage on my forums. All the other posts were fine, but just the posts which were in any other language were corrupted.

    Please have a look..

    /http://www.just4dosti.com/index.php?action=profile;u=57 (signature was in HINDI language)

    /http://www.just4dosti.com/index.php?topic=2265.msg24330#msg24330

    /http://www.just4dosti.com/index.php?topic=657.msg27712#msg27712

    Just don't know what went wrong and what should have been done to avoid this.

    Thanks
     
  2. Jags

    Jags Registered

    Joined:
    Dec 8, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    No-one cared to reply.. :confused:
     
  3. garrettp

    garrettp Well-Known Member
    PartnerNOC

    Joined:
    Jun 18, 2004
    Messages:
    312
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    cPanel should retain the setting for the character set of the database when re-importing, but that may not have happened. If I had to guess, however, I'd say there's somehow now a discrepancy between what the forum expects for an encoding (i.e. UTF-8) and what the data is actually stored as in the database (e.g. the default of latin1). You should check this and ensure both are using the same character set specifications.
     
  4. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    A difference in character encoding can easily cause this type of problem, whether it is in the database or just the forum software (including its HTML & headers); the same character encoding should be configured throughout all areas.

    Was the entire forum installation restored from a cPanel account backup, or was it restored using some other method? Was the database restored as part of a cPanel account backup or separately after manually restoring or reuploading/reinstalling the forums software?
     
Loading...

Share This Page