Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [Error Message] Encoding/MySQL 5.5?
#1
Not Solved
Hey all,
I moved to a new server and trying to upload my old MyBB forum to it (1.6.8).

I'll try to give as much information as possible so you can help me (Before I pay to my hosting for that service...)
(The forums TEXT in in Russion)

OLD SERVER INFO

Database server

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.1.70-cll - MySQL Community Server (GPL)
Protocol version: 10
User: ***@localhost
Server charset: UTF-8 Unicode (utf8)

Web server

cpsrvd 11.38.2.7
Database client version: libmysql - 5.0.96
PHP extension: mysql Documentation

MyISAM is the default storage engine on this MySQL server.
Unicode (multilingual), case-insensitive (Default)
DUMP FILES (QUICK MODE)

STRUCTURE
Link

DATA
Link

New server info

Server: Localhost via UNIX socket
Server type: Percona Server
Server version: 5.5.32-31.0-log - Percona Server (GPL), Release rel31.0, Revision 549
Protocol version: 10
User: ***@localhost
Server charset: UTF-8 Unicode (utf8)

InnoDB is the default storage engine on this MySQL server.
Unicode (multilingual), case-insensitive (Default)

cpsrvd 11.38.2.7
Database client version: libmysql - 5.0.96
PHP extension: mysql Documentation

Link to OLD (WORKING**) Forums
Forums

Link to NEW (ENCODING???**) Forums
Forums

Some notes:
* If you go to the OLD forums and click any link you will get different file! It something with the encoding in the database?
** So except deleting BOM, when I upload the DATA file I'm getting this error
*** Moving Joomla! does not did this kind of problem.
**** New server is running Server version: 5.5.32-31.0-log - Percona Server - Old server is running MySQL
  #1062 - Duplicate entry 'internal_settings' for key 'PRIMARY' 
After DELETING all lines with "internal_settings" (3 lines) AND DELETING NULNULNUL**** The data file load without errors BUT the forum.videoculinary.ru looks like it has an encoding error...


Help please.

Thanks in advance


Messages In This Thread
Encoding/MySQL 5.5? - by ArieKatz - 2013-09-29, 11:07 AM
RE: Encoding/MySQL 5.5? - by Matt - 2013-09-29, 11:22 AM
RE: Encoding/MySQL 5.5? - by ArieKatz - 2013-09-29, 11:24 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)