problems with mysql characters after restore the backup

Discussion in 'MySQL' started by puya4ever, Jul 14, 2009.

  1. #1
    Hi to everyone . I've restored my database because I have some problemes... all it's ok but I have one problem with MKD and Turkish characters ... it's show only " ? " and the post from forum (it's a forum) shows only like:
    ????? ?? ?????? ?? ??????? ?????? ?

    how to fix that...?
     
    puya4ever, Jul 14, 2009 IP
  2. ADVERTNETWORK

    ADVERTNETWORK Peon

    Messages:
    37
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    use bigdump to import your mysql large files may be u are getting this error because your mysql file size is so big or may be there is some problem in your mysql file chk it out please

    or may be fonts problem :D

    if someone have installed the fonts taht your character contains then it will be ok or if not installed it will creat ? or square box may be in my opinion
     
    ADVERTNETWORK, Jul 14, 2009 IP
  3. puya4ever

    puya4ever Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    this problem still persist
     
    puya4ever, Jul 15, 2009 IP
  4. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Could you explain :
    -how and with which tools you performed the backup
    -how and with which tools you perform the restore

    That would make it easier for the non-mind reading crowd to find out what you are doing and where you might be going the wrong way.
     
    chisara, Jul 15, 2009 IP
  5. puya4ever

    puya4ever Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I used export and import tool from phpmyadmin :
    [​IMG]
     
    puya4ever, Jul 15, 2009 IP
  6. HivelocityDD

    HivelocityDD Peon

    Messages:
    179
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I think this is something related the characterset of your database

    From command line after login to the mysql

    try the command

    status

    It will give you all the information of your character set . If it is latin1 you may need to change it to utf-8 to work with the special characters.
     
    HivelocityDD, Jul 16, 2009 IP
  7. puya4ever

    puya4ever Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    i don't have acces at mysql only at phpmyadmin
    I have tried in SQL to SET utf-8; and this problem still persist..:(
     
    puya4ever, Jul 17, 2009 IP