can't support utf-8?

  • Nobody/Anonymous


    My server is Apache/2.0.53 (Fedora),
    Mysql is 4.1.20
    PHP is 5.0.4,

    After backup UTF-8 DB, i view the sql and find that all data shows ????????

    Whether phpMyBackupPro support UTF-8?

    • Nobody/Anonymous

      I think i find out the reason.

      In phpMyAdmin, when i export utf-8 DB, i have to select "UTF-8" in the field of "Character set of the file", otherwise the db can't dump correctly.

      In phpMyBackupPro, it seems no such selection.

    • Nobody/Anonymous

      I am having the same problem.

      Getting the question marks..
      On my php scripts I use:

      mysql_query("SET NAMES utf8");   

      To handle the encoding correctly.

      MyBackupPro seems like a good program so I patched it:
      Using dreamweaver I searched for "mysql_connect" in every php file, then added those two lines after it.

      The backup and import now works like a charm.

    • Nobody/Anonymous

      In order to view the DB info in
      admin panel --> import, you need to edit:



      change to

  • vahid

    vahid - 2013-05-24

    To future friends who face problem with PhpMyBackupPro:
    Open file < > in the main directory of PMB and  simply find functions bellow, and replace the code:

    //implement core hack to support UTF8 Databases
    function PMBP_mysql_connect() {
    global $CONF;
    $res = @mysql_connect($CONF,$CONF,$CONF);
    if($res) {
    return $res;

    function PMBP_set_character_set() {
    $characterSet = 'utf8';//PMBP_get_character_set();
    @mysql_query("set names " . $characterSet);
    return $characterSet;

    best wishes
    Vahid Moslemi


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks