Author Topic: Dump problems  (Read 2510 times)

0 Members and 1 Guest are viewing this topic.

Offline k1lljoy

  • Jr. Member
  • **
  • Posts: 79
    • View Profile
    • Razruha.Ru
Dump problems
« on: December 05, 2006, 02:04:32 PM »
Hi!
I`ve got a problem lately: I had to move my sites to the other hosting Co, I transferred all the data, nade the dumps...
But the problem is, that the new server has php5+mysql5 installed.

And when I import the dump - I get just ???? instead of all russian (cyrillic) symbols.

The hosting admin suggested the following procedure:
 - while importing set encoding cp1251 in phpmyadmin;
 - in operations - collation - also set cp1251_general_ci for that database.
And then I should put this code: mysql_query('set names cp1251'); in the php-file that connects to DB (after connection to DB but before the first query).

I tried to do all that - but the result is the same - I still have ?????? instead of all cyrillic (russian) symbols  :(
Although the dump opened on local computer in wordpad reads normally...

Please help  :roll: