justbenice
Fri 18th Aug '06, 12:17am
Hello
I got some very big problem with my forum and dont know what to do now :( I'v google around 2 days already and haven't found any solutions. I posting it here and hope anyone here have same problem so we can work it out.
I was running mysql 4.0 last years and my forum is UTF-8 charset. A whole forum is asian language , a few month ago i upgrade mysql to 4.1 and got some strange charset problem, it not a whole forum got problem, only some character ,i did not what to do so in the end i copy everything in /var/lib/mysql/databasename/ from 4.0Mysql to /var/lib/mysql/databasename/ 4.1Mysql, and it work great:D .Last week my forum got hacked and i have to restore my database, but a only one backup i have is from MySQL4.1 dump command in ssh which i backuped by a normall command : mysqldump abc > abc.sql . And a biggest problem happened, I got some strange character in my forum after restore that abc.sql to mysql 4.1 or 5.0 :( .
What should i do now ? Please help !
I got some very big problem with my forum and dont know what to do now :( I'v google around 2 days already and haven't found any solutions. I posting it here and hope anyone here have same problem so we can work it out.
I was running mysql 4.0 last years and my forum is UTF-8 charset. A whole forum is asian language , a few month ago i upgrade mysql to 4.1 and got some strange charset problem, it not a whole forum got problem, only some character ,i did not what to do so in the end i copy everything in /var/lib/mysql/databasename/ from 4.0Mysql to /var/lib/mysql/databasename/ 4.1Mysql, and it work great:D .Last week my forum got hacked and i have to restore my database, but a only one backup i have is from MySQL4.1 dump command in ssh which i backuped by a normall command : mysqldump abc > abc.sql . And a biggest problem happened, I got some strange character in my forum after restore that abc.sql to mysql 4.1 or 5.0 :( .
What should i do now ? Please help !